VAR
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
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 do not influence the result. If all values of a group are NULL, the result for this group is also NULL.
Examples
[1] Variance of column. |
[2] Get the variance by country. |
[3] Get the variance with nulls, grouped by country. |