Counts the number of unique values within a column or group.
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
See Also