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."

3 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.