Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
VAR calculates the variance per group. Variance can be applied to INT or FLOAT columns.
Syntax
VAR ( table.column )
Null handling
Null values are ignored, meaning that they don't influence the result. If all values of a group are null, the result for this group is also null.
Examples
Variance of column.
Query
Column1
VAR ( "Table"."Column")
Get the variance by country.
Query
Column1
"Table"."Country"
Column2
VAR ( "Table"."Values" )
Get the variance with nulls, grouped by country.
Query
Column1
"Table"."Country"
Column2
VAR ( "Table"."Values" )