I. Overview
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 paper will introduce the preparatory work of drilling map and its detailed attribute setting.
II. Examples
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 data set 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 attribute table > 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 gradient color for shape, and uncheck legend is visible
Select chart property sheet > style > series, select default for 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.
III. Completed template
Completed template, please refer to % fr_ HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Chart\Map\drill.cpt
Click to download the template: