Overview
When writing reports you will often have a need to summarise figures rather than displaying transaction level data (that is, returning individual transactions rather than a total or count). Aggregations are the method used to summarise fields.
The aggregation functions available are Sum, Average, Min, Max, Count, and Count Distinct.
|
Sum of all values returned in the table. These sums may be split up by dimension fields to create sums for each category value. For example, the sum invoiced amount by each year. |
|
Average value of the items returned in the table. The average may be split up by dimension fields to create averages for each category value. For example, average age of customer by demographic. |
|
Minimum value returned in the table. These may be split up by dimension fields to find the minimum value for each category value. For example, the minimum rating per camp. |
|
Maximum value returned in the table. These may be split up by dimension fields to find the maximum value for each category value. For example, the maximum number of complaints by telephone operator. |
|
Count of the number of items returned in the table. These may be split up by dimension fields to find the number of items for each category value. For example, count the number of calls received by operator, by hour. |
|
Count of the number of Distinct items returned in the table. These may be split up by dimension fields to find the number of distinct items for each category value. For example, count the number of customers who called, by operator, by hour. |
Changing Aggregation
To change a metric aggregation, complete the following:
- Move your cursor over the metric object in the box and click on the metric name. The item will now be highlighted.
- Now select the aggregation type that you wish to apply - you will notice that the icon on the left hand side of the measure object will be updated with a new icon to indicate the aggregation applied.
Removing Aggregation
To remove an aggregation or advanced function from a field, do one of the following:
- Reset the calculation by selecting the metric and clicking the clear link.
- Remove the measure from the report entirely by dragging it out of the columns section.