Add an extra dataset to a report

Add an extra dataset to a report to show data from multiple sources in a single report.

Before you begin

Role required: itil

Performance Analytics premium must be enabled to use multiple data sets.

The property glide.ui.doctype must be enabled.

Procedure

  1. Navigate to Reports > View/Run.
  2. Select a report with a type that supports multiple datasets, such as a bar chart or time series chart.
  3. Select Save > Multiple dataset from the report options from the upper right of the report form.
  4. Click the New Series tab.
  5. Configure the new dataset using standard report builder options, such as to specify the data source, chart type, grouping and filtering, and color options.
  6. (Optional) Select Show in y Axis to add an extra Y axis to the chart for this dataset.
    Additional Y axes appear on the right side of the chart.
  7. (Optional) If you selected Show in y Axis, define the Y-axis label in the Title field, and set minimum and maximum values to show on the Y axis.
    Warning: The Y axes may show a greater range than specified in the From and To fields, depending on the actual Y values for all datasets. The From and To field values from the parent report may also be overridden. This behavior ensures that all data can be accurately displayed on the chart.
  8. Click Save.