Need help setting up your custom filter swap? Schedule an hour with Eric: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Hey Eric. thanks for the excellent video. Filters are a real thing for me at my current stage in Tableau development. Your video addressed a major issue I've had regarding the client insistence on having so many filters available on every dashboard - what I've recently come to describe as EEA (Everything, Everywhere, All at once - I was thinking of trademarking this but someone called OSCAR made a film with the same title - go figure!). I'm really loving the content from both you and Ollie. I've already saved a number of your videos for future reference and this one has been added to my 'Best in Class' group.
Thanks so much Paul. I hope this video helps a lot of folks who have the same problem with too many filters. It's always nice to get feedback and hear these videos are truly helpful!
Hi Rahul! Not exactly but you can accomplish the same thing for parameters using Dynamic Zone Visibility. Here's a video on DZV: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
How did you align those filters college name drop down, program name, year of application name, and cards aligned ? Do you 've primary video tutorials to build them ?
Hi! We have a blog post on efficient filter layout here: onenumber.biz/blog-1/2019/11/11/efficient-filter-layout-for-tableau-dashboards Hopefully that helps!
I do like this a lot. Does save space. Just want to clarify if we can use multiple filters at the same time with this. For example, part time and over 18 and female.
Thank you! Unfortunately, that is not correct. The limitation here is that you can only select values from whatever field is selected in the parameter.
@@meghasharma6381 That won't work with this approach. Maybe you can switch to an approach where you have a container that appears/disappears with additional filters? Here's a simple video on how to do that: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Z9vc4t-Kf5c.html&ab_channel=RigorDataSolutions
If you wanted to be able to select multiple filters, let's say 2, could you repeat this process twice and call the first additional filter field 1 and the second additional filter field 2?
Very Helpful! Any tips on how to handle context filters in some parameters/fields? I am mapping flight paths and this technique allows the choice to filter by airline, origin or destination. But it would be nice to be able to group origin by country or destination by state using context filters.
Hi Matt! Hmm, I'm having trouble envisioning what these filters look like and how they would interact. Are you able to provide a screenshot of what the filters looks like? I'm assuming the "Only Relevant Values" selection in the filters isn't working the way you want? kb.tableau.com/articles/howto/how-to-show-only-relevant-values-in-filter-when-using-data-blend
Hi brother, I have one query that I am unable to find last 90 days and pervious 90 days avg. And i want show that % of different in KPI and the data update every few hours. Do a video for this issue. That will help us. Thanks
Hi Ashok. That's pretty specific so I don't think we'll make a video on it but here is some of the logic you need. Last 90 Days: AVG(IF DATEDIFF('day',[Date Field],TODAY())
@@onenumbertableau Thanks for your reply - not expected but really nice! I found a solution: when setting up the parameter, I have one integer Value = 0 (or any number), Display as 'Overall' (which means no filter is applied). Then in creating the calculated field, I had CASE [parameter] WHEN 0 THEN 'Overall'. That solved it - just as you suggested.
Need help implementing this approach? Book an office hour to work with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 Ready to take your Tableau skills to the next level? Check out our upcoming classes here! www.eventbrite.com/o/onenumber-15678294163
May I ask a question, When creating the Calculated Field - "additional filter field". I did exactly the same for the parameter setup. However, tableau keep telling me Age group and all the rest are not exist. [reference to undefined field] I don't know why. Thanks.
Hi! You'll need to adjust the calculation depending on what type of parameter you create. I created an integer parameter so I referenced integers in the CASE statement. If you create a string parameter, you'll need to reference string values instead. For an integer, it works like this CASE [Parameter] WHEN 1 THEN [Field] END If you did string, you'll need quotes like this. CASE [Parameter] WHEN "1" THEN [Field] END
Hello there, cool video. I have a question tho at 2:17 the dashboard went blank because you selected something else from the primary filters. How can I make the dashboard not go blank but select an available variable automatically. This is quite urgent pls and I would appreciate a quick and detailed response. Thank you
I would ensure you select "All" before switching to another option. otherwise you will have an invalid selection based on the new field you switched to. There isn't a simple solution to get around this that I'm aware of.
I don't think I would want a design where a filter is applied but I can't see it. Maybe something like a collapsible menu container might be a better fit? (www.tableau.com/blog/how-create-collapsible-menu-container-tableau)
Need Help : if I created a dynamic 13 month rolling filter by creating calculated field datetrunc and parameter on date. How can i trigger another filter which can give me value (comment for that month) of selected month which i am rolling in for. Cause its messing up the current month value as as its still taking up the value (comment for that month) and showing for all 13 month months.
I think your best bet lies with using the LOOKUP function (more on that here: onenumber.biz/blog-1/2017/10/9/comparing-year-over-year-in-tableau). I won't be able to write the correct formula without meeting to work through the details. Feel free to book an office hour if you want to tackle it together: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
guys, is it possible like create a parameter/button/filter whatever, that when I click it change my others filter values? Like when I click in it, change my Region to Canada, my Category to Forniture..
I've come across this question before and I don't think so - at least, there isn't a nice, elegant solution. If it is a possibility, my hunch is that Parameter Actions might be able to help (help.tableau.com/current/pro/desktop/en-us/actions_parameters.htm). Please let us know if you find a great solution!
Wow, so sorry this can't be done, really need it. It's going to break my little mind, but I think to solve is to go to the raw data and add sets of calculated fields that represent filter combinations and bring them into Tableau....@@onenumbertableau
