MOVING_VAR
Applies to: CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
Calculates the variance for each window. It can be applied to INT or FLOAT columns.
Syntax
MOVING_VAR ( table.column, start, end )
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.
Tips
A group with only one non-NULL value will give the result NULL, since variance of one value only is undefined.
Examples
[1] Moving variance for current row and one row above. |
[2] Moving variance for current row and one row above with null values. |
[3] Moving variance for current row and one row above. A FILTER is applied, such that only rows with an INCOME value less than 500 are taken into account. |