Skip to main content

PQL47 (PQL Function Library - CPM 4.7)


Applies to: CELONIS 4.7


Window functions and operators perform calculations in a partitioned table.

The following window functions are available:

  • INDEX_ORDER indexes rows inside a partition based on the provided sorting.

  • LEAD and LAG can be used to reference a following or previous row for every input row inside the partition.

  • RUNNING_SUM returns the sum of the previous rows inside the partition.