Using multiple datasets in a report
-
- UpdatedJan 30, 2025
- 3 minutes to read
- Yokohama
- Reporting
You can create reports that use datasets from up to five tables in a single report.
The following report types support multiple datasets: bar, horizontal bar, column, line, step line, area, spline.
Multiple Group bys are not supported on multiple datasets. When using multiple datasets, the report legend is always displayed.

Restrictions
Bear the following restrictions in mind when creating a report with multiple data sets:
- Up to a maximum of 5 additional datasets can be added to any particular report. Keep in mind that each additional dataset will require additional processing and querying of the database, so if a particular report is experiencing performance issues, it could be due to the fact the report has multiple data sets associated.
- All datasets associated with a parent report must be of the same type (such as bar, donut, or pie) as the parent report.
- For multiple datasets associated with a time series chart, all additional data sets must have the same setting in the Per field as the parent report.
- For multiple datasets on a Bar or Horizontal Bar chart, all associated datasets must have the same Group By value.
- The Show Legends option is always, by default, displayed on a report with multiple datasets, even if the parent report has this option unselected.
Add an additional dataset to a report
Add up to five extra datasets to visualize data from multiple sources in a single report.
Before you begin
Procedure
Result