Ndv
The Ndv function returns the number of unique values within a column or group. This is an alias of the CountDistinct function and works similarly.
Syntax
Ndv(column)
Function arguments:
- column (required) - The column of values to be counted. Duplicate and Null or empty values are not counted.
Example
Ndv([City])
- Finds the number of unique city names.