Multi Series ChartsLast Updated: 09/20/2018 Introduced in Version: 3.2
This tutorial demonstrates how to add Multiple Series to the Chart views on the Report. Note: in order to add multiple series to the chart view, several Report Subtotals should be defined. Not any type of chart view can have multiple series. Multiple Series are available for: Areas, Bars, Bubbles, Columns, Dots, Lines and Stacked Bars. Multiple Series can be used on the chart views of the Report when we need to visually represent multiple pieces of data that is related to the single object from the Grouped column.
Navigate to the Designer Folder and click Create Report > Create Report from Folder Actions Panel.
In the resulting window, Name the Report and select Create to proceed to the Report Designer.
In the Report Designer add Data Sources for the Report. Expand Data Sources > Common > Folder Data Sources category.
Next, add desirable Columns from the Data Source tables to populate the Report with data.
Group the Report by Entity Folder ID and Folder Type Name.
In the Report Designer select View > Add button.
Then, pick Bars type from Charts category.
In the Add Chart dialog, Name the Title.
Then, in the Report settings, locate Results category and select Add New under Sub Totals text-box.
In the Add Chart dialog, Name the View. Then, from the Field drop down select Entity Folder ID. Then chose Count as the Aggregation Type.
Next, we Add second Subtotal
For the second Sub Total chose Nesting Level Field with Average Aggregation type.
In the Report Designer, select Multi Series Chart to view the bars chart that was added previously. Within the Properties section, under Chart Data add the two sub totals that was created earlier in this example.
The Chart updates and shows the Multi Series.