Aggregates table

The Aggregates table specifies the group you want to aggregate, the aggregation method, and the name of the resulting new field.

The Aggregates table contains the following columns:

Column	Description
Name	The name of the aggregate field.
Subject	The subject on which you want to use an aggregation method.
Type	The aggregate method. The aggregation methods are: Sum Average (Mean) Median Percentile (linear interpolation) Minimum Maximum Number of values (N) Concatenate strings separated by , (comma) First non-null value Last non-null value First value (including null) Last value (including null) Cumulative sum (all rows option only) Cumulative average (all rows option only) Standard deviation (Population) Concatenate strings that are separated by the character specified in the Value column Number of distinct values Number of rows (without field argument) Standard deviation (sample) Percentile (nearest-rank method).
Value	The aggregate value.