COUNT
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 counts the rows of a column per group. It can be applied on columns of any data type.
Use the COUNT DISTINCT function to count only the unique values in a group.
Syntax
COUNT ( 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 elements of the column. |
[2] Count the number of values grouped by country. |
[3] Count the number of values mixed with nulls, grouped by country. |