KNOWLEDGE BASE

How To Make A Line Between Source And Destination With Circle And Arrow Respectively


Published: 13 May 2020
Last Modified Date: 14 May 2020

Question

How to make a line between source and destination with circle and arrow respectively

Environment

  • Tableau Desktop

Answer

1) Create a Calculated field using MAKELINE function like below:

MAKELINE(MAKEPOINT([From Y],[From X]),MAKEPOINT([To Y],[To X]))

2) Create a Calculated field using function like below:

MAKEPOINT([From Y],[From X])

3) Create another calculated field called first and last like below:

if last()=0 then    "arrow" ELSEIF   FIRST()==0 then "circle" end

3) Create a view like below with longitude on Columns and two copies of latitude with dual axis :
User-added image

User-added image

4) On the second instance of latitude measure, drag first and last calculated field on shapes and select Circle and arrow respectively

User-added image  
Did this article resolve the issue?