Optimizing Portal Filters: Dynamic Filter Values

Data

Optimizing Portal Filters: Dynamic Filter Values

This blog series walks through the versatility of filters in Portals for Tableau. It examines numerous filtering options to demonstrate how to optimize your dashboard to its fullest potential.

Now that we have Sticky Filters set up, this post will continue our journey toward creating a fully optimized portal filter setup by enabling dynamic filter values:

Setting up Dynamic Filter Values

Maybe instead of filtering on Region, your use case involves filtering on State, like the dashboards above on my portal. The first thing you’ll likely think is “Yikes! I have so many filter options to input!” Hold on there, grasshopper. There’s an easier way, and I’m here to show you the light. Why input 51 (because D.C.) options when you can automatically grab those values from the dashboard!? Let’s set up those dynamic filter values.

Go to the portal backend > Tableau > Filters section, and hit that blue New Filter button. Fill out the fields similarly to how we set them up in the Sticky Filters step, except this one I’ll make a Multi-Select:

I’ll make this filter sticky, of course, then flip on Get filter options from data. This is going to make our filters dynamically grab the filter values from the dashboard. The process is sending a request to Tableau for the data and building the options from the response, which can be a slow process depending on how large your data is. Turning on Cache filter options from data will alleviate some of that waiting pain:

With this filter being a multi-select, I want to add an Apply button to our filter slideout. Without it, the dashboard will reload on each filter option selection, but with it, we can make all our selections before applying. You might not need it for your use case, but it certainly makes mine more enjoyable. To do this, I’ll click on the Tableau Server Settings link in the bottom-left corner, flip on the Filters and Parameters Apply Button and save my settings:

We’re all set up, so let’s go witness this magical feature:

You can see on the right in the filters slideout that all my states are automatically populated as filter options. Neat! And with Sticky Filters on, I can choose a couple values, hit the Apply button and navigate to my other dashboard to see them applied:

Since we’re having to do another request from Tableau Server for all the data to populate filter values, one thing to consider here is the extra load time. It can get dicey on load times if you have a large dataset, which hurts the user experience. That brings us to the next blog in this series—creating a “hidden” filter sheet to grab values from—so check back in soon for the next installment!

More About the Author

Justin Lyons

Analytics Consultant
Optimizing Portal Filters: Setting up the “Hidden” Filter Sheet We’re continuing on with our blog series about how to fully unlock all of the filtering power available in your Portals for Tableau. ...
Optimizing Portal Filters: Dynamic Filter Values Now that we have Sticky Filters set up, this post will continue our journey toward creating a fully optimized portal filter setup by ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072