Skip to main content

Celonis Product Documentation

Moving Aggregation

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.

 MOVING_X ( table.column, start, end )

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