Aggregate a report on minimum or maximum

When you create a report, you can aggregate the data on several calculations including the number of records, averages, and standard deviation. The maximum and minimum aggregations show the maximum or minimum value for each segment of the visualization.

Before you begin

Role required: itil, report_user, report_group, report_global, report_admin, or admin. To create a meaningful report, you must have the right to access the data you want to report on.

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.

These 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

Procedure

1. Navigate to All > Reports > View / Run.
2. Select the report that you want to aggregate.
3. On the Configure tab, choose Maximum or Minimum from the Aggregation list.
4. Select Run.

Result

The sections of the visualization are grouped by the highest or lowest value for the selected records.