Description

In general, only one aggregation is calculated for a query. With a global aggregation it is possible to calculate an additional aggregation function over all values of a column.

GLOBAL calculates an aggregation function for an aggregation to which all values are aggregated into one group.

Like normal aggregations, a global aggregation function take filters and selections into account. Values which are filtered out are not part of the result. Therefore if a filter or a selection is changed every global aggregation function is recalculated.

Syntax

GLOBAL ( aggregation )

• aggregation: The aggregation function including its parameters to use. Can be one of:
  • AVG ( table.column )
  • COUNT ( DISTINCT table.column )
  • COUNT_TABLE ( table.column )
  • COUNT ( table.column )
  • MAX ( table.column )
  • MEDIAN ( table.column )
  • MIN ( table.column )
  • QUANTILE ( table.column, quantile )
  • STDEV ( table.column )
  • SUM ( table.column )
  • TRIMMED_MEAN ( table.column )
  • VAR ( table.column )

Note

The result of GLOBAL can not be used as a grouper column for an aggregation.

Examples

See also:

• Aggregation Functions