Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
Count calculates the number of elements per group. It can be applied on any data type.
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
Count elements of the column.
Query
Column1
COUNT ( "Table1"."Column1" )
Count the number of values grouped by country.
Query
Column1
"Table1"."Country"
Column2
COUNT ( "Table1"."Values" )
Count the number of values mixed with nulls, grouped by country.
Query
Column1
"Table1"."Country"
Column2
COUNT ( "Table1"."Values" )