Mastering 4-Level Map Drill Downs in Tableau

Просмотров 12 тыс.

% 386

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/2022/08/two-level-drill-down.html
- www.vizwiz.com/2023/06/map-drill-down.html
3-Level Drill Down Tutorial
- www.vizwiz.com/2023/08/dzv-drilldown.html
Links & Resources:
Workbook - public.tableau.com/app/profile/andy.kriebel/viz/4-LevelMapDrilldown/MapDrilldown
Data - data.world/vizwiz/us-cities
Don't forget to hit that "Like" button and "Subscribe" for more exclusive Tableau tutorials!

Наука

Опубликовано:

19 сен 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 56

@bavisshyaraghuraman2888 8 часов назад

ultimate sir thank you so much

@muhamadsatriaputra5905 15 дней назад

thanks coach!

@charlesshepherd2717 10 месяцев назад

Great tutorial on this! Thanks!

@JP_-oq3xn 10 месяцев назад

What a great video!

@maxfrantzyemmanueljean-pie8098 Месяц назад

Great video!

@lilianacely3884 10 месяцев назад

Thanks Andy! Great video!

@vizwiz 10 месяцев назад

Glad you liked it!

@muhammadsajjad-pm2xv 10 месяцев назад

Thanks Andy for Another Amazing Video ❤❤

@vizwiz 10 месяцев назад

My pleasure!

@anju7619 8 месяцев назад

This was a brilliant tutorial Andy. Thank you so much, its much appreciated.

@vizwiz 8 месяцев назад

Glad it was helpful!

@ramkrishna133 10 месяцев назад

Thank you Andy for making the drill down and filtering logic so simple and easy to understand :)

@vizwiz 10 месяцев назад

You bet!

@ashishkulkarni7119 2 месяца назад

Thanks alot

@data_beta_ Месяц назад

Super easy to follow for such an amazing technique. Thanks!

@vizwiz Месяц назад

You are so welcome!

@jboyd3737 10 месяцев назад

Thanks! Truly adding to the body of knowledge for this profession and adding value to the world.

@vizwiz 10 месяцев назад

I appreciate that!

@vyacheslavs5642 5 месяцев назад

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.

@jagadishparasuraman5392 2 месяца назад

You're a Legend, sir

@Princivil Месяц назад

I was searching for this very comment because I had this issue!! Thank you ✨

@GE1R 9 месяцев назад

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. ♡

@vizwiz 8 месяцев назад

Great to hear!

@johnprimeaux5559 18 часов назад

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......

@Baqon42 15 дней назад

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?

@AndianerWhhat 9 месяцев назад

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?

@tradeshow547 3 месяца назад

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.

@AltafAlandwale 10 месяцев назад

My heart broke as I saw you as an Arsenal fan :D

@cecilia_mackie 9 месяцев назад

So cool! Shall we connect?

@sukritis 9 месяцев назад

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!

@imsajiv 10 месяцев назад

Didnt see the data set link in the description only the published workbook is present

@vizwiz 10 месяцев назад

Updated...also find it here data.world/vizwiz/us-cities

@yeeyazz 9 месяцев назад

Hi Andy! I am from Thailand that I use shapefile in city so that I see false only. Can you help me ? Thank you.

@drt102 10 месяцев назад

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?

@ajaypranav1390 Месяц назад

Use a Reset filter and always display the country when all are empty

@yankiokdemir 10 месяцев назад

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 :)

@vizwiz 10 месяцев назад

Dynamic zone visibility only works with parameters.

@PoojaPawar-gt9ee 10 месяцев назад

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.

@vizwiz 10 месяцев назад

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.

@gonzalooderda9394 10 месяцев назад

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.

@vizwiz 10 месяцев назад

Yes

@rabiamir8796 10 месяцев назад

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?

@vizwiz 10 месяцев назад

You sometimes have to manually type in the parameters to get the starting point correct. You’ll see me do that in the video.

@nolanstephenson2599 4 месяца назад

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!

@vizwiz 4 месяца назад

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.

@nolanstephenson2599 4 месяца назад

@@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

@MuhammadHamza-hg7em 3 месяца назад

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.

@vizwiz 2 месяца назад

Thank you!

@romanvasiura6705 10 месяцев назад

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... 😪

@vizwiz 10 месяцев назад

Unzip the workbook after you download it. All of the data is there.

@tink417 6 месяцев назад

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.

@vizwiz 5 месяцев назад

Agreed!

@Father_Prime 5 месяцев назад

Totally agree. IMO, implementing drill-down functionality like this should be a high priority given that their primary competitor (Power BI) already has it.

@cecilia_mackie 9 месяцев назад

Interesting! Let’s be friends?

@cecilia_mackie 9 месяцев назад

Hey! That’s awesome! Shall we be friends?

@cecilia_mackie 9 месяцев назад

Interesting! Let’s be friends?