Multi Series Charts
  • Updated on 03 Jul 2015
  • 1 minute to read
  • Print
  • Dark
    Light

Multi Series Charts

  • Print
  • Dark
    Light

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.

Example:

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.
2018-09-19_142415.jpg

In the Report Designer add Data Sources for the Report . Expand Data Sources > Common > Folder Data Sources category.
2018-09-19_142537.jpg

Next, add desirable Columns from the Data Source tables to populate the Report with data. 
2018-09-19_142729.jpg

Group the Report by Entity Folder ID and Folder Type Name.
2018-09-19_142804.jpg

In the Report Designer select View > Add button*.*
Then, pick Bars type from Charts category.
2018-09-19_142825.jpg

In the Add Chart dialog, Name the Title
2018-09-19_142925.jpg

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.
2018-09-19_143231.jpg

Next, we Add second Subtotal
For the second Sub Total chose Nesting Level Field with Average Aggregation type.
2018-09-19_143320.jpg

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.
2018-09-19_143354.jpg

Was this article helpful?