Friday, March 28, 2014

Inline Filtering using Tableau "Size" Calcs

This trick was too good not to pass up - Andrew Hill, Sales Consultant extraordinaire from Tableau, came up with this recently. Great stuff, Andrew!

The way it works is so simple and elegant. We use Tableau's built-in Size() function to filter certain sheets on a dashboard. We then use the built-in "keep only" feature on the tooltip. As the Size() changes, the sheets filter or disappear. Size() simply means "number of answers that the database gave us."

4 comments:

Russian Sphinx said...

That's perfect, thank you!

Shawn Wallwork said...

You better turn off the Command Buttons on that map, Keep Only produces a blank.

Otherwise nice trick!

--Shawn

ildata said...

i tried replicating inline filtering. For some reason it is not working for me. Looks like I am missing something. Can someone please provide the steps.

Apporva Jain said...

Privileged to read this informative blog on Tableau. Commendable efforts to put on research the data. Please enlighten us with regular updates on Tableau. Friends if you're keen to know more about Tableau you can watch this amazing AI tutorial on the same.
https://www.youtube.com/watch?v=KvK5-_JKQjw