Aggregation in reporting

Aggregation enables you to apply calculations to data displayed in reports.

The count aggregation gives the number of records in each element of a report. Count distinct provides the count of unique values for a given field. Average shows the arithmetic mean of the values for a given field. Sum shows the total of the aggregated values. Minimum and Maximum show the least or greatest values for each displayed category. Standard deviation shows data variation from the average value for a given field.

If you choose Average , Sum , Count Distinct , Minimum , Maximum , or Standard deviation , you may be able to aggregate on fields from extended tables. See How to report on extended tables .

For information about aggregating on FX currency values, see FX Currency values in reporting .

Note: Aggregation is not supported on histogram, pareto, single score, box, calendar, and list reports.

Count aggregations The default aggregation is Count . The Count aggregation shows the number of records selected.

To show only unique records, select Count Distinct . For example, you want to show the value for the distinct number of task types being performed. Task types being performed for multiple customers are counted multiple times unless you use Count Distinct .

The following images compare Count and Count Distinct. The first shows that the raw count of for one column is 632. The second shows that the distinct count for the same column is only 8.

Count Count Distinct

For more information about implementing a report on the Count and Count Distinct aggregations, see Aggregate a report on count .

Average Average shows the arithmetic mean of the field you aggregate on. For example, select a duration field. The aggregated data is expressed in terms of days, hours, minutes, and seconds. (You can configure durations to show the level of detail you want.) If you select an integer field, such as Priority , the data is expressed as a decimal value number.

When you choose the average aggregation, you can also specify the Percentage calculation The percentage calculation is displayed when you select Show data table . Use Aggregation

Shows the percentage as a part of the total amount of averages in a column called Percentage of Average . In this data table, for example, the average duration of the Inquiry, Network, and Software incidents was approximately one day and 16 hours or 30% (or so) of the total average business duration. Average hardware incidents took 12 hours, approximately 9% of the total average business duration for incidents.

Use Record Count

Shows the number of records in each category as a percentage of the total number of records in the visualization in a column called Percentage of Incidents . In this data table, we see the same Average Business Duration for each category, but the percentage is of the number of incidents in that category. For example Inquiry incidents are approximately 17% of all incidents, and software incidents are approximately 77% of all incidents, though the average time to solve these incidents is still 30% (or so). On the other hand, Hardware incidents are less than 1% of all incidents, but the average duration is 9% of the total average time to solve.

Average duration Average priority

For information about implementing a report with the Average aggregation, see Aggregate a report on averages .

Sum Select Sum to show the sum of the field you aggregate on. For example, select a duration field. The aggregated data is expressed in terms of days, hours, minutes, and seconds. (You can configure durations to show the level of detail you want.) Select an integer field, such as Priority , and the data is expressed as a whole number.

For information about implementing a report on the Sum aggregation, see Aggregate a report on sum .

Minimum and Maximum Select Minimum or Maximum to show the maximum or minimum value for each segment of the report. For example, apply the Maximum aggregation to incidents grouped by priority. The report shows a bar for the incident in each priority with the highest business duration.

The following images illustrate maximum and minimum duration using grouped bars to show the different priorities of each category of incident side by side. Stacked bars give the illusion that the element on top of the stack has a greater value. In fact, the bar is only showing the relative value of the two elements. Maximum duration Minimum duration

For information about implementing a report on the Minimum or Maximum aggregation, see Aggregate a report on minimum or maximum .

Standard deviation Select Standard deviation (SD) to see variation from average values for a duration or numeric field. For example, apply the Standard deviation aggregation to business duration of incidents. The report shows deviation from the average business duration of incidents in each priority.

Standard deviation is always expressed in the same unit as the data. In the following example, the data is in time units and so is the SD.

For information about implementing a report on the standard deviation aggregation, see Aggregate a report on standard deviation .