2 Replies Latest reply on Feb 22, 2016 7:14 AM by Nate Worrell

    Dual axis map with two custom longitude and latitude measures

    Nate Worrell

      Hello. I am trying to create a dual axis map with two different custom longitude and latitude measures. One measure is customer longitude/latitude and the other is vendor longitude/latitude. I would like to have all these points on one map. I was wondering if this is possible without having to combine the data fields using SQL. Thanks.

        • 1. Re: Dual axis map with two custom longitude and latitude measures
          Yuriy Fal

          Hi Nate,

           

          With a Map view Tableau has a restriction

          of only one pair of Lat/Long fields per view --

          whether it's a simple map or a dual-axis one.

           

          So even if there are several Lat/Long pairs per datasource,

          one could not use more than one pair per view, period.

           

          To use values from a two (or more) Lat/Lon pairs,

          one should combine them into a single Lat/Lon pair anyway.

           

          It could be per datasource -- by UNIONing tables

          on a common fields (including Lat/Long ones) --

          typically via SQL.

           

          Or it could be per view -- and an approach is to choose

          from the proper Lat/Lon pair depending on a view granularity.

          For example, if there is a Mark per distinct City, then Lat/Lon pair

          corresponded to a City should be taken into a calculated Lat/Lon for a view.

           

          Please find the attached wb with examples

          of the original view -- with Lat/Lon (generated) --

          and a couple of seemingly "identical" views made with

          Lat/Lon pairs calculated from several others available in the DS.

           

          Please find also an excel file used as Primary datasource(s)

          for both views (Sheet 7a -- "straight" DS, Sheet 7b -- using Pivot).

           

          For simplicity let's States to be your Vendors

          and Cities to be your Customers.

           

          Hope this could help.

           

          Yours,

          Yuri

          3 of 3 people found this helpful
          • 2. Re: Dual axis map with two custom longitude and latitude measures
            Nate Worrell

            Thanks for clearing that up! I ended up combining columns outside of Tableau.