Drilling Area Map

This document only explains the creation and effects of the drilling area map without a detailed introduction to some concepts of property settings. You are advised to read Drill Map first to understand the basic properties of the drill map.

Version

Application Scenario

The drilling area map is a kind of drill map. Each level of the drilling area map is an area map. Click the geographical location area to drill down into data of the next level. You can also click the drilling directory to return to the data of the previous level.

The following figure shows the effect.

Data Preparation

The provided Excel data records the locations and the operating revenue of 30 branches, which is only used as example data without real significance. 

1. Click to download the data 2019 Operating Revenue by Region (Drilling Area Map).xlsx and place the file to %FR_HOME%webapps/webroot/WEB-INF/reportlets.

2. Create a general report, create a file dataset 2019 Operating Revenue by Region, select Excel from the drop-down list of File Type, and select the downloaded file as Local File, as shown in the following figure.

Note: 

The example uses the built-in dataset for the convenience of your viewing.

The following figure shows the dataset data.

Chart Insertion

Merge required cells, select the merged cell, click the Insert Chart icon on the upper toolbar, select Area Map, and click OK, as shown in the following figure.

Select the map, select China as Map Point under Cell Element > Type, and select Blue as GIS Layer in Custom, as shown in the following figure.

Map Design

Data Binding

1. Drill Level 

Drill Hierarchy: As Map Point is set to China, Drill Hierarchy shows the data of provinces and cities in China by reading the geographical information corresponding to the server. 

Level Attribute: Zoom Level of No.1Level is set to Auto by default and cannot be modified. You can set Zoom Level of other levels. In this example, Zoom Level of each level is set to Auto, so you need to click to drill data. As this document explains the creation and effects of the drilling area map, you can only select Area Map as Display Type.

2. Data

Select Basic Data Summary in Data, select 2019 Operating Revenue by Region as Dataset, and select District the basic area field as Area Name, as shown in the following figure.

Note that if you select Area Name as Geographic Info, the data will be matched fuzzily, and the map will present incorrect results. Therefore, you need to check the matching relationship. 

Click the icon on the right of Area Name to view the errors of area matching in the pop-up dialog box of Area Name, as shown in the following figure.

Therefore, you need to customize the match relationship which will be displayed in Custom Match List, and click OK, as shown in the following figure.

Style Setting

1. Choose Style > Label, select Use Label, select Area Name as Text, and set Character to Custom, as shown in the following figure.

2. Choose Style > Series, select Value as Color Section, and Continuous Gradient as Color Type, set Section Range to 3, and retain the default settings of other items.

Null Color refers to the color of the area with no data. Opacity takes effect for all areas within the border. Border refers to the boundary line of each area.

Effect Display

PC

Save the template and click Pagination Preview. The section "Application Scenario" shows the effect. 

Mobile Terminal

The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the effect.

For details, you can download the template Drilling Area Map.cpt