Aggregates table

Use this table to specify the group you want to aggregate, the aggregation method, and the name of the resulting new field. Click Get lookup fields to specify the fields to include in a group. See the Group By step for more details.

Column	Description
Name	The name of the aggregate field.
Subject	The subject on which you want to use an aggregation method.
Type	The type of aggregation method for grouping the rows. The following methods are available: Sum Average (Mean) Median Percentile 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) Standard deviation Concatenate strings that are separated by the character specified in the Value column Number of distinct values Number of rows (without field argument).
Value	The aggregate value.