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

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.

主站蜘蛛池模板: 通城县| 开阳县| 三亚市| 汤阴县| 五河县| 碌曲县| 台安县| 绥德县| 睢宁县| 博罗县| 封开县| 南郑县| 桐庐县| 鲜城| 周宁县| 怀远县| 宣武区| 敦煌市| 通城县| 龙江县| 女性| 齐河县| 民勤县| 融水| 富顺县| 榆社县| 浦北县| 牡丹江市| 含山县| 江北区| 孝义市| 林西县| 清水县| 盐边县| 滁州市| 青田县| 兴化市| 图片| 洛隆县| 渭南市| 长治市|