CountDistinct

Description

CountDistinct counts the number of distinct non-null values.

Syntax

CountDistinct(value)

Parameters

Parameter	Required	Type	Description
value	Yes	Field or expression	Values whose distinct count is required.

Notes

Aggregate functions are commonly used in metric definitions and grouped query results.

Example

CountDistinct(CustomerID)

The expression returns the calculated result according to the current query context.