Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

Moving aggregation

Applies to: CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6


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, a window aggregation is recalculated.

MOVING_X ( table.column, start, end )

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