Settings in Custom Reports

2. Aggregation and Grouping

The Custom report generator supports various aggregation and grouping operations at the column level. Depending on the data field selected, a set of possible aggregation methods is offered. Here is a full list of methods, along with their SQL function used internally:

• Comma separate distinct values: List of unique data points, separated by comma / GROUP_CONCAT(DISTINCT)
• Comma separate values: List of data points, separated by comma / GROUP_CONCAT()
• Count: Number of values in column / COUNT()
• Count distinct: Number of unique values in column / COUNT DISTINCT()

An aggregate function calculates on a set of values and returns a single value. Because an aggregate function operates on a set of values, it is often used in combination with the grouping operator (Unique values), which divides the result set into groups of value, where the aggregate function returns a single value for each group.