MOVING_STDEV
Applies to: CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
This function calculates the standard deviation for each window. It can be applied to INT or FLOAT columns.
Syntax
MOVING_STDEV ( 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.
Examples
[1] Standard deviation for current row and one row above. |
[2] Standard deviation for current row and one row above with null values. |
[3] Standard deviation 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. |