Last Modified Date: 16 May 2016
AnswerCreate a dual-axis map.
- Add one level of the hierarchy (for example, states) to the view by double-clicking the field in the Dimension pane. This will add the generated Latitude and Longitude fields onto the Column and Rows shelf.
- Add an additional instance of Latitude (generated) to the Rows shelf.
- Add the other desired level of the hierarchy (for example, city) to the Marks card for the second Latitude (generated) field.
- On the Rows shelf, right-click on the second Latitude (generated) field and select Dual Axis.
- Creating dual-axis maps can only be done with the generated Longitude and Latitude values.
- Custom Latitude and Longitude fields (typically existent in the underlying data) cannot be combined with the Tableau Desktop-generated Latitude (generated) and Longitude (generated) fields, but can be combined with existing geographic roles. For example: To map addresses on top of ZIP Code, add Latitude and Longitude (database fields, not Generated) to Column and Rows, then specify the level of detail by adding Address to the Detail shelf. Add a second iteration of Latitude to the Rows Shelf, then replace Address with ZIP Code on the second iteration of Latitude on the Marks card, then perform step 4 above.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials