Description

This function calculates the trimmed mean over an INT or FLOAT column.

The result of TRIMMED_MEAN is always a FLOAT column (Since:  CELONIS 4.5).

Lower and upper cutoff get rounded to the next smaller whole row number for each group (e.g. Trimmed mean over a group with 42 rows and a lower & upper cutoff of 10% will result in the cut of the upper & lower 4 rows). By default 5% of the lower and upper values are cut off.

If the of upper & lower rows cut is greater or equal to the count of the current group, trimmed mean will return 0 for this group.

Null values are ignored, meaning that they don't influence the result. If all values of a group are null, the result for this group is also null.

Syntax

TRIMMED_MEAN ( table.column [, lower_cutoff [, upper_cutoff ] ] )

• lower_cutoff: INT between 0 and 100
• upper_cutoff: INT between 0 and 100

Example