Multiple data sources

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

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

    Table 1. Multiple data source support by visualization 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.

    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

    1. Navigate to All > Platform Analytics > Library > Data Visualizations.
    2. Select New.
    3. For the purposes of this example, create a Vertical bar visualization.
      For more information, see Create a horizontal or vertical bar data visualization.
    4. Under Data sources, select + Add data source.
    5. 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.
    6. 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.
    7. 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.
    8. Optional: To make the visualization easier to read, under Chart variation, select Side-by-side.
    9. Select Save and name the visualization Incidents and Problems by Assignment Group.

    Result

    Figure 1. Data visualization with two data sources
    A vertical bar data visualization of Incident and Problem table data.