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

# Aggregate a report on count {#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 count aggregation gives the number of records in each element
of a 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.

The default aggregation is Count. The Count aggregation shows the number of records selected.

To show only unique records, select Count Distinct. For example, you want
to show the value for the distinct number of task types being performed. Task types being performed for multiple customers are counted multiple times unless you use Count Distinct.
These images compare Count and Count Distinct. The first shows that the raw count of for one column is 632. The second shows that the distinct count for the same column is only 8.
{#aggregate-report-count__table_sv3_nfh_3nb__entry__2}

| Count | Count Distinct |
|-|-|
|   |   |
[ ]

{#aggregate-report-count__table_sv3_nfh_3nb}

## Procedure

1. Navigate to AllReportsView / Run.
2. Select the report you want to aggregate.
3. On the Configure tab, choose Count or Count Distinct from the Aggregation list.
4. Select Run.

## Result

The sections of the visualization are grouped by the count of records.

*[\>]: and then