---
sourceDocument: Xanadu Platform Analytics
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/now-intelligence

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Aggregate a report on minimum or maximum

# Aggregate a report on minimum or maximum {#ariaid-title1}

* Release version: Xanadu
* 
* Updated May 9, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

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 {#aggregate-report-max-min__section_bcf_zhf_3nb}

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.{#aggregate-report-max-min__table_zpn_z4h_4nb__entry__2}

| Maximum duration | Minimum duration |
|-|-|
|   |   |
[ ]

{#aggregate-report-max-min__table_zpn_z4h_4nb}

## Procedure

1. Navigate to AllReportsView / 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.

*[\>]: and then