Count distinct elements in an array

Question

I have a requirement where I have to find the distinct value in the grid column and display it 
 
 Any suggestion

Harshit Bumb (Appyzie) · Answer

union() the array by itself and then use the count() function

ajhick · Answer

Give this a go. 
 a!localVariables(
 local!values: {1,2,5,33,8,6,4,3,4,5,32,3,4,33,2,45,6,7,89,0,87,6,45,6345,35,6534,35,65,43,1,3,4,2},
 local!distinctValues: union(
 local!values,
 local!values
 ),
 local!countOfDistinctValues: if(
 a!isNullOrEmpty(local!distinctValues),
 0,
 length(local!distinctValues)
 ),
 {
 values: local!values,
 distinctValues: local!distinctValues,
 countOfDistinctValues: local!countOfDistinctValues
 }
)