Applying Aggregations - abrice/dz GitHub Wiki

Grouping numbers

When grouping is applied then the data for a column from multiple rows needs to be aggregated in some way. Several aggregation options are available. In this context, 'all values' mean all the values in the selected column from the rows in the current grouping:

• Sum: the sum of all values
• Mean: The mean of all values
• Median: The median of all values
• Max: The maximum of all values
• Min: The minimum of all values
• First: The first of all values
• Last: The last of all values
• Value: A comma-delimited list of all the values

Grouping strings

The mathematical calculations obviously wont work with strings but the following aggregation values will generate a return::

• First: The first of all values
• Last: The last of all values
• Value: A comma-delimited list of all the values