6.2.3 Aggregation Functions

Table 2. List of Aggregation Functions

Sum

The additive sum of all values.

Average

The arithmetic mean of all values.

Count

The number of items.

Distinct Count

The number of unique values.

Max

The maximum value, highest number, latest date.

Min

The minimum value, lowest number, earliest date.

Product

The result of multiplication of all values in the column.

Concat

If a column has Strings, the result is a concatenated String of all values in the column.

Standard Deviation

A statistic that is a measure of dispersion in a distribution. The square root of the variance.

Variance

Another statistic that measures dispersion.

Population Standard Deviation

Dispersion within the current subset. The square root of the population variance.

Population Variance

Another measure of dispersion within a subset. Consult a resource on statistics.

Median

The middle value in a sorted list.

Mode

The most frequently occurring value.

<< 6.2.2 Column Features © 1996-2013 InetSoft Technology Corporation (v11.5) 7 Filtering >>