This article will show some basic spatial calculations of creating a flight route map in tableau. The dataset used as demonstration contains the following fields.

This map is basically to show all the routes from the same original airports.

Before creating the map, there are a few calculations that need to be done.

Step 1: Create two points calculation based on latitude and longitude fields of the original airport and the destination airport.

Step 2: Create line calculation based on two points we just created.

Step3: Create distance calculation to add more details to the route.

 

Step4: Double click the Geo point of the original airport to create the basic map layer.

Step5: Drag the Route line calculation to the canvas to create another map layer. Also, drag the original airport name to the filter and show filter to enable user to select one airport, which serves our target of the dashboard (Choose one airport in the filter to make the map clear).

Step6: Because the route is shown as a whole part now, we need to drag the destination airport field to the detail to tear them apart.

Step7: To show make the destination airport shown in a different shape of the original airport, you need to drag the destination airport point to the canvas to create another map layer and change the mark type to shape. Also, drag the destination airport name to the detail to show the point individually.

At last, change the map background and the colour of the line based on your preference!

In the next blog, we will see how we can add a buffer to the map based on the original airport, so that we can highlight the flight route within the buffer.

Hope you find this article useful. Feel free to reach out to me on LinkedIn, if you have any questions😊😊.

Tony Tan
Author: Tony Tan