Multiple data sources
Some visualization types support multiple data sources, while others do not. If your data visualization supports multiple data sources, the data sources must all be of the same type: all tables, all indicators, or all another type.
| Visualization type | Multiple data source support |
|---|---|
| All time series (line, column, spline, area, and others) | Supported |
| All scores (single score, dial, gauge) | Not supported |
| All bars (horizontal, vertical, Pareto) | Supported |
| Heatmap | Not supported |
| Pies and donuts | Not supported |
| Pivot table | Supported |
| Bubble | Supported |
| Boxplot | Not supported |
| Calendar report | Not supported |
| Geomap | Not supported |
| Indicator scorecard | Not supported |
| Analytics list | Not supported |
Warning: If you select multiple data sources for a visualization and then change the visualization type to one that does not support multiple data sources, you keep only the first data source. Switching back to a visualization type that supports multiple data sources does not restore the previously selected data sources.
Parent Topic:Selecting data sources for data visualizations
Related topics
Select a table data source for a data visualization
Select an indicator data source for a data visualization
Select a Workflow Data Fabric data source for a data visualization
Usage Insights data sources for data visualizations
Example data visualization based on multiple data sources
Here's a simple example of a report based on the Indicator and Problem tables.
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. When 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
Navigate to All > Platform Analytics > Library > Data Visualizations.
Select New.
For the purposes of this example, create a Vertical bar visualization.
For more information, see Create a horizontal or vertical bar data visualization.
Under Data sources, select + Add data source.
Add the Incident [incident] table as a data source, with the custom condition
Active is true.
The Active is true condition on the Incident table data source.
Select + Add data source again and add the Problem [problem] table, also with the condition
Active is true.Data sources for a visualization must all be of the same type. Here they are tables.
Group both data sources by Assignment Group.
The second source is grouped automatically by the same field as the first source.
Group by assignment group for two table sources.
To make the visualization easier to read, under Chart variation, select
Side-by-side.Select Save and name the visualization
Incidents and Problems by Assignment Group.
Result
A vertical bar data visualization of Incident and Problem table data.