Top Tip: How To Maintain Table Calcs While Filtering

Don't forget to click Subscribe if you want more weekly data-related updates!
Ever used a Rank Table Calc only to find your rankings get all messed up if you filter your data? If that's you then watch this video! Data Schooler Otto Richardson walks you through how to keep a Table Calc in place while ''hiding" the other values.
📌Timestamp
0:00 Intro
00:12 Example of when you'd need dynamic hiding
01:17 Problems with filtering by Rank
02:05 Filtering using hiding
02:40 Dynamic hiding
03:02 Make dynamic hiding Set
🔗Links
- Practice this technique in this Workout Wednesday: workout-wednesday.com/2023w41...
- Learn more about Sets: help.tableau.com/current/pro/...
- Connect with Otto on LinkedIn: / ottorichardson
- Find out more about Otto on The Data School site: www.thedataschool.co.uk/blog/...
🎧Want more 5 minute tutorials? Check out our other 'How to' in 5 minutes playlists
▶️How to Add Formatting in Tableau • How to Add Formatting ...
▶️How to with Calculations in Tableau • How to with Calculatio...
▶️How to Build Chart Types in Tableau • How to Build Chart Typ...
▶️How to Data Questions in Tableau • How to Data Questions ...
▶️How to Join and Manipulate Data in Tableau • How to Join and Manipu...
▶️How to in Tableau Prep • How to in Tableau Prep
▶️How to in Alteryx • How to in Alteryx

[@mahmoudnaser2521]

very great video , we can solve this problem also by using
lookup(attr(sub-category),0) and put it in the filter shelf and will give us the same result , because order of operation dimension execute before table calc , so we tring to make a filter and dimension both in tableau calc level

[@theinformationlab]

Great tip! That's another way to solve this problem. Thank you so much for sharing (and isn't it cool that there's always multiple ways to do things in Tableau? 😊)

[@mahmoudnaser2521]

Yeah, sure Multiple ways are always good in Tableau 😊@@theinformationlab

[@steveep1983]

Very nice, thanks for sharing. Only comment is the audio on these isn't great, sounds like a zoom meeting. Why don't you record the audio separately, would add a lot of value to the video

[@theinformationlab]

Thanks for the tip!