Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
This function calculates the standard deviation for samples per group. The standard deviation is using the "n-1" method. Standard deviation can be applied to INT or FLOAT columns.
Syntax
STDEV ( 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
Standard deviation of column.
Query
Column1
STDEV ( "Table"."Column")
Get the standard deviation by country.
Query
Column1
"Table"."Country"
Column2
STDEV ( "Table"."Values" )
Get the standard deviation with nulls, grouped by country.
Query
Column1
"Table"."Country"
Column2
STDEV ( "Table"."Values" )