Show two sets of lat/long points on Tableau

Question

I have two sets of lat/long coordinates on a data source:

lat_orig    long_orig    lat_dest   long_dest    value

-12,2354    -55,2342     -5,3425    -32,3245      2

-11,2342    -44,9878     -14,3459   -54,2342      4

 and would like to show both points on the same map on Tableau, is it possible?

Answer 1

• You need to pivot your data a bit:

LAT  LON TYPE   VALUE

-12  -55 ORIGIN 2

-112 -45 ORIGIN 4

-5   -32 DEST   2

-14  -54 DEST   4

• Then if you want to draw lines between your places you need to add a path ID:

LAT      LON   TYPE VALUE   PATH

-12.2354 -55.2342   ORIGIN 2 2-2

-5.3425  -32.3245   DEST 2     2-2

-112.342 -44.9878   ORIGIN 4 4-4

-14.3459 -54.2342   DEST 4 4-4

• Here is a great tutorial: http://kb.tableau.com/articles/knowledgebase/using-path-shelf-pattern-analysis

• To get labels you can do a dual-axis and overlay the labels: