Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
This aggregate function calculates the average of a set of values.
AVG calculates the average of an INT or FLOAT column. The data type of the result is the same as the data type of the input column.
Syntax
AVG ( table.column )
Null handling
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.
Tips
If the size of the source column greatly exceeds the number of aggregated groups, the average for each group will be executed in parallel. Therefore, to achieve a good performance, multiple CPU cores and balanced aggregation (as described) are preferable (Since: CELONIS 4.3).
Examples
Calculating the average of four small integers:
Query
Column1
AVG ( "Table1"."Column" )
Calculating the average of values grouped by country:
Query
Column1
"Table1"."Country"
Column2
AVG ( "Table1"."Values" )
Calculating the average of values mixed with nulls, grouped by country:
Query
Column1
"Table1"."Country"
Column2
AVG ( "Table1"."Values" )