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.4) | 7 Filtering >> |