COUNT DISTINCT
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
This function calculates the number of distinct elements per group. Count Distinct can be applied on any data type.
Syntax
COUNT ( DISTINCT table.column )
NULL handling
NULL values are not counted. If all values of a group are NULL, the result for this group is 0.
Examples
[1] Count distinct elements of the column. |
[2] Count the number grouped by country. |
[3] Count the number of values mixed with nulls, grouped by country. |