Add an additional dataset to a report to visualize data from multiple sources in a
Role required: itil
Performance Analytics Premium must be enabled to use multiple
The property glide.ui.doctype must be
You can add additional datasets to bar, horizontal bar, line, column, area,
and spline reports.
The following limitations apply to specific report types.
- All datasets must be the same type. For example, if the base report uses a time series
chart, other datasets added to the report must also use a time series chart.
- If using time series charts, all datasets must have the same Per
field value to ensure that the frequency interval is the same for all data.
- If using bar or horizontal bar charts, all data must have the same Group
- Legends are always visible on reports with multiple datasets, even if the
Show legend option is disabled in the Style Options of the
Select a report with a type that supports multiple datasets.
Select Multiple dataset from the report options list on the top
right of the report form.
Configure the data series the same way that you would configure a standalone report.
The following options are specific to multiple datasets:
||[Optional] Specify a custom name for this dataset in the legend of the
||For bar and horizontal bar reports, Group by must be
the same as the specified in base report.
|Show in yAxis
||[Optional] Add an extra Y axis on the right side of the report for this
||[Optional] You can define the Y axis label in the
Title field, a
From and To fields
||[Optional] Specify custom start and end values for the additional Y
Warning: When using multiple datasets with separate Y axes, the
Y axes may display 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