---
sourceDocument: Brazil Platform Analytics
sourceDocumentLink: https://www.servicenow.com/docs/r/now-intelligence

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Aggregation in Core UI reporting

# Aggregation in Core UI reporting {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](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://www.servicenow.com/docs/baz6aTzXUHS5uqOnAY7Srw#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://www.servicenow.com/docs/AYmSgS~_SEHS7GUAAa_3ZA#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.
* **[Aggregate a report on count](https://www.servicenow.com/docs/AXDrcj2HAe3Qp0IrpeeXaA)**   
  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://www.servicenow.com/docs/5ZeyXy4y6rIdz_drbfUpGg)**   
  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://www.servicenow.com/docs/~z0uBWXhUMiaFPKf3aFjEg)**   
  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://www.servicenow.com/docs/aGXasYeXbM45eoyGqPaGZg)**   
  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://www.servicenow.com/docs/kxSNLDLLN~8k5qHG~~rReg)**   
  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.