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

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.

主站蜘蛛池模板: 潞城市| 磐石市| 绩溪县| 富源县| 兰坪| 和硕县| 平乡县| 娱乐| 八宿县| 苍梧县| 界首市| 广昌县| 乐清市| 高平市| 色达县| 东至县| 巩留县| 辰溪县| 花莲市| 白山市| 岱山县| 曲靖市| 吴旗县| 新民市| 郓城县| 望谟县| 堆龙德庆县| 蒲城县| 延长县| 神木县| 玉山县| 南平市| 桃园市| 神木县| 镇巴县| 陈巴尔虎旗| 石景山区| 双峰县| 桦南县| 通辽市| 镇康县|