Use Charts to Visualize Grouped Data

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Dashboards and Reports Customization Guide > Designing Reports > Use Report Elements > Use Charts 

Use Charts to Visualize Grouped Data

This topic describes how to use charts to visualize grouped data in a report.

 

eurd-web-chart-in-group-footer

 

In this tutorial, the report data is grouped against a data field (the report's group field). A chart is placed in the Group Footer band and is not bound to data. The report's data source is used to populate the chart with data.

 

eurd-web-chart-group-footer-report-layout

 

Follow the steps below to make each chart instance display data for its group.

 

1.Create a chart parameter to pass a group value from the report's group field to the chart.
 
Select the chart and expand the Data group in the Properties panel. Click the plus button next to the Parameters property.
 
eurd-web-chart-add-parameter
 
Set the parameter's Binding property to the report's group field.
 
eurd-web-chart-bind-parameter
 

2.Click Run Designer to invoke the Chart Designer.
 
eurd-web-chart-run-designer
 

3.Bind the chart to data. Specify the Data Source and Data Member fields.
 
eurd-web-chart-bind-to-data-designer
 

4.Add a new series. Click the plus button next to the Series item in the Chart Designer.
 
eurd-web-chart-designer-add-series
 

5.Provide data for the argument and value axes. Set the Argument Data Member and Value properties.
 
eurd-web-chart-designer-groups-bind-series-to-data
 

6.Filter the chart. Click the Filter String property's ellipsis button.
 
eurd-web-chart-for-groups-designer-filterstring
 
Add a filter condition. On the left side, specify the field by which chart data should be filtered.
 
eurd-web-chart-for-groups-create-filterstring
 
On the right side, use the chart parameter to obtain a group value from the report's group field. Click the right side's down arrow and select Parameter. Then select the chart parameter from the context menu.
 
eurd-web-chart-for-groups-specify-parameter
 

Click OK in the Filter Editor and in the Chart Designer to apply changes.

 

Switch to Print Preview to see the result.

 

eurd-web-chart-in-group-footer