I think this was a better tutorial using dynamic zone visibility than the map drilldown. I used this to make a 3 level map drilldown, was a bit complicated due to some factors in the data (there are a lot of Franklin Counties in the US haha), but I figured it out - main thing was using multiple filters on the zip code drilldown, and using FIP as my county data point rather than county name. I think the region/state/postal code levels were easier to understand. I did end up using a marks layer but only so I could put the name of the county on the title row, which I thought was a nice touch and good way to keep oriented. And I like the idea of numbering the calculated fields and parameters! This seems like a great one-stop shop for drilldowns in general. I appreciate the video.
Great video! I applied what I learned to a 4 level drill down and it wasn’t too much extra work after mastering 3 levels! I hope to reach your level of Tableau mastery, thank you!!
Hi @vizwiz, Thanks for the great video, I used your method for 3 level drill down, but I don't know how to add the possibility of multi-selection in each level, that is, I want to be able to select several items in each level at the same time instead of selecting one item.
@AndyKriebel, thanks for explaining drill down and zone visibility but I tried to follow your steps to create a 2-level drill for school and department (using bar charts)but can't seem to achieve the same result. Can you help?
Thank you so much. I needed something to go from state, to county to city in map form and it worked perfectly. I do have a quick question. My three tier consists of state, county, city. When I drill down from a specific county, multiple states show. I am guessing this is because the county field, for example, Jefferson, is attached to multiple states. Since I am still relatively new to Tableau, I am struggling to find a proper function to ensure that only the cities from the specific county in the specific state show. Thanks in advance.
Another great video, Andy! I had some difficulty sorting out the workbook actions, but that was just about being careful with the source sheets. Is this functionality supposed to work in stories? I tried adding both dashboards to a story, but they stopped working. Is it me, or is it Tableau?
Great video Andy! Question, can this be done with a map (drill from region to state to zip code)? I have a dashboard I created last year that has a breakdown of each state to zip codes using viz in tool tip, but I think this would be a great option too. My company is a little behind in Tableau versions, so I don't have the ability to test myself yet.
My company has an older license of tableau--do you have a resource to learn how to do this when we don't have the option to "Control visibility using"?
Instructions are flawed for other visual types. Once you are 3 levels down in the hierarchy and further - your previous filters stop applying. You need to add multiple filters at stage 3 and later.
I think this was a better tutorial using dynamic zone visibility than the map drilldown.
I used this to make a 3 level map drilldown, was a bit complicated due to some factors in the data (there are a lot of Franklin Counties in the US haha), but I figured it out - main thing was using multiple filters on the zip code drilldown, and using FIP as my county data point rather than county name.
I think the region/state/postal code levels were easier to understand. I did end up using a marks layer but only so I could put the name of the county on the title row, which I thought was a nice touch and good way to keep oriented. And I like the idea of numbering the calculated fields and parameters!
This seems like a great one-stop shop for drilldowns in general. I appreciate the video.
These videos are so helpful and easy to follow -- thanks Andy for all the hard work!
My pleasure!
Great video! I applied what I learned to a 4 level drill down and it wasn’t too much extra work after mastering 3 levels!
I hope to reach your level of Tableau mastery, thank you!!
Nice work!
This is great information, thank you for sharing Andy!
This is great! Thank you!
Hi @vizwiz, Thanks for the great video, I used your method for 3 level drill down, but I don't know how to add the possibility of multi-selection in each level, that is, I want to be able to select several items in each level at the same time instead of selecting one item.
@AndyKriebel, thanks for explaining drill down and zone visibility but I tried to follow your steps to create a 2-level drill for school and department (using bar charts)but can't seem to achieve the same result. Can you help?
It could be that you put the worksheet in a dashboard and now it doesn't work. You need to change your worksheet action to a dashboard action.
Thank you so much. I needed something to go from state, to county to city in map form and it worked perfectly. I do have a quick question. My three tier consists of state, county, city. When I drill down from a specific county, multiple states show. I am guessing this is because the county field, for example, Jefferson, is attached to multiple states. Since I am still relatively new to Tableau, I am struggling to find a proper function to ensure that only the cities from the specific county in the specific state show. Thanks in advance.
You'll need to include a filter on State most likely in your county level sheet.
Thank you. I added a state filter with the value set to True and it worked. I appreciate the help.
@@chrisallen254 good stuff. Thanks for letting me know.
Another option not mentioned here that is specific to the US is FIPS, which is a 5 digit numerical value for county.
This content is amazing btw! If we apply this logic to a 5 level drill down, is there a way to go switch back and forth within interim levels?
There is. I haven’t created any content on it yet.
Another great video, Andy!
I had some difficulty sorting out the workbook actions, but that was just about being careful with the source sheets.
Is this functionality supposed to work in stories? I tried adding both dashboards to a story, but they stopped working. Is it me, or is it Tableau?
I’ve never tried it in Stories. I probably haven’t used Stories in 5 years.
@@vizwiz not a big surprise. Just thought I would ask. I seem to have a knack for finding things that don’t quite work the way I except them to.
Great video Andy! Question, can this be done with a map (drill from region to state to zip code)? I have a dashboard I created last year that has a breakdown of each state to zip codes using viz in tool tip, but I think this would be a great option too. My company is a little behind in Tableau versions, so I don't have the ability to test myself yet.
Here you go th-cam.com/video/BsP1hIXLV64/w-d-xo.html
this is not 3 level, correct?@@vizwiz
Andy can you make a complete tableau beginner to advance tutorial using real world dataset but please ensure dataset is not clean
It's called Udemy dude...for a cup of coffee you can get a course that does just that. Get to work!!
I will make it if you pay me to create it. :-)
Can you make one for year to month to week to date level please
My company has an older license of tableau--do you have a resource to learn how to do this when we don't have the option to "Control visibility using"?
Upgrade 👍🏻
Cool
Instructions are flawed for other visual types. Once you are 3 levels down in the hierarchy and further - your previous filters stop applying. You need to add multiple filters at stage 3 and later.