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

Signature and returned type

distinctCount(<listAny>)

Returns an integer.

Example

distinctCount([10,2,10,null])

Returns 2.

On this page