Map Drilling User Defined Hierarchy

1. Expected effect

In the Map drilling, taking the area map as an example, this paper introduces the map drilling function.

The drill map can also use the form of user-defined combination to drill all the way from the point map to the final area map, as shown in the figure below:

2. Implementation ideas

This document will introduce the preparatory work of drilling map and its detailed attribute setting.

1. Map preparation

The map directory %FR_HOME%\webapps\webroot\WEB-INF\assets\map\geographic\world\China.

For the demo, we have China, provience and city. We need additional json pacakge if we want to drill down more from city to district. For this example, we could only drill from country to province.

2. Data preparation

Create a new workbook and add the database dataset ds1: select * from MapEN to record the sales of each province.

3. Insert chart

Combine a group of cells , click Insert > Cell Elements > Insert Chart, and select Drill Map >Custom Map, as shown in the figure below:

4. Map data setting

Select the chart and select Chart Attribute Table > Data > Drill Level in the chart attribute table on the right. The first level is Point Map and the rest is Area Map, as shown in the following figure

Note: only when you select a custom map can you set the display type corresponding to each level

Select Chart AttributeTable > Data > Data.Select each level to specify, as shown in the figure below:

Note: the data can be selected from the bottom layer data summary or each level specified separately. The former is selected by default, which means that the data only need to drill through the bottom layer of the map, and the upper layer data is summarized from the bottom layer. If each level is specified separately, each level can be configured with different series according to the chart type and interface of the level

5. Chart style setting

Select Chart Property Sheet > Style > Legend, select GradientColor for Shape, and uncheck Legend is Visible

Select Chart Property Sheet > Style > Series, select Defaultfor mark points of point map

You can further set the chart style in the chart property sheet as needed, such as setting the title, font size, color and label, which will not be introduced here.

6. Save and Preview

Save the template and click pagination preview. The effect is as expected in I.1.

Completed template, please refer to % fr_ HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Chart\Map\drill.cpt

Click to download the template:

drill.cpt