Counts the number of unique values within a column or group. This is an alias of the CountDistinct function and works the same way.
Usage
CountDistinct(Field)
Field (required) The column of values to be counted. Duplicate and Null values are skipped.
Example
CountDistinct([City])
- Finds the number of unique city names