KNOWLEDGE BASE

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


Published: 05 Aug 2014
Last Modified Date: 22 Jun 2018

Issue

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

Environment

Tableau Desktop

    Resolution

    Option 1: Upgrade to Tableau Desktop 2018.1 or later

    Starting in Tableau Desktop 2018.1 it is possible to create a dual axis map with custom and generated Latitude and Longitude values. For full directions, see Create a dual-axis map from a combination of generated and custom latitude and longitude fields


    Option 2: Use Custom Geocoding

    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. 


    Option 3: Replace one axis of the map with a background image

    Background images will not have the same functionality as a map axis. For example, it is not possible to select marks on a background image or see tooltips. For full directions, see Use Background Images in Your Views

    Cause

    Tableau Desktop 10.5 and earlier 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?