Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to use DataGear to easily make national maps and provincial map data visualization Kanban to support chart linkage, which has a certain reference value, and interested friends can refer to it. I hope you can learn a lot after reading this article.

The chart linkage function of DataGear Kanban enables you to easily make national and provincial map data visualization Kanban that supports chart linkage.

First, create two new datasets.

The first is the provincial indicator dataset, which will be used to chart national indicators, and its SQL statement is as follows:

SELECT COL_NAME, COL_VALUEFROM T_ANALYSIS_PROVINCE

The second is the index data set of each city of the specified province, which will be used to draw the provincial index chart. It is a parameterized data set, where the parameterized SQL statement is:

SELECT'${province}'AS COL_MAP, COL_NAME, COL_VALUEFROM T_ANALYSIS_CITYWHERE COL_PROVINCE ='${province}'

The parameter is defined as:

Parameter name type required province string is

Then, use the above two data sets to establish the national index chart and the provincial index chart respectively.

Chart of national indicators:

Chart type: basic map data set: provincial indicator data set data set column mark: COL_NAME area name; COL_VALUE indicator value

Provincial indicator chart:

Chart type: basic map data set: city indicator data set data set column mark: COL_NAME area name; COL_VALUE index value; COL_MAP map name

Then, create a new visual Kanban and fill in the following Kanban template:

. dg-chart {display: inline-block;}

Click the [Save and Show] button to open the Kanban display page and finish!

The effect image is as follows:

Thank you for reading this article carefully. I hope the article "how to use DataGear to easily make national map and provincial map data visual Kanban supporting chart linkage" will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.