Create a data visualization based on multiple data sets

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 and Platform Analytics roles.

Procedure

1. Navigate to All > Platform Analytics > Library > Data Visualizations.
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.
4. Add two data sources: the Incident [incident] table and the Problem [problem] tables.
5. For each data source, add the custom condition Active is true.
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 Incidents and Problems by Assignment Group.
9. Optional: To make the visualization easier to read, under Chart variation, select Side-by-side.