In my last blog posts, I explained how to create points, lines and calculate their distances using Alteryx.
In this one, I also want to show how to create points and lines using Tableau. As for calculating the distance, tableau does not have that feature yet, but it seems that it will appear in future versions.
For this example, we will be using flights data, more specifically, Flights routes from UK airports.
Our goal is to draw lines from our UK airports to all the destinations they offer.
We can see that our data has Origin airport and Destination Airport and their Latitudes and Longitudes.
Load the data into Tableau and let’s Start!
We are going to use the Latitudes and longitudes to create all the centroids (points) for both Origin airport and Destination Airport.
Let’s create two Calculating fields using the function “Makepoint”. The “Makepoint” function ask you for the Latitude and Longitude.
“Makepoint” uses latitude and longitude fields in a spatial join, creating a centroid.
After creating the centroid for each the Destination and Origin airports, we will connect both points with a line using the “Makeline” function, which creates a line between two points, an origin and an end.
Clean the view
Now we have too many lines, and we can’t see much with clarity. You can now clean the data your way.
In my case, I will reduce the opacity and add a filter so I can choose the airport I am interested in.
Hope this blog post helps you understand a bit more the two function “Makepoint” and “Makeline”, as well as which destination you can visit from each airport within the UK. 😊