How to create routes with the MAKEPOINT and MAKELINE functions 

Ji Zhang they are a new feature in 2019.2

This data set doesn’t have passenger information.

Download the workbook.

As long as your data is structured the same way.

You're welcome!

Yes

That’s totally up to you.

You can’t do it with makeline. You would need each point in an individual row and then you should be able to put the field that orders the points along the route onto the path shelf. Or you might need to use the pages shelf

The data needs the be lat/lon but zip code

You would need to find the data. As for distance, there’s a DISTANCE function you can use.

Tableau considers the curvature of the earth when deciding whether to curve the line. If you are zoomed in quite far, like the London bus example, the curvature will have no impact. Tableau is still drawing a curve, but you can't see it.

acmerritt you can use these functions if you have lat/lon fields in the data set. You can’t use tableau’s automatically generated lat/lon.

@@vizwiz Thank you so much for answering Andy. (I live in a small beachside town in Australia, a long way from any capital city user groups that I could ask). The lat/lon fields are not in the dataset per se, but they are in a file (of my making) that sits in the folder for the custom geocoding. Would you suggest I bring that excel file into the relevant workbook, 'undefine' the airport fields from geographic role to just string and go from there? It feels like I'm going backwards to undo it but can do that if you think it the way to go. Or should I be asking this on a forum - I don't want to impose.

Because you’re telling tableau to draw between two points. Tableau won’t follow roads. The map in the background is merely for reference.

Find it on Google.

Does it work if you put that field on the tooltip shelf?

@@vizwiz Actually I found a way using a layer, and initially I wasn't pulling that info from the right source, but now it's working--thank you for a great tutorial!

Use the makepoint function if you already have the lat/lon.

Are you in a really old version of Tableau?

@@vizwiz no i have 2022 and 2021 in both it's not shwoing

The location information has to be in the data source. Tableau can't give you the lat lon from a list of airports.

You can download the workbook and unzip it to get the data. Otherwise, a simple google search will find it.

They are straight lines. For the airports, it will follow the curve of the earth since it’s zoomed out far enough.

@@vizwiz ok, so if you overlaid the street network it wouldn't coalesce, but rather go straight from one bus stop to the next?

Correct

@@vizwiz interesting. Aside from displaying the map in the background have you tried bringing in the vector file for street networks? Like from Tiger files?

Adam Kapuscinski no. That’s overkill for what I was doing.

Harikrishna Radadiya there is a link in the description.

@@vizwiz Thanks for getting back to me quickly. The link in description take me to the blog where I am able to download Tableau file but not the core data. I want data because I am highly interested in doing the analysis on my own. Thanks, H@ri

After you download the workbook, unzip it and you’ll see the twb and the data.

I don’t understand your question.

@@vizwiz Geometric Coordinates i mean

Isn’t it already in lat/lon?

@@vizwiz No ..

@@vizwiz No

hahaha!

That’s great to hear thank you. Spread the word. 😊