KNOWLEDGE BASE

Combining Generated and Datasource-Based Latitude and Longitude on Dual-Axis Map


Published: 05 Aug 2014
Last Modified Date: 06 Sep 2017

Issue

How to combine data source-based latitude and longitude with generated latitude and longitude on a dual axis map.

Environment

Tableau Desktop

    Resolution

    1. Create a custom geocoding .CSV file that correlates all of the latitude/longitude coordinates with the required nomenclature. For more information, see Creating an Import File.
    2. Import the custom geocoding into Tableau Desktop. For more information, see Importing Custom Geocoding.
    3. Use the name-based recognition to set up a dual axis view exclusively based on generated latitude and longitude values. 

    Cause

    Tableau Desktop does not recognize that the latitude/longitude of one dimension are related to the lat/long of another dimension (such as the custom lat/long compared to generated lat/long). Therefore, when the second set of lat/long are placed on the row/column shelves, they restrict the potential points of the dual axis. In effect, any dual map information can only be plotted on the secondary map if the lat/long coordinates match the lat/long already on the view.
    Did this article resolve the issue?