Aggregation in Core UI reporting

---
title: Aggregation in Core UI reporting
description: Aggregation enables you to apply calculations to data displayed in reports.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/now-intelligence/reporting/aggregation-reporting.html
release: australia
product: Reporting
classification: reporting
topic_type: reference
last_updated: "2026-09-10"
reading_time_minutes: 2
breadcrumb: [Core UI Reporting reference, Core UI Reporting, Reporting, dashboards, and Performance Analytics in the Core UI, Platform Analytics]
---

# Aggregation in Core UI 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](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/reporting/t_AccessFieldExtendedTable.md).

For information about aggregating on FX currency values, see [FX Currency values in reporting](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/reporting/fx-currency-values-reporting.md).

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

-   **[Aggregate a report on count](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/reporting/aggregate-report-count.md)**  
When you create a report, you can aggregate the data on several calculations including the number of records, averages, and standard deviation. The count aggregation gives the number of records in each element of a visualization.
-   **[Aggregate a report on averages](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/reporting/aggregate-report-average.md)**  
When you create a report, you can aggregate the data on several calculations including the number of records, averages, and standard deviation. The sum aggregation shows the sum of the field you aggregate on.
-   **[Aggregate a report on sum](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/reporting/aggregate-report-sum.md)**  
When you create a report, you can aggregate the data on several calculations including the number of records, averages, and standard deviation. The sum aggregation shows the sum of the field you aggregate on.
-   **[Aggregate a report on minimum or maximum](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/reporting/aggregate-report-max-min.md)**  
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.
-   **[Aggregate a report on standard deviation](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/reporting/aggregate-report-standard-dev.md)**  
When you create a report, you can aggregate the data on several calculations including the number of records, averages, and standard deviation. The standard deviation aggregation shows variation from average values for a duration or numeric field in a visualization.

**Parent Topic:**[Core UI Reporting reference](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/reporting/reporting-reference.md)