distinctCount
Counts the number of different values ignoring the null values.
Category
Aggregation
Function syntax
distinctCount(<listAny>)
Parameters
Parameter
Type
List
listString
List
listBoolean
List
listInteger
List
listDecimal
List
listDuration
List
listDateTime
List
listDateTimeOnly
List
listDateOnly
Signature and returned type
distinctCount(<listAny>)
Returns an integer.
Example
distinctCount([10,2,10,null])
Returns 2.
recommendation-more-help
4f4a00c1-77c9-4eee-84df-bbe6206c3ab9