Returns the number of distinct elements in a column.
Determine the number of different (distinct) models sold.
Determine the number of different models sold by city.
distinct(<object> expr, [groupBy(...)])
- expr : any Incorta data type
groupBy: optional grouping function
longor as many
longs as there are groups if
You must include all the leading grouping dimensions in the Insight from the top-down to the level-based measure you want to evaluate. See Aggregation with Level Based Measure in Aggregating Functions.