Common functions

In the expression editor, you can select the following common functions to be inserted quickly together with a field.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

Avg() returns the aggregated average of the expression or field iterated over the chart dimensions.

avg({[SetExpression] [DISTINCT] [TOTAL [<fld{, fld}>]]} expr)

Count() is used to aggregate the number of values, text and numeric, in each chart dimension.

count({[SetExpression] [DISTINCT] [TOTAL [<fld {,fld}>]]} expr)

Max() finds the highest value of the aggregated data. By specifying a rank n, the nth highest value can be found.

max({[SetExpression] [TOTAL [<fld {,fld}>]]} expr [,rank])

Min() finds the lowest value of the aggregated data. By specifying a rank n, the nth lowest value can be found.

min({[SetExpression] [TOTAL [<fld {,fld}>]]} expr [,rank])

Sum() calculates the total of the values given by the expression or field across the aggregated data.

sum({[SetExpression] [DISTINCT] [TOTAL [<fld {,fld}>]]} expr])

Learn more

Aggregation functions in charts

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here