TABLEAU DESTINATION MAPS
Vložit
- čas přidán 8. 09. 2024
- Get Tableau Certified, guaranteed - www.artofvisua...
Destination Maps geographically show the movement of information or objects from one location to another and their amount. Typically Destination Maps are used to show the migration data of people, animals, and products. Its thickness represents the magnitude or amount of movement in a single flow line. This helps to show how migration is distributed geographically.
Destination Maps are drawn from the point of origin and branch out their "flow lines." Arrows can be used to show direction, or if the movement is incoming or outgoing. Without arrows can be used to represent trade going back-and-forth. Merging/bundling flow lines together and avoiding crossovers can help to reduce visual clutter on the map.
To stay up to date with our latest videos make sure to subscribe to this CZcams channel!
Great video. You helped me a lot! I needed to visualize a connection between libraries and number of books being transfered. This method is better than using makeline because i can visualize the value for each connection. I am definitely subscribing to your channel. Thanks.
one of the best videos I have seen . Very Informative. Thank you !
You are most welcome Ritu!
Thank you so much this was very helpful !!!
Fantastic video , easy to follow along , precise . looking forward to more from super datascience !!
There will be more Rajshree!
Stay tuned!
Thank you ! This is all I was looking for today. Really helpful.Thumbs up!
Hi Kai,
So glad that you joined us!
Thanks for a comment
Thank you for your reply.Also, I have question about the data, since we duplicated the records by union the same dataset, I have question that if I perform the calculation(such as about record,sum...),will I also get duplicated in my calculation?If so,How can I avoid this?Thanks for your time..
I think I just need to drag [route order] to selector(filter) and select [route order = 1]
Okay, I created this chart, but with data I created myself. That honestly would make for a much better guide for beginners. Also, I added distances to it too which is cool.
Much appreciated! Great tutorial!
Great Tutorial! This helped me a lot!
Terrific video on Creating route maps!
Great video..Really helpful to understand many new concepts in Tableau ..
Keep tuning in Rajesh - Heatmap Calendar and Unit Charts on the way for this series
One of the best videos on this topic. Kudos. Can we also add vehicle/flight live movement on the path.I have separate LAT and LONG for vehicle location which gets updated every hour. Please guide.
Flight paths should be represented as great circle tracks, not as rhumb lines.
i love it, thank you so much and it is very helpful.
Hey, great video and kudos on going the extra mile to make it look nicer! One question is, if I'd like to see labels of the cities/airports. I thought dragging a city(the name of the dimension in my workbook) onto the label field would do it. But it makes the lines disappear. And I tried a few other workarounds but in vain. One other work around made all the end points have the label of the origin city for eg all the lines ended with jfk. This probably was because of the city join! Could you please post a solution to add labels? Thanks in Advance!!!
Superb Video, Thanks a lot
Beautiful work but hard to recreate because the Kaggle Dataset (2022 Download)on the video does NOT match the one in the video and the Table Calc and Joins do not work. An update would be wonderful or a copy of the dataset file used in the video. Thanks
I totally lost from 5:38... I think that you use the same table name, which is 'US delayed...', am I right? Since it's the same file name, would you please let me know why does Route Order can be separated into '1' and '2'? thanks... However, follow your steps, I did draw the destination map, after all, thank you for your great video.
Great tutorial, so useful for me, anyway, the step to union the file to makes duplicates value, can we make automation on that? so whenever I refresh file with updated one, it will do union automatically...?
This is great. is there a way to add arrow in destination field or change color of origin/destination nodes?
Thanks for the tutorial! my route identifier ("origin country name _ destination country name" cannot be recognized by the map..... I wonder if you know what caused it?
Great video, Thanks. It would be great if you can help with the following;
1-Adding labels (Already requested but not answered below).
2-I am trying to apply the same on a different large dataset, and the number of rows is not expanding to show the whole dataset. Creating the joint is also not executing fully because of the same issue. Is there a way to sen you the working file to examine what might be the case?
do you know how to make each airlines have animation ? The line from departure to destination with animation ?
Great informative video. Can you please share the dataset for this video. I tried to download from the above link as well as kaggle, I dont think I have the right one.
Hi when i tried the union, my number of lines did not increase?
You know tableau has the airport codes coordinates built in? Just select geoprahic type as airport.
Other than that great video, as always.
thank you for the heads-up!
@@ArtofVisualization I am really curious if the buit in coordinates causes a different approach for the issue. I try the same but with 'countries' and then I get stuck. Explanation is great btw!
Beautiful demo... It looked so complicated before creating the view... Skill! #Tableau
Would like to try it myself. Can you please share the dataset/ excel access?
Why we do union to the same table 🤔
this was fantastic
Thanks, great to know that you enjoyed!
why do we need to create two separate records for origin and destination?
Hi, Is there a way to do this but make the dots stay and the lines disappear?
Hey, Thanks for this tutorial and I'm interested in Time series and k-means clustering. I like to build strategic dashboards, if you can help me with one would be best for me and there is no data set neither I found in Kaggle nor in your web. Would you please help me with the data set? I'm very much curious to work on it.
Great tutorial! Since I subscribe this channel I have learned many skills! Thank you!
But another thing I wanna make a chord diagram lately, could you please update a video about it? Appreciate that!:)
How do you add the distance actually? I am a newbie at this...
Hi Lucie,
Thanks for adding to this thread.
This will be quite complicated to complete.
You will need to look at creating the below distance calculation for the start locations - end locations.
Distance in KM:
ACOS(COS(RADIANS(90-[Focal Lat])) *COS(RADIANS(90-[Latitude])) +SIN(RADIANS(90-[Focal Lat])) *SIN(RADIANS(90-[Latitude])) *COS(RADIANS([Focal Long]-[Longitude]))) *6371
Please see the below link for reference:
community.tableau.com/thread/216882
Hope this helps.
you have a distance column with all distance from each flight. You can drag it and it will show you the distance of each flight
The dataset in the link is diffarent from this video, Can you upload the correct one.
The files can still be found on Kaggle, here is the link to the page. www.kaggle.com/usdot/flight-delays#flights.csv
@@kevincarullo5436 the US delayed commercial flights(jan 2015) file is not available in the link
Hi, data link you shared in this video is not of destination map. Could you please share the correct data set
Great video. But another thing I've looked for lately is a way to create a network diagram, and when you click on an icon it will select all lines that originate from that point. Have played around with different 'Actions' without finding a solution. Any ideas are greatly appreciated! :)
There are some ways to create network charts in Tableau. We are thinking about a tutorial on it.
where can I find the dataset?
Seems unfair that a video like this has so few likes....
Indeed, JPGKIll3!
Let's try to fix it :)
I still don't get it. I have read so many guides and seen so many videos. The problem is that they all use the same huge database. I need to create my own database. Not a single video shows any of that for some weird reason, not even the official guide. So if you are starting out there is basically no guides for you at all and this is the case with some many programs. They just assume you are a power user already who have made similar, but not exactly the same paths.
From where to get Us commercial delayed flights Jan 2015 csv file?
K, the data shown on the video is different form the one I downloaded from Kaggle, It looks like you have already cleaned it and manipulated it already such as the date, could you shown more videos on that ?
Yes the data is different because he tweaked it to make it look simpler. You can try it too
Hello, Great tutorial video. However, I can not find the same file, which you demo here, from super-data-science... Would you please let me know where can I download this file. thank you.
Great video! But i do all the steps but when i open the new sheet the map is empty!!! Help me!!
And Longitude and latitude apear as string, and when i want to change to decimal apear "null" please help me. Thanks a lot!
Hi Martin,
Thanks for adding to this thread.
You will need to change Long and Lat to the “Geographical Role” data type.
Can you please submit a screenshot of your map?
Regards
thank you, saved me from getting fired
Songyu, if you ever see this, let me know. Hi Daryl.
Could not find the data file either in your link or in Kaggle website. The data set in your link under destination map is different from it.
Hi. please share the dataset if you have found it
Hi, I'm trying to show flight paths that go from point A to point B to point C - any suggestion on how to do this? I tweaked the calculated fields to include all the points but when I load the route identifier into the map nothing happens sadly!
Hi Craig,
Thanks for your inquiry.
When looking at flights going through 3 locations, do you have an unique id for your flight as well as a route order for each flight e.g. 1,2,3?
Tableau created a similar visual for a tube map, you can see how they linked multiples destinations to each line:
onlinehelp.tableau.com/current/pro/desktop/en-us/maps_howto_origin_destination.html
@@ArtofVisualization if you knew the MAX, let's say 3 stops. Would it be possible to just do two unions and in your IF, THEN statement just say IF in Table 'One' THEN '1' ELSEIF Table 'Two' THEN 'Two' etc... would that work?
Can you share dataset please
Any way to prevent lines going off far left / far right of the map? Or curve the lines?
Hi Daniel, could you please explain more on this?
Sure, so i have a similar data (albeit migration data) but some paths, e.g. Australia to USA go off the right edge of the map and re-appear on the left edge. This looks messy and I would prefer that the path crosses the map rather than going off the edge.
Hello Daniel, If you find out how to do it, please let me know. Thank you
In my case, when I drag the route field onto details, the swarm of dots I expect to show up on the map don't, just a few thousand nulls. no clue what's going on :-\. Help?
Make sure you finish the query with END
Hello, did you solve this problem?
Hi, great video. In the first step when i drag the dataset to make a union, it remains as 'csv' , the appended data does not become 'csv1' can you please help me with that?
using version 2019.1
@@makdada1 I have the same issue and same version. Have you figured out the solution? @ SuperDataScience any advise?
Can you please share the dataset link from where you have downloaded
Hi, for some reason when i take the step to add "Route order" i lose the lines, and it just shows circles
me too
@@jinyanchen2237 me too
@@jinyanchen2237 done! you must change route order from dimension to attribute
The data set on the Site is not correct
It isnt. He just edited a few here and there to make it look neat.
Where is the correct file???
Please share if you have found it
Sir can you please send the file in .twb format
some directly some not