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

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

Syntax
MOVING_X ( table.column, start, end )

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