---
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


---

# Aggregation in reporting

# Aggregation in reporting {#ariaid-title1}

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

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.

{#aggregation-reporting__ul_zhl_vm3_3nb}

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://servicenow-prod.fluidtopics.net/sTKYkU8BlGjtGq5o389oIQ#t_AccessFieldExtendedTable "Learn how to include fields from tables that extend the Task table in a single report. For example, you could include both incidents and problems in a single report.").

For information about aggregating on FX currency values, see [FX Currency values in reporting](https://servicenow-prod.fluidtopics.net/e~IjFe5Vygo0I94y10KrdA#fx-currency-values-reporting "Manage projects in multiple currencies with FX (Foreign Exchange) Currency. You can report on the projects in currency values entered by the user, a reference currency, or both.").  
Note:  
Aggregation is not supported on histogram, pareto, single score, box, calendar, and list reports.