Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 

Description

The Pull-Up-Functions allow you to aggregate a column based on another table. You can define the parent table to which the child-tables entries are pulled, and you can explicitly define on which basis calculations are executed.

In contrast to the standard aggregation functions, the result of a PU function can be used as an input for another aggregation.

Filter expressions can be defined to specify which values should be taken into account for the aggregation.

A 1:N relationship between the parent and child table is required.

Syntax

PU_X ( parent_table, child_table.column [, filter_expression] ) 

where PU_X is one of

• PU_AVG
• PU_COUNT_DISTINCT
• PU_COUNT
• PU_SUM
• PU_MAX
• PU_MEDIAN
• PU_MIN

PU_X ( parent_table, child_table.column [, filter_expression] [, order by expression] ) 

where PU_X is one of

• PU_FIRST
• PU_LAST

PU_QUANTILE ( parent_table, child_table.column, quantile [, filter_expression] )

• PU_QUANTILE

Filter behavior

The way PU functions handle filters is different compared to the standard aggregation. In contrast to the standard aggregation, PU functions ignore filters, meaning that if a filter or a selection is changed, the result of the PU function is not recalculated. Another difference to the standard aggregation is that it is possible to filter on the result of a PU function.