Aggregate Functions

If attributes are returned in the Aggregated retrieval mode, they are first passed through a function before being displayed. These functions are:

Function

Returns

average

The calculated average of the grouped values. Available if the attribute is numeric.

min

The minimum value in the grouped values.

max

The maximum value in the grouped values.

count

The number of returned values in the grouping interval.

sum

The calculated sum of the grouped values. Available if the attribute is numeric.

std dev

The calculated standard deviation of the grouped values. Available if the attribute is numeric.

NOTE: By default, the min function is used on aggregate data.