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:

  1. Russian SphinxApril 3, 2014 at 12:21 PM

    That's perfect, thank you!

    ReplyDelete
  2. Shawn WallworkMay 27, 2014 at 5:48 AM

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

    Otherwise nice trick!

    --Shawn

    ReplyDelete
  3. ildataJuly 22, 2014 at 9:05 PM

    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.

    ReplyDelete