Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

Window aggregation

Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6

Description

Window functions calculate an aggregate value based on a range of neighboring rows.

  • Moving aggregation functions 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.

  • RUNNING_TOTAL sums up all entries of a given column and returns all intermediate sums.