Great video that doesn't lose its relevance! I dare add its timing for the most impatient: 1. 1:32 - dynamic reference line 2. 5:37 - split into two colors 3. 7:08 - sales forecast 4. 9:55 - sales forecast started from dynamic reference line 5. 14:45 - dynamic sorting 6. 18:18 - dynamic sorting combined with the Top-N 7. 21:32 - dynamic dimension 8. 24:13 - dynamic measure 9. 26:42 - dynamic axis name ??? 10. 27:30 - dynamic view (this is really hot!) 11. 32:18 - date range (&dynamic title) 12. 36:09 - user-defined moving average 13. 39:45 - dynamic scatter-plot 14. 44:30 - filtering across data-sources (&option to pick 'All')

@vizwiz

3 жыл бұрын

Impressive note taking! Thanks for doing it.

No other words enough for this course and your dedicated effort to the data people. Andy, you are genuine!

@vizwiz

3 жыл бұрын

My pleasure. Thanks for the kind words.

Amazing video that still is applicable 5 years later, cant wait to use what I learned!

@TheRaju991

3 жыл бұрын

Absolutely!

@vizwiz

3 жыл бұрын

That’s wonderful! Thanks for letting me know. Good luck!

Awesomely done! Clear and Crisp usage of Parameters in Tableau +Andy Kriebel

Seriously- great job with this! You really have a knack for simplifying and identifying truly useful features

Many thanks! I've been trying to get my head around Parameters and you've helped me to understand them! Thumbs up!!

The best video covering a wide variety of use cases in Tableau. Must watch for all Tableau Learners

Thanks for the video Andy:) This gives me the perfect understanding of Parameters!

your channel is gold. thank you for all your examples! this will help me so much since I will be working with a lot of data and visualization with Tableau.

Loved it, Cleared my basics.

Extremely helpful, explained in a way that I now understandpParameters and calculated fields. I haven't worked out the best option to allow me to simply filter between two data filters (i.e. contains in this field or another field) but I think I'll get there. Many thanks Andy.

Thank you Andy. Really excellent!!!

This was fantastic, extremely helpful. Kudos

Thanks for the best video about Parameters in Tableau!

Thank you for putting these together !

All I needed to know, I got solutions in ur video. Thanks a lot to u. God bless you :)

Hi Andy, I am new to Tableau and I can't explain how much this video helped me to understand Parameter use cases. Thank you so much!

@vizwiz

Жыл бұрын

You're very welcome!

Great work and explanation , Now I found it many ways of how to utilize parameters and when.

thank you Andy! Very comprehensive and easy to absorb.

@vizwiz

3 жыл бұрын

Excellent! Thank you.

It is one of the best tutorial, I really appreciate your efforts, great job keep it up.

Awesome video with great explanations.

Awesome! Great video! Lot of information amd tricks one single short video! Thank you very much.

Exactly what i was looking for. Thank you 🙏

Parameter examples are very useful. Appreciate your efforts to make the video on parameters with different type of examples

Thank you for the inputs ! Learnt new things today !

@vizwiz

Жыл бұрын

My pleasure!

Hi Andy, Thanks for making these wonderful video tutorials. I noticed that you have Alteryx installed on the Mac. I do not see the Mac version on their website. How can I run Alteryx on Mac ?

Good information. Pacing makes it have to follow.

Thank you for very helpful tips. I have a question on using the parameter to forecast sales. In the example you show, all Subcat is forecast to grow at the same rate. Is there the way to allow each Subcat to have a different forecast rate?

Andy your a legend !!!! My go to channel for help 👍

@vizwiz

Жыл бұрын

Thank you :-)

Hey, how did you get the video to fit exactly like that in the dashboard? Thanks for sharing.

Thanks..very helpful for Tableau beginner. Easy to follow.

great video! it helped me a lot!

Awesome stuff. Thanks.

This video is jewel for me, learnt a lot of Visualizations in this video!!! Thank you so much sir!

@vizwiz

2 жыл бұрын

Fantastic! Thanks for the kind words.

Very Helpful.

I had the same problem described by Gabriel Castellanos. "Hi Andy, thanks for your video, it's so cool, but I have a problem because trying to do the first example I drag Reference Line but I don´t have the option to put it on Date, just the Table, Pane and Cell options. Do you know how to fix it?"

Thank you Andy for a nice demo. Is it possible to run multiple select what-if scenarios for a single dimension? Using your example above (around 09:00 time on your video), I'd like to be able to create a sales forecast parameter that will be different for different sub-categories. So, we will have parameter fields for each sub-category where we'll choose different values: Appliances 5%, Labels 2% etc. Do you think it is possible? Thank you

Hi Andy, Can you please clear my one doubt as if we are doing dynamic sorting by measures. So we should take only the measure field which are used in view or we can take any one.

Thanks, so much learning for me.

This is such an amazing tutorial, thank you!

@vizwiz

Жыл бұрын

Glad it was helpful!

Thanks Andy..

Hi Andy, thanks for your video, it's so cool, but I have a problem because trying to do the first example I drag Reference Line but I don´t have the option to put it on Date, just the Table, Pane and Cell options. Do you know how to fix it?

@balugarisairamshankarbalug3517

6 жыл бұрын

Hi Can you please help on below thing community.tableau.com/message/709562#709562

What if we just drag and drop order date to filters rather than creating parameters(date filter)?

incredible...awesomeness by andy kriebel

Hello @Andy Kriebel thanks for those tips. It will be helpful if tell me a way that my Date parameter will updated by the date from my database field if the date is changed or added in a table. as the parameters will not get updated automatically we need to go and updated the field to pick the latest from the field.

How to remove blank row or column when we use % difference of table calculation i have already tried with simple hide option and index() but these sol hide all the data with respect to the hidden field

you made parameters so easy for us. Thank you.

@vizwiz

Жыл бұрын

My pleasure!

This is great. Thanks!

all i can say is beautiful!!!!!

Very insightful...

very useful video, thank you sir :)

Hi Andy! Excellent video. It was very helpful. However, I am not able to use parameter to select a worksheet (Bar chart / Map). I did the exact same thing as you. I created a Vertical container and dropped the first chart in it. Then, I tried to drop the second chart (worksheet) into the lower end of the container. In your video, the selected worksheet quickly occupied the entire container. However in my case, both the worksheets takes equal space (half-half) regardless of the parameter value. So when one worksheet is selected, the other half remains blank. I have been trying to do this for a long time and have been facing the same issue. Now, I saw your video for some other reason and when I saw this I was excited. Still, I am not able to do it. Any help would be appreciated. Please tell me what I could possibly be doing wrong. What I did: 1) Create a treemap in one worksheet 2) Create a bubble chart in another worksheet 3) Create a parameter to control it and apply the corresponding Calculated Field value to the filter (the non-selected worksheet becoming blank works fine) 4) Create a dashboard and try to pack both the sheets in a VERTICAL CONTAINER (Yes, I did not use the horizontal one because I read somewhere that it won't work). I really want to know what I am doing wrong :) Thanks a lot Andy! I am a great fan of your Soccer dashboards in vizwiz.com. Keep doing the great work!

Thanks!

Very helpful. Thank you!

@vizwiz

Жыл бұрын

You're welcome!

Where can I find this data set? I would love to work with the data set you've used in this example. Thanks!

@sravansaisravan3854

3 жыл бұрын

you could try global superstore data set

Awesome !

Hi Andy, Have you ever try Parameters And Filter based on OR condition. There is one situation I am facing is with my filter option where while doing filter its satisfying only few filter condition but it should do an OR operation and satisfy all of them If you came across something like this plz let me know for any clarification as well

Hi Andy, this was fantastic! For forecasting - is there a way to get a table of forecast values per month instead of the line chart? Reason is that I would like to be able to show the expected year-end revenue per state * a commission % so we can have a monthly revised estimate of year-end commission. Thanks! Ryan

@vizwiz

8 жыл бұрын

+Ryan Shukis right click on the sheet and choose Duplicate as Crosstab.

@Shremmer45

8 жыл бұрын

+Andy Kriebel Alright, almost there! How would I sum Actuals + Forecast for year-to-date + year-to-go ?

@vizwiz

6 жыл бұрын

Ryan Shukis you can probably do it with a table calc.

Hi Andy - Great video as usual. I was wondering is there a method that I can use to show only relevant filters for parameters? I have a dashboard that uses 3 params as filters but can’t get a ‘show relevant values’ option. Many thanks

@vizwiz

Жыл бұрын

Nope, that's not an option. You might want to use sheets that act as filters. That way when you click on one dimension, it could filter that sheet to relevant values.

Hi Andy, very nice presentation. Can you provide the data set/s that you used? I like to follow what you did. Thanks.

@vizwiz

Ай бұрын

I think they mostly use superstore.

Genius!

Great video, is there a way you can share the sample datasets you ve used in the video? Really want to do a step and step follow along the video

@vizwiz

5 жыл бұрын

Hi Ian. You can download the workbook from the link in the description. Unzip it and you should see all of the data sources.

4:37 the parameter I created is not listed in the Reference line drop down list. This is because you did not add the parameter to the sheet. I am on PC; maybe on a Mac you don't need to do this (?). Right click on the parameter>Add to sheet. Once that is done then the parameter (Pick a Date) is listed.

Hi Andy. Great video. I have a problem with a filter. Hope you or someone can help me solve it. I have a slider filter that goes from ranges 10 to 100 in increasing values of 1. What i want is to limit the range of values to 10....so if my lower value is 13, my higher value can be any integer number between 13 and 23 but no greater than 23 , so the user can only select ranges of maximum 10 values each time, between the range 10 to 100. Thanks in advance

@balugarisairamshankarbalug3517

6 жыл бұрын

Hi Can you please help on below thing community.tableau.com/message/709562#709562

Hi Andy, First of all great video. I wanted to know two things regarding using parameter as a filter for different data sources. First- in the video we have taken parameter values from the Region field from sample superstore. Will this be updated if in the future more regions flows in. Second- We can also use the same filter in two different data sources by using data blending. Which one will be more efficient? Using parameter or using data blending. Waiting for your reply.

@vizwiz

Жыл бұрын

1 - Yes, you can configure the parameter to update based on a field when the workbook is opened. 2 - It's use the parameter as a filter instead of blending.

#Great Session. It has given me a advance level of usage for Parameter in Viz. ............... With this I want to know, will it possible for me to attend next live session ? If Yes, how can I registered for the same ?

@vizwiz

8 жыл бұрын

+sumeet bedekar not likely. I did this for some of our customers. I recorded it to share with everyone else.

Hi Andy, Thanks for your Video. I have scenario like below. Here I am not having any problem with the Data. My challenge is Displaying of the Date Parameters. If I select any View, only the Dates which belongs to the particular sheet to be displayed. (Date Parameters). I have total 5 Date Parameters. Order Date only for the Hourly View. Order Start and End Dates only for the Monthly View and Shipping Start and End Dates only for the Daily View. Always these 5 Date parameters are displaying in the dashboard when I drag all these three sheets. But I want only related dates should be displayed on the dashboard based on the selected View. Hope you understand my requirement. (Making the Date parameters display, specific to a selection). Could you please let me know if you need any more details. Appreciate your efforts. Thanks in Advance Chandrasekhar

Can we have multi select option through parameters in Tableau?

@vizwiz

3 жыл бұрын

No. You might want to consider sets instead.

I have 13 weeks of stocks data.. I want to see the difference week 1 to week 2 and so on.. But the difference week. Needs to be user driven.. I. E.. User can select week 2 and week 4 then it will determine difference between week 4 and 2.. If user select week 1 and week 13..it should determine difference between weel13 and 1..is it possible possible at run time

@vizwiz

4 жыл бұрын

Yes

@loomdoby

4 жыл бұрын

@@vizwiz thanks.. Please do give me some tips

Please share your workbook as I am still getting different results doing the same procedure.

@vizwiz

Жыл бұрын

Look in the description

Hi Andy, I have a Parameter issue, that I cant seem to find a solution for and I was hoping you could point me in the right direction. My dashboard has multiple parameters and sets (for multi-select options) Is there a way for a selection in one parameter to "filter" down the available options in the other parameters? For example: Say you have 2 parameters one for a vehicle type and the second for vehicle Models. The 1st parameter has Car and motorcycle. the second parameter has a list of models both cars and motorcycles. This issue I am having is that if I select "motorcycles" from the 1st parameter, Tableau does not instinctively filter the second parameter to the motorcycle models. Do you have any suggestions? Thank you so much for your videos. They have really helped me.

@vizwiz

3 жыл бұрын

You can have a parameter update from a field when you reopen that workbook, but you can’t have it dynamically update based on a selection from another parameter or field. I’d recommend a regular filter instead.

@hello-u2w

3 жыл бұрын

@@vizwiz I figured it out with quick filters. when you show the filter you have to go into the filter option and select "Only Relevant Values" I wish tableau was intuative as Power BI. Cheers!

@vizwiz

3 жыл бұрын

Yes, that’s what I meant for the filters. I should have been more specific. I’m glad you got it sorted.

In Dynamicc view how the Dimension Filter function is Select a Dimension parameter ='State' That is the only State word then it is not a Real state in the field how it finds that

Say we have a start date of 1/1/2018 and end date of 12/31/2018 .. when user select any date from the parameter he/she should see a max of 3 months of sales view( a quarter) only and this max duration adjust itself when user select a date beyond october because there wont be 90 days of sales to see... how can we accomplish this ?

@vizwiz

5 жыл бұрын

Good questions for the forums. I don't provide help desk type support on this channel.

@uhsay1986

5 жыл бұрын

@@vizwiz Thank you , sorry for bothering you.

Thank you for sharing this, I have a question in case I have differents parameters that depend from each other. For example, I have a parameter 1 that contains 2 values: Energy and Electricity. For each of those I have different metrics. So I have another parameter 2 named Metric. My issue here is that I want the parameter metric to show only metrics related to energy when i select energy and same goes for electricity. Any ideas ?

@vizwiz

3 жыл бұрын

Let me make sure I understand. If you choose Electric, you want the Metric parameter to show a couple of metrics in the list. And when you choose Energy, you want to show a different set in the list. Correct?

@dorraboughzala7639

3 жыл бұрын

Yes exactly :)

