Tableau: From Good to Great; Maintain Table Calcs while Filtering
In this new series of blog posts I’ll be reviewing and sharing some of the best tips you should be learning if you’re looking to take your knowledge of Tableau to the next level.
First on my list of tips I want to share was this one for filtering table calculations in Tableau and still maintaining their values. For example when you calculate a Percent of Total and wish to filter out one of the dimensions you will find normal filtering leaves all your values at 100%.
The trick is to use a Table Calculation to do the filtering, create a new field; Lookup(ATTR([Field]),0). This acts after the data has been queried (because it’s a table calculation) and therefore does not filter the underlying data, thus maintaining any calculations which use the rows you are filtering.
I’ve put together this short 10 minute video so that you can see this useful tip in action: