Skip to main content

Celonis Product Documentation

VAR
Description

VAR calculates the variance per group. The variance is the square root of the standard deviation. Variance can be applied to INT or FLOAT columns.

Syntax
 VAR ( table.column )
NULL handling

NULL values are ignored, so they do not influence the result. If all the values of a group are NULL, the result for this group is also NULL.

Examples

[1]

Variance of column.

Query

Column1

         VAR ( "Table"."Column" )
        

Input

Output

Table

Column : int

1

2

3

Result

Column1 : float

1.0

[2]

Variance by country.

Query

Column1

         "Table"."Country"
        

Column2

         VAR ( "Table"."Values" )
        

Input

Output

Table

Country : string

Values : int

'US'

1

'DE'

4

'DE'

4

'FR'

5

'US'

2

'US'

3

Result

Column1 : string

Column2 : float

'DE'

0.0

'FR'

0.0

'US'

1.0

[3]

Variance with nulls, grouped by country.

Query

Column1

         "Table"."Country"
        

Column2

         VAR ( "Table"."Values" )
        

Input

Output

Table

Country : string

Values : int

'FR'

10

'FR'

null

'DE'

null

Result

Column1 : string

Column2 : float

'DE'

null

'FR'

0.0

See also: