Choose a Chart Type with Parameter Actions in Tableau

  Рет қаралды 37,294

Andy Kriebel

Andy Kriebel

Күн бұрын

Пікірлер: 73
@indigoiis
@indigoiis 4 жыл бұрын
Not only was this wicked helpful, but I was able to expand on this: I had my parameters switch between five maps. It worked great until I realized I had data points in Alaska and Hawaii as well! So I HI and AK maps for each continental map, restricted to those states but with the same filters/details/colors etc.. then I added two vertical containers (one for HI and one for AK) and repeated the steps in Andy's video above to add these "submaps". Then I made these floating and positioned where I wanted them. Works like a charm to add Alaska and Hawaii when I have data points on one of my maps! THANK YOU!!!
@MissFSimoes
@MissFSimoes 3 жыл бұрын
Thank you, Andy for your generosity in sharing your knowledge!
@williamdemourabezerra4944
@williamdemourabezerra4944 4 жыл бұрын
Another master piece!! Thank you! You helped me a lot in my Tableau projects. Thanks again and cheers from Brazil
@April-td2rb
@April-td2rb 2 жыл бұрын
This is a great tutorial. I've never seen the easiest lessons for the switch sheets.
@vizwiz
@vizwiz 2 жыл бұрын
Glad it was helpful!
@dominicnicholas119
@dominicnicholas119 4 ай бұрын
Thank you! I needed to make a small adjustment for version 2024.1.2 : when creating the chart type selected filter, select Wildcard, select Exactly matches, and enter the exact param value you want to trigger off. I eventually moved away from this technique to use dynamic zone visibility parameter control instead but this was super helpful nevertheless.
@vizwiz
@vizwiz 4 ай бұрын
Thanks for sharing!
@iunchen6410
@iunchen6410 4 жыл бұрын
WOW! Super cool and will immediately be put to good use!! Thanks for the simple yet insightful tutorial!
@kevinhenry1681
@kevinhenry1681 4 жыл бұрын
This is great, Andy! I can certainly use this tip in my Tableau projects.
@AkilanXtremer
@AkilanXtremer 4 жыл бұрын
That was so easier than I thought! Great Job Andy!
@vizwiz
@vizwiz 4 жыл бұрын
Thanks! 👍
@tusharmore937
@tusharmore937 4 жыл бұрын
Really useful, I use this a lot. Thanks a lot for sharing, Coach!
@pravinjoshi72
@pravinjoshi72 2 жыл бұрын
You are You! Kudos Andy!
@indigoiis
@indigoiis 4 жыл бұрын
Thank you! Always great.
@pradeepsagwal
@pradeepsagwal 4 жыл бұрын
Unique use of parameter 👍🏻👍🏻👍🏻
@oliverinca5819
@oliverinca5819 3 жыл бұрын
Awesome video! Quick question. Out of curiosity, why did you use AVG(0.0) and AVG(0.00) for the other two axis rather than just AVG(0) for all three?
@vizwiz
@vizwiz 3 жыл бұрын
Great question! By making them unique, Tableau will treat them as separate fields.
@rupam8107
@rupam8107 3 ай бұрын
This is really good. Also is it possible to make it green based on selection. If we select a particular button that will come green and vice versa.
@StockSpotlightPodcast
@StockSpotlightPodcast 4 жыл бұрын
Great tutorial. However, when I select the individual parameter drop down "bar" on the Bar Chart tab, it changes bar to a bar drop down for all the other tabs (Line Charts & Map). How can I get this to stop from happening? The result is that only the line chart and map are showing when toggling between chart types on the final dashboard.
@rashmirana7861
@rashmirana7861 4 жыл бұрын
Thank you Andy. This was awesome
@kaythjingchunkang6429
@kaythjingchunkang6429 4 жыл бұрын
Hi Andy, thank you so much for the tips! But in my case, after hiding the titles, they don't automatically adjust .. what should I do?
@vizwiz
@vizwiz 4 жыл бұрын
You’re sheets are probably fixed width or height. Make sure they are not.
@hhyperball
@hhyperball 2 жыл бұрын
This is lovely! Thank you very much!
@TravisTraps
@TravisTraps 2 жыл бұрын
Very handy trick! Thank you.
@trishjais
@trishjais 4 жыл бұрын
I knew about the use of parameters to swap the sheet, but this, leveraging the parameters action to dynamically update the parameter is magical, a big thanks Andy, any other use case, you'd like to give other than changing chart type ?
@malungosebastiao
@malungosebastiao 3 жыл бұрын
MANNNNNNNN YOU SAVED MY LIFE
@emmamartin863
@emmamartin863 3 жыл бұрын
Hi Andy, Thank you for this! I am trying to do this same thing with different charts altogether (not chart type, rather fully different data), BUT I need to be able to see the legend when the Viz changes on click. Is that possible?
@vizwiz
@vizwiz 3 жыл бұрын
You would need to have the legend for each worksheet in the dashboard. I’d recommend hiding the titles on those so that they appear to go away when you swap sheets.
@byronmendoza3432
@byronmendoza3432 3 жыл бұрын
Hello Andy thank you for sharing this knowledge, quick question: it is working for me and hiding after removing the title but if I change the dashboard size to ¨automatic¨the spaces of the other charts appear again... do you know how could I make it work in automatic size?
@vizwiz
@vizwiz 3 жыл бұрын
Make sure all of the sheets in the containers are NOT set to fixed width or height.
@dataveve
@dataveve 4 жыл бұрын
This is cool .. Is there a way to use it to change chart between different data sources?
@vizwiz
@vizwiz 4 жыл бұрын
I'll create a video for you. It's too long for a comment, but short for a video.
@dataveve
@dataveve 4 жыл бұрын
@@vizwiz thanks sir
@mythilisubramanian6580
@mythilisubramanian6580 2 жыл бұрын
Hi Andy, I am unable to use "Chart Type Selection" Calculated field to Filter out Bar/Line/Map. While being in Bar Chart sheet, I select Line or Map in "Chart Type" Parameter, it does not go blank. Kindly help me to filter out Bar/Line/Map using the calculated field. I am using Tableau Public (desktop version). Thanks in advance. Mythili.
@vizwiz
@vizwiz 2 жыл бұрын
Double check how you are adding it to the filters. Change the parameter so the chart appears on one sheet, then filter the other two sheets to exclude that option in filter. Repeat for the other sheets. So each sheet should have two items excluded in the filter.
@mythilisubramanian6580
@mythilisubramanian6580 2 жыл бұрын
Thank you@@vizwiz. As suggested, I duplicated the "Chart Type Selection" Calculated field and added this duplicate one to Filter shelf to exclude two items. Thus each sheet had two items excluded in the filter. I completed the dashboard as shown in the video.
@dreadful-twerp
@dreadful-twerp Жыл бұрын
@@mythilisubramanian6580 Thank you for the tip! Like you, I found that selecting, say, Line in the parameter did not cause the others to go blank. Even adding a duplicate to the filter and setting it to "exclude" did not help. I finally got it to work by, for example, creating a custom "Exclude Bar and Line" with the code [Chart Type] != "Bar" AND [Chart Type] != "Line" and put that on the Map filter set to TRUE. I then put a "Exclude Line and Map" on the Bar and "Exclude Bar and Map" on the Line.
@asthapuri2379
@asthapuri2379 4 жыл бұрын
Wow! This is amazing. Thanks for sharing.
@mikarshdataanalyst4086
@mikarshdataanalyst4086 3 жыл бұрын
Very helpful tutorial!
@SushantAsija
@SushantAsija 4 жыл бұрын
Thank you so much. was looking to create a similar thing today.
@vizwiz
@vizwiz 4 жыл бұрын
Most welcome 😊
@shaquellejacobs7930
@shaquellejacobs7930 2 жыл бұрын
I am going to do this for 3m 1yr and weekly chart so cool
@cfischer3770
@cfischer3770 Жыл бұрын
Hi Andy, I am using Tableau 2022.2.6 and have been trying to set up the parameter "switch" calculated field to function but without any success. Is there something different about this version that would not allow the chart to toggle between the chart types? Thanks Andy in advance. Caroline.
@vizwiz
@vizwiz Жыл бұрын
No, it should work. Double check that you followed the steps exactly.
@konstantin3242
@konstantin3242 Жыл бұрын
@@vizwiz doesn't work :( changing parametr doesnt affect the graphs of different types
@danieltertilt
@danieltertilt 3 ай бұрын
Pie Chart and Tree Chart won't collapse fully. All are set to "entire view". Any idea?
@vizwiz
@vizwiz 2 ай бұрын
If you have the title showing or manually sized them it won’t work.
@bartjutte4013
@bartjutte4013 4 жыл бұрын
Very helpful thanks!
@Smokeythewelder
@Smokeythewelder 4 жыл бұрын
Great video. Thank you.
@DeepakBusanagari
@DeepakBusanagari 4 жыл бұрын
This is Super Awesome (y)
@MrStark-zy6cd
@MrStark-zy6cd 4 жыл бұрын
It really is magical!!!!
@kidstantrums1180
@kidstantrums1180 3 жыл бұрын
Hi Andy, I am able to replicate everything except the parameter actions part. If I use one parameter action, it works fine but when three action parameters are there, the toggling of values in the parameter doesn't work. Can you please help, Already tried so many things !!
@vizwiz
@vizwiz 2 жыл бұрын
Double check that you don't have two actions updating the same parameter.
@meetalipandey8073
@meetalipandey8073 3 жыл бұрын
Thanks for sharing..!!
@nabiila_3703
@nabiila_3703 3 жыл бұрын
when I hide the title. the container size of the hidden sheets still remain. is this bcz I use the old version of tableau (19.2)?
@vizwiz
@vizwiz 3 жыл бұрын
You probably have the sheets that are supposed to hide pinned to the width or height.
@spidLL
@spidLL 4 жыл бұрын
This is pretty cool
@sidneyaburi
@sidneyaburi 2 жыл бұрын
For some reason my worksheet on the dashboard won't collapse when I hide the title. Anyone else experienced this? Any ideas why this is happening?
@vizwiz
@vizwiz 2 жыл бұрын
The worksheets must be in a container, the titles must be hidden and the fix width or height must NOT be set for either worksheet.
@Pidamoussouma
@Pidamoussouma 4 жыл бұрын
This is awesome...
@datavizenthusiast3560
@datavizenthusiast3560 3 жыл бұрын
Awesome !
@steveramirez9436
@steveramirez9436 3 жыл бұрын
Yeah no problem. Sorry I've not been around to much. Just have a lot going on with my case life bills and on top of that catching another case. Four weeks since I received any income. It's like I take a step forward to get knocked down three steps back.
@mohammadshiblee9064
@mohammadshiblee9064 2 жыл бұрын
Sir, if every sheet is contained filter options as well... then how will manage the filter on the basis of the selected sheet?
@vizwiz
@vizwiz 2 жыл бұрын
I don't understand your question.
@krazyanalytics7462
@krazyanalytics7462 4 жыл бұрын
Amazing
@renun1623
@renun1623 4 жыл бұрын
Nice video helpful
@stephaniecairo7335
@stephaniecairo7335 2 жыл бұрын
you saved me
@vizwiz
@vizwiz 2 жыл бұрын
That's great to hear. Thanks for the feedback!
@dhananjayw2238
@dhananjayw2238 3 жыл бұрын
hiding the title does not reduce the size..
@vizwiz
@vizwiz 3 жыл бұрын
you have to hide the sheet titles, make sure they are all in a single container, and make sure none of them are fixed size. You can download the example.
@simonbernard4216
@simonbernard4216 4 жыл бұрын
This is so confusing. Does the "Filters" section automatically recognizes strings associated to chart types?
@vizwiz
@vizwiz 4 жыл бұрын
Essentially, yes. You can download the workbook to see how it’s done. The video shows you as well.
Blue vs. Green - What does it mean in Tableau?
11:58
Andy Kriebel
Рет қаралды 8 М.
Deadpool family by Tsuriki Show
00:12
Tsuriki Show
Рет қаралды 7 МЛН
Cheerleader Transformation That Left Everyone Speechless! #shorts
00:27
Fabiosa Best Lifehacks
Рет қаралды 14 МЛН
Cat mode and a glass of water #family #humor #fun
00:22
Kotiki_Z
Рет қаралды 18 МЛН
Swap a Field with a Parameter in Tableau
12:44
OneNumber - Tableau Experts
Рет қаралды 4,2 М.
How to use Parameter actions in Tableau Desktop 2019.2 and newer
12:26
How to Create a Year→Quarter→Month→Day Drilldown in Tableau
11:35
How To Use Set Action In Tableau
11:38
Darpan Bajaj
Рет қаралды 4,3 М.
Donut Chart Drill Down in Tableau using Parameter Actions
22:06
ANJUL PATHAK
Рет қаралды 16 М.
How To Use Parameter to Change Dimension or Measure in Tableau
17:28
Create KPIs in Tableau in Just 10 Minutes!
11:23
LaDataViz
Рет қаралды 7 М.
18 Ways I Create Bar Charts in Tableau | Tableau Tutorial
15:19
Andy Kriebel
Рет қаралды 22 М.
Tableau Horizontal Parameter Selection With Radio Buttons
8:36
DanceSingwith Data - BI & Analytics
Рет қаралды 9 М.
Deadpool family by Tsuriki Show
00:12
Tsuriki Show
Рет қаралды 7 МЛН