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. The field name cannot contain
spaces, dashes, or special characters, and must start with a letter. |
| 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 (not available with
Include All Rows)
- Number of rows (without field argument)
- Standard deviation (sample)
- Percentile (nearest-rank method).
|
| Value |
The aggregate value. |