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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.227.183.153