An aggregation function aggregates over the set of possible records defined by the selection, and returns a single value describing a property of several records in the data, for example a sum or a count.
Most aggregation functions can be used in both the data load script and chart expressions, but the syntax differs.
Using aggregation functions in a data load script
Aggregation functions can only be used in field lists for LOAD statements with a group by clause.
Using aggregation functions in chart expressions
The argument expression of one aggregation function must not contain another aggregation function.
The expression must not contain aggregation functions, unless these inner aggregations contain the TOTAL qualifier. For more advanced nested aggregations, use the advanced aggregation function Aggr, in combination with calculated dimensions.
An aggregation function aggregates over the set of possible records defined by the selection. However, an alternative set of records can be defined by using a set expression in set analysis.