distinctCountWithNull distinctCountWithNull
Counts the number of different values including the null values.
Category
Aggregation
Function syntax
distinctCountWithNull(<listAny>)
Parameters
Parameter
Type
List
listString
List
listBoolean
List
listInteger
List
listDecimal
List
listDuration
List
listDateTime
List
listDateTimeOnly
List
listDateOnly
Signature and returned type
distinctCountWithNull(<listAny>)
Returns an integer.
Example
distinctCountWithNull([10,2,10,null])
Returns 3.
recommendation-more-help
journeys-help