Drilling Point Map

This document only explains the creation and effects of the drilling point 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 point map is a kind of drill map, each level of which is the point map. Click the geographical location points to drill down into data at the city level from the provincial data and then to drill down into the data at the district level. You can also click the drilling directory to return to the data at the city or province level.

The following figure shows the effect.

Data Preparation

The Excel data provided in this example records the locations (including the province, the city, the district, and the latitude/longitude of the district) and the operating revenues of 27 branch offices. The data is only used as sample data without real significance.

1. Click to download the data 2019 Operating Revenue by Region (Drilling Point 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.

The following figure shows the dataset data.

Chart Insertion

Merge required cells, click the Insert Chart icon on the upper toolbar, choose Drill Map > Point Map, and click OK, as shown in the following figure.

Map Design

1. Map Setting

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

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 a specific level to drill down into data. As this is a drilling point map, you can only select Point Map as Display Type.

2. Data

Select Separate Designation Per Level in Data. There are three levels in this example, and you need to bind the data to each level separately, as shown in the following table.

Note:

1: 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 matching relationship in the pop-up dialog box of Area Name.

2: If you select Lat/Long as Geographic Info, you need to match the correct information to Area Name to realize the correct drilling. For more details, see the section "Unable to drill down into some areas under Lat/Long."

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.

Note: 

For details about the point map (for example, Point Style), see Point Map.

Effect Display

PC

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

Mobile Terminal

The template can be previewed on both the DataAnalyst app and the HTML5 terminal. Click the area you want to drill down into, the pop-up box of drilling will appear, and then click Drill to drill down into the data of the next level, as shown in the following figure.

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

Unable to drill down into some areas under Lat/Long

The drilling hierarchy is built according to the hierarchical directory of the map configuration in the server. Therefore, you need to select Lat/Long when binding the data to the point map. Besides, Area Name should be matched to correct information to achieve the correct drilling. 

For example, Geographic Info of No.3Level is set to Lat/Long in this example, and Area Name is set to District. Set Area Name as Geographic Info to view the fuzzy matching relationship, as shown in the following figure.

You can see that 1 region matching errors occur.

In Lat/Long setting, the area with matching errors cannot display locations correctly. For example, Xihu District cannot be displayed, as shown in the following figure.

Note: 

An incorrect match in the parent hierarchy will result in drilling failure, or drilling down into another area.

In such scenario, you are advised to select Area Name to customize the matching relationship. You can also modify both the geographic JSON file and the area name in dataset in the map configuration to make the matching relationship unique.