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

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.

主站蜘蛛池模板: 华容县| 沂水县| 高清| 商城县| 绥芬河市| 华容县| 安陆市| 四平市| 阆中市| 天津市| 荥经县| 清水河县| 太仆寺旗| 田阳县| 盘山县| 乐昌市| 合江县| 鄂尔多斯市| 张家界市| 榆社县| 岐山县| 英山县| 中山市| 岑巩县| 如皋市| 锦州市| 霍城县| 澜沧| 成武县| 龙门县| 昆山市| 红安县| 太和县| 团风县| 陇南市| 陆河县| 肃北| 哈密市| 石泉县| 嵩明县| 望江县|