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 Жыл бұрын
Great to hear!
@ramkrishna133 Жыл бұрын
Thank you Andy for making the drill down and filtering logic so simple and easy to understand :)
@vizwiz Жыл бұрын
You bet!
@data_beta_7 ай бұрын
Super easy to follow for such an amazing technique. Thanks!
@vizwiz7 ай бұрын
You are so welcome!
@AhmedIbrahim-d3y2 ай бұрын
Thank you so much the explanation is clear and easy to follow
@anju7619 Жыл бұрын
This was a brilliant tutorial Andy. Thank you so much, its much appreciated.
@vizwiz Жыл бұрын
Glad it was helpful!
@maxfrantzyemmanueljean-pie80986 ай бұрын
Great video!
@jboyd3737 Жыл бұрын
Thanks! Truly adding to the body of knowledge for this profession and adding value to the world.
@vizwiz Жыл бұрын
I appreciate that!
@bavisshyaraghuraman28885 ай бұрын
ultimate sir thank you so much
@lilianacely3884 Жыл бұрын
Thanks Andy! Great video!
@vizwiz Жыл бұрын
Glad you liked it!
@charlesshepherd2717 Жыл бұрын
Great tutorial on this! Thanks!
@vyacheslavs564210 ай бұрын
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.
@jagadishparasuraman53927 ай бұрын
You're a Legend, sir
@Princivil6 ай бұрын
I was searching for this very comment because I had this issue!! Thank you ✨
@MickaelPETIT-PARIS4 күн бұрын
Hello, thank you for the tricks! It works very well. The only problem is how to filter at the same time on another graph, for example on a histogram which is next to the maps ? please
@JP_-oq3xn Жыл бұрын
What a great video!
@muhammadsajjad-pm2xv Жыл бұрын
Thanks Andy for Another Amazing Video ❤❤
@vizwiz Жыл бұрын
My pleasure!
@muhamadsatriaputra59055 ай бұрын
thanks coach!
@ashishkulkarni71197 ай бұрын
Thanks alot
@MuhammadHamza-hg7em8 ай бұрын
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.
@vizwiz7 ай бұрын
Thank you!
@imsajiv Жыл бұрын
Didnt see the data set link in the description only the published workbook is present
@vizwiz Жыл бұрын
Updated...also find it here data.world/vizwiz/us-cities
@tradeshow5478 ай бұрын
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.
@cecilia_mackie Жыл бұрын
So cool! Shall we connect?
@r.m.48353 ай бұрын
Anyone else having difficulty with the control visability on the dashboard. I followed everything but I do not see my DZV's showing up.
@AltafAlandwale Жыл бұрын
My heart broke as I saw you as an Arsenal fan :D
@AndianerWhhat Жыл бұрын
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?
@yeeyazz Жыл бұрын
Hi Andy! I am from Thailand that I use shapefile in city so that I see false only. Can you help me ? Thank you.
@Baqon425 ай бұрын
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?
@jenniferdinan7034 ай бұрын
I added a copy of the most specific level map I wanted...in my case was country, so I had "World", "Continent", "Country", and "Country Drill" as sheets. This allowed me to have my final visualization as the isolated country image.
@sukritis Жыл бұрын
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!
@johnprimeaux55595 ай бұрын
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......
@vizwiz4 ай бұрын
I don’t have County data either.
@yankiokdemir Жыл бұрын
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 Жыл бұрын
Dynamic zone visibility only works with parameters.
@rsnazario4 ай бұрын
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?
@vizwiz4 ай бұрын
Is your map pinned?
@rsnazario4 ай бұрын
@@vizwiz double checked. Not pinned. I allow pan and zoom. I followed the tutorial addapting it to my needs (3-level drilldown).
@gonzalooderda9394 Жыл бұрын
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 Жыл бұрын
Yes
@nolanstephenson25999 ай бұрын
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!
@vizwiz9 ай бұрын
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.
@nolanstephenson25999 ай бұрын
@@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
@PoojaPawar-gt9ee Жыл бұрын
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 Жыл бұрын
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.
@rabiamir8796 Жыл бұрын
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 Жыл бұрын
You sometimes have to manually type in the parameters to get the starting point correct. You’ll see me do that in the video.
@drt102 Жыл бұрын
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?
@ajaypranav13907 ай бұрын
Use a Reset filter and always display the country when all are empty
@romanvasiura6705 Жыл бұрын
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 Жыл бұрын
Unzip the workbook after you download it. All of the data is there.
@tink41711 ай бұрын
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.
@vizwiz10 ай бұрын
Agreed!
@Father_Prime10 ай бұрын
Totally agree. IMO, implementing drill-down functionality like this should be a high priority given that their primary competitor (Power BI) already has it.