---
title: Aggregation in 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-03-12"
reading_time_minutes: 1
breadcrumb: [Reporting reference, Reporting, Reporting, dashboards, and Performance Analytics in the Core UI, Platform Analytics]
---

# 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](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.