官术网_书友最值得收藏!

Dual Axis mapping (2018.1)

Before Tableau 2018.1, you could already build a Dual Axis map. To do so, duplicate the longitude in columns, or latitude in rows, and select Dual Axis in the pill option. Thanks to the Dual Axis option, it is possible to have two different Mark types and a different level of detail in each Marks layer. In the following screenshot, you can see a Dual Axis map, with a filled map for the state with the Sales in color in the first layer, and circles for each city, colored in black, in the second Marks layer:

Unfortunately, in previous versions of Tableau, it was impossible to create a Dual Axis map by combining Tableau-generated coordinates and custom coordinates in your data. Since Tableau 2018.1, it's been possible. Let's look at how to do it.

To reproduce the example, download the  Orders without City file from my website,  book.ladataviz.com, or browse to  https://ladataviz.com/wp-content/uploads/2018/09/Orders-without-City.xlsx.

In the Orders without City file, the cities have been removed and replaced by their latitude and longitude, in two different columns: Latitude City and Longitude City. The goal is to rebuild the preceding example with this new file. Do as follows:

  1. Open Tableau and connect to the Orders without City file.
  2. Right-click on the Latitude City field and select Convert to Dimension. Repeat the same for Longitude City.
  3. Double-click on State to create a map, and put Sales in color.
  4. Add Latitude (generated) next to the existing Latitude (generated) pill.
  5. Right-click on the second Latitude (generated) pill and click on Dual Axis.
  6. On the second Marks layer, change the Type to Circle, add Latitude City and Longitude City in Detail, change the Quantity from Color to Size, and, finally, change the color of the Marks to black. The final result is as follows:

As you can see, since Tableau 2018.1, you can combine generated coordinates with custom ones.

The next enhancement was one of the longest-standing requests from the community: the nested sort.

主站蜘蛛池模板: 金溪县| 赣榆县| 江达县| 崇左市| 易门县| 彭水| 黄陵县| 庆阳市| 宣恩县| 洛川县| 揭东县| 乡宁县| 隆昌县| 寻甸| 东乡| 岗巴县| 贺兰县| 满城县| 昌都县| 闸北区| 绍兴市| 腾冲县| 乐山市| 磴口县| 渝北区| 沐川县| 永顺县| 黎平县| 固原市| 怀柔区| 绥棱县| 南通市| 长兴县| 体育| 民权县| 奇台县| 九龙县| 商河县| 黄浦区| 苗栗县| 芜湖市|