Window aggregation
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
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.