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


---

# Create a data visualization based on multiple data sets

# Create a data visualization based on multiple data sets {#ariaid-title1}

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

Here's a simple example of creating a report based on multiple datasets.

## Before you begin

Role required: Anyone with access to data can create a visualization of that data on any dashboard that they can edit. Users with the itil, report_user, admin, or viz_creator role can create a visualization in the Visualization Designer. If you create a visualization in the Visualization Designer, it is saved to the Library. For more information on access, see [Report_view access control](https://servicenow-prod.fluidtopics.net/17aJiqgCUPOrv8FkFCAkpA "The report_view operation is a record type access control list (ACL) that restricts access to reports. Only users who have one of the required roles can view reports that contain the restricted resource.") and [Platform Analytics roles](https://servicenow-prod.fluidtopics.net/8TGffADoM40mPhdhdpuM8g "Platform Analytics has both unique roles and roles from other applications that apply to it.").

## Procedure

1. Navigate to AllPlatform AnalyticsLibraryData Visualizations. {#create-dv-on-multiple-datasets__ph_yvn_xvt_4tb}
2. Select New.
3. For the purposes of this example, create a Vertical bar visualization based on the Incident \[incident\] table.  
   For more information, see [Create a horizontal or vertical bar data visualization](https://servicenow-prod.fluidtopics.net/Hpqs8mjOTCuKzS30_cL3gQ "Use bar visualizations to show information in segments that are proportional to the values they represent. Vertical bar and horizontal bar visualizations compare numeric values that represent either nominal or ordinal data.").
4. Add two data sources: the Incident \[incident\] table and the Problem \[problem\] tables.
5. For each data source, add the custom condition <kbd class="ph userinput">Active is true</kbd>.
6. In the Metric section, select the Count aggregation for both sources.
7. Group the visualization by Assignment Group.
8. Select Save and name the visualization <kbd class="ph userinput">Incidents and Problems by Assignment Group</kbd>.
9. **Optional:** To make the visualization easier to read, under Chart variation, select <kbd class="ph userinput">Side-by-side</kbd>.

*[\>]: and then