CountDistinct

The CountDistinct function returns the number of unique values within a column or group.

Syntax

CountDistinct(column)

Function arguments:

• column (required) The column of values to be counted. Duplicate and Null or empty values are not counted.

Example

CountDistinct([City])

• Returns the number of unique city names.