Multilayer Pie Chart Linkage

Application Scenario

When you click a level of a multilayer pie chart, you can link to other chart data corresponding to the selected level, as shown in the following figure.

Implementation Method

Set the multilayer pie chart as the main chart, and put all the other charts corresponding to each level in the same sub chart. 

Set the condition attribute of Row Height for the sub chart, so that the level parameter of the main chart corresponds to the row height parameter of the sub chart. You can control the row height by setting the parameter to display charts of the specified level only when linkage is performed.

Data Preparation

Create a database query named ds1, and enter the SQL statement SELECT * FROM Orders WHERE "Shipper's country" = 'Thailand' limit 50.

Chart Insertion

1. Create a general chart named Main Chart for Multilayer Pie Chart Linkage. Merge required cells, right-click the merged cell, and choose Cell Element > Insert Chart > Multilayer Pie Chart, as shown in the following figure.

2. Create a general chart named Sub Chart for Multilayer Pie Chart Linkage. Merge required cells, right-click the merged cell, and choose Cell Element > Insert Chart > Column Chart, as shown in the following figure.

Data Binding

1. Bind the data to the main chart for multilayer pie chart linkage, as shown in the following figure.

2. Bind the data to the three column charts of the sub chart for multilayer pie chart linkage, as shown in the following figure.

Style Setting of the Main Chart for Multilayer Pie Chart Linkage

1. Choose Style > Label, and select Traction Line to make the series clearer, as shown in the following figure.

Note: 

 If you set Position to Outside Pie, the setting of Traction Line/Label will take effect for the outermost level of the chart. If you set Position to Inside Pie, the setting of Label will take effect for the innermost level of the chart.

2. Choose Style > Series, set Drill to On, and set Core to 0% by default, as shown in the following figure.

Note :

1. All levels evenly occupy the overall radius minus radius of the core.

2. After data drilling, the radius of the middle pie chart accounts for 50% of the overall radius, and the left levels evenly occupy the remaining radius, regardless of whether you set Core or not.

3. Click the white circle in the center to return to the previous level. 

Condition Attribute Setting of the Sub Chart for Multilayer Pie Chart Linkage

1. Select the column chart Average Shipping Fee Per Area, add Condition Attribute 1, set Row Height to 0, and add the condition a = 2 or a = 3, as shown in the following figure.

Note: 

Setting Row Height to 0 means hiding the chart. The value of parameter a corresponds to the level of the multilayer pie chart. When the level is 1, the chart is shown, and when the level is 2 or 3, the chart is hidden. Similarly, set the following settings.

2. Select the column chart Average Shipping Fee Per Province, add Condition Attribute 1, set Row Height to 0, and add the condition a = 1 or a = 3, as shown in the following figure.

3. Select the column chart Average Shipping Fee Per City, add Condition Attribute 1, set Row Height to 0, and add the condition a=1 or a=2, as shown in the following figure.

Hyperlink Setting of the Main Chart for Multilayer Pie Chart Linkage

Select the main chart, choose Special Effect > Interaction, click the xxx icon to add a hyperlink, select Web Report 1, and select Sub Chart for Multilayer Pie Chart Linkage. Set Parameter to a (which corresponds to the row height parameter of the sub chart condition attribute), and set Value to =Level, as shown in the following figure.

Effect Display

PC

Save the report and click Pagination Preview. Click a level, and the chart displays the column chart of the average shipping fee corresponding to the selected level, as shown in the following figure.

Mobile Terminal

For details, you can download the templates

Main Chart for Multilayer Pie Chart Linkage.cpt

Sub Chart for Multilayer Pie Chart Linkage.cpt