Mastering 4-Level Map Drill Downs in Tableau
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- If you've enjoyed my previous tutorials on 2-level and 3-level drill downs in Tableau, prepare to take your skills to the next level.
I've got something unique for you: a step-by-step guide on creating a 4-Level Map Drill Down in Tableau!
What You'll Learn:
- How to drill down from a region to a state
- How to further drill down from a state to a county
- Finally, how to drill down from a county to a city
Prerequisites:
This is an advanced tutorial. Make sure you're comfortable with Tableau basics and have seen my 2-level and 3-level drill down videos.
Previous Videos:
2-Level Drill Down Tutorial
- www.vizwiz.com...
- www.vizwiz.com...
3-Level Drill Down Tutorial
- www.vizwiz.com...
Links & Resources:
Workbook - public.tableau...
Data - data.world/viz...
Don't forget to hit that "Like" button and "Subscribe" for more exclusive Tableau tutorials!
ultimate sir thank you so much
Super easy to follow for such an amazing technique. Thanks!
You are so welcome!
You will be the reason people ask me how I've gotten so good with Tableau. Much appreciated kind Sir, thank you for your videos. ♡
Great to hear!
Great video!
To avoid specifying initial parameters for displaying the dashboard, you can simply remove the third condition: [Postal Code Parameter] != ' ' from "DVZ Region" variable. Then even if all parameters are empty, you can still see the Regions Map and can drill down from there as usual.
You're a Legend, sir
I was searching for this very comment because I had this issue!! Thank you ✨
thanks coach!
Thank you Andy for making the drill down and filtering logic so simple and easy to understand :)
You bet!
Thanks! Truly adding to the body of knowledge for this profession and adding value to the world.
I appreciate that!
This was a brilliant tutorial Andy. Thank you so much, its much appreciated.
Glad it was helpful!
Thanks alot
Thanks Andy for Another Amazing Video ❤❤
My pleasure!
Thanks Andy! Great video!
Glad you liked it!
Great tutorial on this! Thanks!
What a great video!
Great video! I do have a question, though. Is there a way to set it so that clicking on selects the city instead of going back to the Region view?
My heart broke as I saw you as an Arsenal fan :D
Didnt see the data set link in the description only the published workbook is present
Updated...also find it here data.world/vizwiz/us-cities
How do I make this feature function on a tablet or the Tableau Server? When I published the map was no longer drillable and would return nothing when selected. Is there a special publish setting that needs to be selected? Thank you though for posting this walk through as it was extremely helpful.
at 11:56 duration of the video, there is another way around the situation which is regarding the clearing out of the city parameter every single time in order to get back to the Region display.
This can be dealt by changing the code of DZV Region to the following:
([Region Parameter] = '' AND [State Parameter] = '' AND [City Parameter] = '')
OR
([Region Parameter] = '' AND [State Parameter] = '' AND [City Parameter] != '')
the "OR" statement in the code will deal with both the cases, of all parameters being empty or only the City Parameter being populated.
And this way there will be no need of manually clearing out the value inside city parameter.
Thank you!
So cool! Shall we connect?
Hi Andy! I am from Thailand that I use shapefile in city so that I see false only. Can you help me ? Thank you.
Thanks @Andy Kriebel. Is there a way to disable multi selection in maps? Because this kind of killed it. I tested it in tableau public and it showed the same result. If it would work with multiple selections it would be also nice. Are there ways to achieve this?
Hi Andy,
I am trying to make a dashboard for work where i need the drill downs to go like State, County, State Senate district, House district, Municipality, Zip Code and Census Tracts. The first issue I'm facing is that a lot of it is not recognized by Tableau. For example, I am using the ACS 2020 census tracts however Tableau does not recognize census tracts. Any advice on how to go about this? If I use Shapefiles, it works well for 1 geography but messes up the other ones.
Thanks!
For some reason, I have no county data in the superstore dataset. Any suggestions? I tried using the zip code information from USPS, but it only provides matches that have sales? I think......
I don’t have County data either.
Hi Andy, I wanted to achieve a multi-select drill down with DZV by using sets but unfortunately set booleans (true or false) are not captured as a Boolean which you can set from Control Visibility. My idea was to create an empty set and when one or more values were selected from the first sheet, the set would become true, and 1st level would be hidden because I was going to set "SET=FALSE" for its visibility. There is an old method still to achieve that by using 2 axis for Latitude but I still want to build something with DZV. That could be a nice video topic :)
Dynamic zone visibility only works with parameters.
Do you have a special setting that let's your map automatically zoom in and out? I seem to have everything working properly but when I click on a state for instance it doesn't zoom onto that state and same for county. Thanks!
You have probably zoomed in or out manually which fixed the map in place. Click the pin on the toolbar. Then it’ll zoom in and out based on the data in the view.
@@vizwiz ahh yes this was the problem! Using a mac I needed to press the "home" button and now it dynamically adjusts! Thanks for your help on this
I have a world map that I grouped some regions (NA, EMEA, LATAM, APJ). When I filter a region I would like to all the countries in that region to be selected (this is happening) and zoomed in (This is not happening). Anything I need to do the automatic zoom?
Is your map pinned?
@@vizwiz double checked. Not pinned. I allow pan and zoom. I followed the tutorial addapting it to my needs (3-level drilldown).
Hello Andy, I am facing the issue in Map drill functionality. I have built it for 2 levels - State and City. The very first time, my map sometimes gets washes out and then I need to put a City in City parameter.
Then if I am selecting the state, the state completely washes out and the City map appears after removing the City from City parameter.
Please help me how to resolve this.
I don’t clearly understand your question.
You sometimes have to manually type in the parameters to get the starting point correct. You’ll see me do that in the video.
Is possible to make with shapes, because in other parts of the world, the maps of tableau doesn´t recognize more than two levels. for example state and county.
Yes
Hi, i am getting stuck at 7.07. After i click on dzv it works for region, and county, but then the top map goes blank when i click dgv state, so it's not changing to vols by county, can you help?
You sometimes have to manually type in the parameters to get the starting point correct. You’ll see me do that in the video.
Hi Andy. Just wondering how you would deal with everything going blank if the user drills down to the Sales by City viz and then clicks twice on something that isn't a city? Even the undo function doesn't seem to revert things?
Use a Reset filter and always display the country when all are empty
Hello. Can you give me additional advice?
I downloaded a Tableau Workbook, but after opened it in Tableau Desktop I have a message (aspecially if I go to the Data Source tab):
Unable to complete action
There was a problem connecting to the data source "US Cities".
I don't have a database US Cities.. How can I download this file ("US Cities") from the Tableau Publick?
P.S. Maybe you record some video about how to download original file (database) from the tableau public...
P.P.S. Sorry for this type of question, but i struggle with it and can't repeat each step from your nice video lessons... (due to luck of knowladge how to get original file from Tableau... 😪
Unzip the workbook after you download it. All of the data is there.
This is great but there is no way tableau couldn’t make this easier with hierarchy level built in. The fact you need 20 Different formulas to do this is very hard to maintain and scale.
Agreed!
Totally agree. IMO, implementing drill-down functionality like this should be a high priority given that their primary competitor (Power BI) already has it.
Interesting! Let’s be friends?
Hey! That’s awesome! Shall we be friends?
Interesting! Let’s be friends?