Show two sets of lat/long points on Tableau

2
votes

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?

1
tableau-api

1 Answers

3
votes

Sure, but 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

and 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

enter image description here

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

UPDATE: To get labels you can do a dual axis and overlay the labels: enter image description here