Basic aggregation functions in charts

FirstSortedValue() returns the value of one field based on the sorted values of another field. For example, the product with the lowest unit price.

firstsortedvalue([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] value, sort_weight [,rank])

max([{SetExpression}] [DISTINCT] [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}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr [,rank])

Mode() finds the most commonly-occurring value, the mode value, in the aggregated data. The Mode() function can process text values as well as numeric values.

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

Only() returns a value if there is one and only one possible result from the aggregated data. For example, searching for the only product where the unit price =9 will return NULL if more than one product has a unit price of 9.

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

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

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