@vizwiz

3 жыл бұрын

@@dorraboughzala7639 to do that, you would need to reshape the data so that you have a single column for all of your measures. You would then need the field that contains Energy and Electricity to be a filter. This could then filter the list of measures since all of your measures would be in a single column.

@dorraboughzala7639

3 жыл бұрын

@@vizwiz Thank you so much! I will work on that :)

Never knew Andy had a Indian brother

hello I hope this comment will be read by someone. I want to know if in the last example there is a join between the two data sources. My task to solve is to create a button or a dropdown list to switch graph created with dimensions and measures from different data soucerces. Is it possible to do it if the original tables are not in join?

@vizwiz

4 жыл бұрын

Hi Cristina. You can download the workbook from my blog. Once you do that, unzip it and you should be able to see how the connection was created.

@cristinabcasale6942

4 жыл бұрын

@@vizwiz thank you so much, great job with your videos

I have tried your examples I am currently on 9th but somehow some of the results are not matching the results shown in your visualization. Could you please share with us your viz so I can check what is the difference.

@vizwiz

Жыл бұрын

The link is in the description. Here it is again. I hope you find it useful. www.vizwiz.com/2016/05/tableau-tip-tuesday-12-use-cases-for.html

In 31:32, this problem is nasty. One solution is to de-select the "entire view" and fix the view with padding to keep all views on the same horizontal line.

Hi,Can i have the data set ?

@vizwiz

3 жыл бұрын

It’s superstore.

Andy: in a real bind. Can I use a click after to filter a parameter? community.tableau.com/message/868307?et=watches.email.thread#868307 Basically, I have a line chart on one dashboard and bar chart on the second dashboard that have the same parameter. I also have bullets explaining my data differently on the first dashboard. I want to click the first dashboard's bullet to have the related bar chart appear. It's really urgent been at for 4 days per a request by my supervisor who refuses to accept this can't be done.