How to create routes with the MAKEPOINT and MAKELINE functions
Vložit
- čas přidán 4. 09. 2024
- In this week's tip, I show you how to use the makepoint and makeline functions that became available in Tableau 2019.2 to create routes. I show two examples: airline routes, and bus routes. The bus routes also shows you how to use a calculated join to bring one row up to the previous row.
Get a taste for vector maps as well. Download the workbook here - www.vizwiz.com...
thanks for sharing, Andy. I never knew there are the makepoint and makeline functions... until today
Ji Zhang they are a new feature in 2019.2
Hey Andy you are doing great job.Even i was searching for best use cases in tableau and you are doing same.Thanks for this and please keep uploading such videos.
You are a life saver! - Thank you!!!
Thanks Andy for this wonderful video !!
Thank you Andy .. I keep learning from your videos
Got to learn something new today... Thanks Andy
I keep learning from you .. Thanks Andy and team!
Thank you Andy!!!
super solid sir. thanks
Super duper!!! Thank you Andy!
Every single video about this uses the same kind of dataset. There is so much info in such a dataset. I may just have cities and nothing else.
Awesome Andy, great tutorial !!!
Thanks for this video. I have question, how to show top 10 busiest air routes from the dataset that you have.
This data set doesn’t have passenger information.
It was really helpful. Thanks
You're welcome!
Great resource! Thanks!
You are a saviour. Can i use same technique for shipping data.
As long as your data is structured the same way.
Andy, hello!
Could you give a link for the dataset(s)? I would like to repeat each step from your video... but without dataset I can't do it...
Download the workbook.
Amazing, just a quick question. The lat long details need to be at how much depth? Like zip code or we can dive more?
That’s totally up to you.
Hi Andy, great work and demonstration. Just a quick question, can you add all stops on a route (Bus routes in London) and somehow highlight them while selecting/filtering a route? like some dots/circles on a single route line with their names in tooltip while hovering over those dots/circles? thanks
Yes
Great Work!
I have one question. How can we get check-In & out of every station and can we find the distance between each station.
You would need to find the data. As for distance, there’s a DISTANCE function you can use.
How about for zip code that starts with zero, distance formula won't show the difference. Any thoughts??
The data needs the be lat/lon but zip code
Great Video.. I just have a small question.. in case of airport route, it is obvious that there is a curved straight line between origin and destination point, but how come, in case of London Bus Stop example, it is creating a proper route between two points ? which is zig-zag in certain cases.??
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.
Superb..
Great video ✈️, how to plot flight path connecting series of lat long on map.
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
I do a lot of work with airlines and so I appreciate the tip, as always. (one of my mantras, WWAD - What Would Andy Do?). Back in 2016, I worked out the custom geocoding sufficiently to create Airports as a Geographic Role and I use that to map various things but I've never been able to map the routes. Can I use MAKELINE to connect the Departure and Arrival airports when they are already defined by their geographic role (latitude / longitude)?
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.
HI Andy--I've used your airport example to create a map that shows facilities within a state as destination, and counties from where people are referred to those facilities as origin. I've used color for destination so all referrals to each destination from across the state are the same color--but I would really love to be able to select the facility and have the names of counties (origin of referral) show up at the end of each line. Is there a way to do that?
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!
Amazing :)
Hi Andy! Very helpful video. Do you know of an easy way to load longitude and latitude for multiple dimensions (e.g. Destination airport and Origin airport) within Tableau? Tableau auto generates longitude and latitude for just one dimension. For the life of me, I couldn't figure out a way to auto generate longitude and latitude for multiple dimensions.
Use the makepoint function if you already have the lat/lon.
Why do I get straight lines when showing the map of streets (in your case the bus-routes). I don't get the routes by roads. It's just straight lines. How can I change it?
Because you’re telling tableau to draw between two points. Tableau won’t follow roads. The map in the background is merely for reference.
Hi Andy, thanks for this tutorial. I have Origin Zip and Dest Zip however don't have origin lan/lat and dest lan/late like you. How do I get that?
Find it on Google.
Nice Video.
I have another dataset which consists of List of Airports. So, can you tell us how to extract latitude and longitude as another column, from List of Airports.
The location information has to be in the data source. Tableau can't give you the lat lon from a list of airports.
Why I m not able to create makepoint functions? Any idea.. i have origin and destination lat longs
Are you in a really old version of Tableau?
@@vizwiz no i have 2022 and 2021 in both it's not shwoing
I am probably overlooking something, but why does the makeline function follow the streets when you specified start and end points? Wouldn't it just draw a straight line?
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.
Amazing
Can u please provide me the link to download the Airline Routes dataset.
You can download the workbook and unzip it to get the data. Otherwise, a simple google search will find it.
Awesome explanation, but I can not find the work book. can you please guide me in downloading the data.
Thanks,
H@ri
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.
how to convert coordinates to latitude and longitudes..
I don’t understand your question.
@@vizwiz Geometric Coordinates i mean
Isn’t it already in lat/lon?
@@vizwiz No ..
@@vizwiz No
You do in 13mn what takes me 2h! So fast and my English is pretty ordinary so I have to watch this video in 0.5 playback - but then it sounds like drunken slur!
hahaha!
Wow this is wonderful there more I dig your videos @andykriebel I always learn amazing stuff.🤝🏽
That’s great to hear thank you. Spread the word. 😊