Function Index

Ndv

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.

Examples

CountDistinct([City])
  • Finds the number of unique city names