Give a chestnut! Tableau Tips (9): Lisa teaches you how to make hybrid maps ingeniously

published: 2021-05-19

"Will you be the next Lisa?

”We hope so!

Lisa has been using Tableau for some time, and she said she likes the "Cite a Chestnut" series, each of which has been collected. When they or their colleagues and friends need them, they can get help immediately.So, Lisa made a chestnut herself, hoping to share with more Tableau users through Ada. 

Tableau not only helps users to see and understand the data, but the most important thing is to allow users to find problems and solve them. The following is an excerpt from the original Lisa:

"I think I'm already very skilled in using Tableau, and I will use Tableau to create symbol maps and also create filled maps.

But one day when doing the work report, the leader's brows frowned. He asked: "Can this map show both the area and the sales and profit amount?" I was at a loss. Yes, according to what he said, it is indeed more intuitive.

Although I didn't expect this, I didn't know how to do it? But I think, you can try it! Areas can be represented by filled maps, and sales and profits can be represented by symbol maps. It is not intuitive to put two maps. Can the symbol map and the filled map be superimposed to form a new map form as shown below?

截屏2021-05-17 下午2.55.00.png      

As you can see, the regions are displayed in different colors in the form of a filled map, and the profit and sales are displayed in the size of a circle and in red and green. In this way, we can not only see the size of the sales and profits of each province, but also clearly see which region this province belongs to. "

In this issue of "Cite a Chestnut", the Tableau technique that Ada wants to share with you is: Lisa teaches you how to make a hybrid map ingeniously.

Step 1:Create a filled map

First create a filled map, "region" fills the map in provinces and cities by color as follows: After setting the geographic role, double-click the country to drill down to the province, drag the area to the color, and modify the graphics type in the marker card to "fill map "

栗子9动图1.gif

In order to make an extra dimension in the worksheet, she dragged and dropped the "Latitude (Generation)" in the "Measure Window" into the row ribbon, and at the same time, two maps were displayed.

栗子9动图2.gif 

Step 2:Form two maps and merge

In order to make the worksheet one more dimension, she dragged and dropped the "Latitude (Generation)" in the "Measure Window" into the row ribbon, and at the same time two maps were displayed. Select dual axis, the two maps overlap into one.

栗子9动图3.gif

Step 3:Change one of the maps to a symbol map

It can be seen that two switching bars are generated in the "marker" card. For "dimension (generation)" and "dimension (generation) (2)", two layers of the map are represented. So she selects "Dimension (Generate) (2)", changes the graphic type to circle, and drags and drops "Profit" to the "Color" in the mark card, "Sales" to "Size", and gets the following Figure.

栗子9动图3.gif

Then make some small settings, such as adding borders, adjusting the size, etc., and the mixed map is complete.

栗子9动图4.gif

A simple operation can realize the tips for displaying the three-dimensional information of the map. Have you got it?