---
sourceDocument: Australia Security Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/security-management

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Security Management

ft:clusterId :

    - security

bundleId :

    - security

workflow :

    - Technology


---

# Create a report using an aggregation

# Create a report using an aggregation {#ariaid-title1}

* Release version: Australia
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

To visualize and analyze the data specific to an aggregation that you created, generate a report by providing a condition for the aggregation in the condition builder.

## Before you begin

Role required: pa_admin

## Procedure

1. Navigate to AllReportsCreate New.
2. In the Data tab, fill in the fields.  
   {#generate-report__table_tjk_dj3_mvb__entry__2}

   | Field | Description |
   |-|-|
   | Report name | Name of the report. |
   | Source type | Type of the source from which data is fetched. Select Table. |
   | Table | Name of the table for which the aggregation is created. Select the aggregated results table Aggregated Result \[sn_vul_cmn_aggregate_result\]. |
   [Table 1. Data tab fields]

   {#generate-report__table_tjk_dj3_mvb}
3. In the condition builder, set the condition for your aggregation for which you want to generate a report.  
   {#generate-report__table_vvb_mrw_pvb__entry__2}

   | Part | Description |
   |-|-|
   | Field | Select Aggregation. |
   | Operator | Select is. |
   | Value | Name of the aggregation. |
   [Table 2. Condition in the condition builder]

   {#generate-report__table_vvb_mrw_pvb}
4. In the Data tab, select Next.
5. In the Types tab, select how you want to visualize the data and select Next.  
   For more information on the report types, see [Creating Reports](https://www.servicenow.com/docs/access?context=report-types-creation-details-rd&version=australia&pubname=australia-now-intelligence&ft:locale=en-US).

   The supported visualizations are bar chart, pie chart, and heatmap. You can modify the line graphs and other trends visualizations to make use
   of the supported visualizations with aggregated result to represent the same data. List view is not supported.
6. In the Configure tab, fill in the fields.  
   {#generate-report__table_qjt_wlp_pvb__entry__2}

   | Field | Description |
   |-|-|
   | Group by | Groups the data by the field selected. Here, select the field that you chose in the Grouped by 1 field in the [configure-indicator-for-source-data.html#configure-indicator-for-source-data__group-by](https://servicenow-prod.fluidtopics.net/ekDWS~K88dCK5B9JJ94B0g#configure-indicator-for-source-data__group-by) tab of the aggregation. |
   | Stack by | Organizes data in layers based on the field selected. Here, select the field that you chose in the Grouped by 2 field in the [configure-indicator-for-source-data.html#configure-indicator-for-source-data__group-by](https://servicenow-prod.fluidtopics.net/ekDWS~K88dCK5B9JJ94B0g#configure-indicator-for-source-data__group-by) tab of the aggregation. Note: Only bar and horizontal bar reports use stacked data. Other report types allow only grouping. |
   | Aggregation | Apply Minimum or Maximum function on Value. |
   [ ]

   {#generate-report__table_qjt_wlp_pvb}
7. In the Style tab, fill in the fields as appropriate and select Run.  
   For more information about the fields in Configure and Style tabs, see the [Creating a report](https://players.brightcove.net/6274575390001/nUx4EKfUz_default/index.html?videoId=6311434344112) video.
8. In the condition builder, set the condition for your aggregation for which you want to generate a report and select Run.  
   The report displays.
9. To sort the values on the X-axis, select Add sort.
   1. For strings, provide the condition as Grouped by \> a-z or z-a to sort the strings in an alphabetical order.
   2. For integer and date data type values, provide the condition as Grouped by.sort \> a-z or z-a to sort the values in ascending and descending order respectively.  
      Figure 1. Sorting integers on the X-axis
   3. Select Run.  
      The integer and date values get sorted on the X-axis.

   {#generate-report__substeps_x5l_djb_kyb}
10. Select Save to save your report.  
    The report that is generated for an aggregation displays in the Results tab of the respective Aggregation form.
11. **Optional:** Add your report to a dashboard.  
    For more information on how to add a report to a dashboard, see [Add a report to a responsive dashboard](https://www.servicenow.com/docs/access?context=add-report-to-dashboard&version=australia&pubname=australia-now-intelligence&ft:locale=en-US).

    The Vulnerability Management\[Aggregated\] dashboard consisting of reports created using the cached
    reporting framework is shipped with the base system. To view this dashboard, navigate to AllPerformance AnalyticsDashboardsAllVulnerability Management\[Aggregated\]. The active aggregations corresponding to the reports in this dashboard are shipped with the base system.
12. Share your report with other users.  
    For more information on how to share reports, see [Distribute reports](https://www.servicenow.com/docs/access?context=c_DistributeReports&version=australia&pubname=australia-now-intelligence&ft:locale=en-US).
**Related concepts**   

* [Aggregated reports framework](https://servicenow-prod.fluidtopics.net/Yma_GGBdOn_D_Gxt0KQTGw "Using aggregated reports framework, you can create reports for the data that involves complex and long-running on-the-fly queries for better performance.")  
**Related tasks**   

* [Configure an aggregation for source data](https://servicenow-prod.fluidtopics.net/ekDWS~K88dCK5B9JJ94B0g "To analyze the performance of a specific facet in a business process that is recorded in a ServiceNow table, create an aggregation specific to the facet and create a report for this aggregation.")
* [Run multiple aggregations simultaneously](https://servicenow-prod.fluidtopics.net/eytJ03ZOPnhjJr32zlrJkQ "You can schedule the execution of multiple aggregations using a single Aggregation schedule.")
* [Configure the number of aggregations that can run simultaneously](https://servicenow-prod.fluidtopics.net/FjzYHJ7JkestNV3YFa5qqA "A new processor or a background job, Aggregated Reporting Framework Processor is shipped with the base system, which executes the scheduled jobs that are related to the Aggregated Reports Framework table. This enables the entire subsystem to run in the background, and it allows better utilization of system resources when they’re available.")

*[\>]: and then