Skip to main content

Celonis Product Documentation

Moving Aggregation
Description

Moving operators calculate a value across a range of neighboring rows. A range of neighboring rows, used for the calculation of a moving operator result is called window.

Moving operators take filters, selections and sorting into account. Values which are filtered out are not part of the result and which values are part of a window depends on the sorting. Therefore if a filter, selection or the sorting is changed an window aggregation is recalculated.

Syntax
 MOVING_X ( table.column, start, end )

Please note: The maximum window size [START, END] is limited to 1000.