Skip to main content

Celonis Product Documentation

MOVING_AVG
Description

This function calculates the average for each window. It can be applied to INT or FLOAT columns.

Syntax
 MOVING_AVG ( table.column, start, end )
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]

Moving average for current row and one row above.

Query

Column1 

         "Table1"."MONTH"

Column2 

         MOVING_AVG ( "Table1"."INCOME" , - 1 , 0 )

Input

Output

Table1

MONTH : int

INCOME : int

1

100

1

300

2

400

3

300

4

500

Result

Column1 : int

Column2 : float

1

100.0

1

200.0

2

350.0

3

350.0

4

400.0

[2]

Moving average for current row and one row above with null values.

Query

Column1 

         "Table1"."MONTH"

Column2 

         MOVING_AVG ( "Table1"."INCOME" , - 1 , 0 )

Input

Output

Table1

MONTH : int

INCOME : int

1

null

1

null

2

400

3

300

4

500

Result

Column1 : int

Column2 : float

1

null

1

null

2

400.0

3

350.0

4

400.0

[3]

Moving average for current row and one row above. A FILTER is applied, such that only rows with an INCOME value larger than 300 are taken into account.

Query

Filter 

         FILTER "Table1"."INCOME" > 300;

Column1 

         "Table1"."MONTH"

Column2 

         MOVING_AVG ( "Table1"."INCOME" , - 1 , 0 )

Input

Output

Table1

MONTH : int

INCOME : int

1

null

1

null

2

400

3

300

4

500

Result

Column1 : int

Column2 : float

2

400.0

4

450.0

See also: