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


---

# Interactive Analysis aggregations

# Interactive Analysis aggregations {#ariaid-title1}

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

When you work with Interactive Analysis, you can view data from the perspectives of
record counts, sums, averages, and distinct counts.

## Aggregation types {#interactive-analysis-aggregations__section_kdl_4qw_mbb}

Count

:   Count is the default aggregation and shows when you launch Interactive Analysis. The Count aggregation shows the number of records selected. For example, an analysis of incidents grouped by state, stacked by priority, and aggregated by count shows the number of incidents in each category in hints and in the cells of multidimensional reports.

Average, Sum, Count Distinct
:   Select Average, Sum, or
    Count Distinct, to show a list of fields from the selected
    Table. You may further 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.") Select a field to Aggregate by from this list. For example, if you select an integer field, such as
    Reassignment count, the data is expressed as a decimal value
    number. For more information, see [Column reports](https://servicenow-prod.fluidtopics.net/AiJW0VLfwB3~b2GYp0v3TA#c_CreateColumnCharts "Column reports show how the value of one or more items changes over time with columns.").
:   Note:  
    For duration values, the unit of measurement displayed in the aggregation axis cannot be customized.

    If you select Count Distinct, only unique records are
    counted. For example, you want to generate a report with a distinct number of users
    who have one or more of the roles in a given list of roles. Users with more than one
    role would be counted twice unless you use Count Distinct.