Totally Customizable Top/Bottom Filter in Tableau
ฝัง
- เผยแพร่เมื่อ 31 ม.ค. 2025
- Connect with us:
•Upcoming Tableau Classes: www.eventbrite...
•Book an Office Hour with Eric: www.eventbrite...
•Subscribe to the OneNumber Newsletter: onenumber.biz/...
•Follow Eric on LinkedIn: / eric-parker-37513249
Description:
Users love filtering and sorting options in Tableau dashboards, right?
Odds are, you know you can use a parameter to change the top number of values displaying in a worksheet. However, did you know you can also use a parameter to change whether it's the Top 10 or Bottom 10 values displaying? Did you know that same parameter can control whether the sort order is ascending or descending? It's true!
Check out this video to learn how you can build a totally customizable top/bottom filter for your Tableau users!
Related Resources:
•Tableau Public Example Workbook: public.tableau...
•Swap a Field with a Parameter: onenumber.biz/...
•Filter on Top 10% in Tableau: onenumber.biz/...
Need help setting up your Tableau actions? 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
Why I am I finding to channel this late !!!! You guys are the best. Just diving to the point and answer all the questions.
Thanks so much, we're glad you are finding our content helpful!
This was so so helpful I can't thank you enough
Excellent! We're so glad to hear it helped!
Thank you very much! Your video was very helpful.
You are welcome!
Thank you for the tutorial - it is very helpful! Would you be able to provide some guidance on how to show the lowest value (Wyoming) at the top when viewing the Bottom N values?
Sure! I'd recommend hooking the asc/desc parameter up to a Rank calculation which is hidden and controls the sort of the view. Here's some background on how to create that calculation: onenumber.biz/blog-1/2020/4/8/giving-your-user-multiple-sorting-options-with-tableau-parameters
Perfect! Thank you very much!@@onenumbertableau
@@ba6_maistora You're welcome!
This video helped me so much! I’m so grateful for your channel. I just discovered it yesterday and I’m already learning so much.
Quick question if you don’t mind: I’ve got my top and bottom rankings, but with some filter options there are between ten and twelve items shown, instead of just ten. I was wondering if it was because of tied tenth values but that’s not always the case. How do I get Tableau to consistently show ten items on the nose? Should I just create a filter as you do in this video, set it to ten, and hide it? I’m ranking by a swappable field so I can’t just filter by top ten there.
Hey Johnathan, thank you for the kind words! You are correct. You are likely getting more than 10 because of ties. At around 5:00 in this video, if you use the function RANK_UNIQUE() instead of RANK in your calculation, that should resolve your problem!
@@onenumbertableau I spent about an hour on this yesterday, and this solution worked in about ten seconds. That’s the same thing that happened with this top/bottom video-I’d spent hours trying to figure it out and after your video I was able to get the results I wanted as easily as following instructions on how to make a PB&J. You two are the best! When this RANKED_UNIQUE solution worked immediately, I almost welled up, I was that relieved and happy. You’ve got a fan for life! Thank you so much :)
@@NocturneTheatre You are so welcome! Thank you for letting us know!! That's why we do it :)
This will work only if the values are negative for Bottom ?
because when the values are positive and we do it bottom then it will sort based on the higher-lower
Hi! It will work whether the lowest values are positive or negative. The most important factor is to determine is it's going to sort Descending (high to low) or Ascending (low to high). Ascending will always start with the lowest numbers whether they are negative or not.
The video was very helpful but I had a similar problem..... The Top sorts perfectly but the bottom shows all the customers with zero sales.. the rank is not filtering according to the specified number for bottom ... Could U get any assistance..
When I apply this and I select top 10 I don't get the same values in the first 5 as when I select top 5. Same if I select top 5, then top subject is Social Sciences with 15 but if I select top 2 then Natural/Life Sciences is the top subject with 21. Is there anyway to combat this so that the top values stay the same?
Hi, that sounds really unexpected. Are there any other filters changing or being applied? It seems like the value ranks should not switch like that unless there is something else impacting it.
The other thing worth looking at is the scope/direction that is applied to the RANK Table Calculation. If you aren't super familiar with that topic, you can brush up on it in this video starting around 8:00 th-cam.com/video/oAtBy0wWN0I/w-d-xo.html&ab_channel=OneNumber-TableauExperts