Tableau - Top and Bottom
Tableau - Top and Bottom N using Rank function
Is it still applicable if you have a filter?
very nice ...thanks
This tip is inspired by
This tip is inspired by Craig Bloodworth, who demonstrated it at a recent Zen Master workshop he and I hosted for The Information Lab. Join our meetup group at https://www.meetup.com/Lets-talk-Data/.
Download the workbook via my blog here - https://www.vizwiz.com/2018/10/rank-filter.html
Great Video Andy, Thanks!
The CASE Function does not work on created calculated measures such as Margin % for changing the parameter measure towards the end of your video. What function would you use for these?
I have a question, what if we need the filter for another chart on another sheet, can we apply filter to selected sheet like regular filter?
I watched the whole ad so you get maximum ad money, and subscribed. Thanks for this video
Thanks Andy this is brilliant and so timely as i was working on the very same issue this week but having to do it all via excel, this has saved me hours of work. thankyou
Andy this is terrific and easy to follow. My question however is this: can the filter you created using the window_min function be connected some way to the primary dimension you are filtering in order to filter on other sheets?
One of the drawback of
One of the drawback of filtering a dimension is that you will lose the rank of a dimension relative to others. This happens because of Tableau's order of operations which dictate that a dimension filter takes effect before a table calculation (rank in this case).
This video shows you how to use Set Actions to filter a dimension while also maintaining the rank.
Download the workbook here - https://www.vizwiz.com/2020/04/set-action-rank.html
Hi Andy,if two have same rank, then we use the Rank_Dense function in place of Rank function.is it correct.
What if two have the same rank?
Thank you, bit complex but done.
Hi Andy, I need to be able to use this doing a filter and be able to apply it to multiple sheets.
Example -> The user needs to have a filter of Sub-Category, I need a sheet which only shows the rank of the subcategory. I also need to show a detailed analysis of the selected sub-category in a different sheet. I have seen examples where we use Lookup or Window_max to retain rank but I am not able to apply them across multiple sheets.
Can you please help.
Great presentation. Thanks a lot from Shanghai.