Portals for Tableau New Feature Spotlight: Dynamic Filter Updates


Portals for Tableau New Feature Spotlight: Dynamic Filter Updates

The Portals for Tableau New Features series is designed to keep users up to date with all the latest features being added to InterWorks' embedded analytics solution, Portals for Tableau.

Please note that Portals for Tableau are now officially known as Curator by InterWorks. You can learn more at the official Curator website.

Ever wish your Portals for Tableau filters could be dynamic? Or even your portal parameters? You’re in luck! You may have seen Data Driven Filters (also works for parameters) on your portal – it even made our recap of last year’s best features. Now we’re back with a pretty big improvement, for both usability and performance.

Specify Filter Sheet

You will now see a new toggle in the backend under Content > Dashboards > Edit-dashboard > Misc tab: Specify Filter Sheet.

Portals for Tableau: Misc Interaction Options

When grabbing the dynamic filter data, the portal looks at the first worksheet loaded. However, you may have multiple data sources comprising your dashboard or a slow-loading worksheet you want to avoid. In these cases, you’ll want to tell the portal which worksheet to use to populate your dynamic filters.

After you turn on Specify Filter Sheet, you’ll see two new fields immediately beneath that toggle: Filter Worksheet and Use Summary Data.

Portals for Tableau: Use Summary Data

Now you can populate Filter Worksheet with the exact name of the worksheet you want the portal to pull the dynamic values from. This will ensure you’re getting the right data from the right data source.

Use Summary Data

While the above method can now fully ensure you’re getting the right data, the default method of retrieving the Underlying Data grabs all of the columns from the Underlying Data on your worksheet. This can get pretty sluggish if you only need three or four columns to populate your filters – especially if you have a very wide dataset. Nobody likes waiting for things they don’t need.

Wait no more! You can switch on the Use Summary Data toggle to use a faster API call that only grabs the Summary Data from your worksheet rather than all the Underlying Data. Not sure whether the data you need is in the Summary Data or Underlying Data is on your worksheet? You can check:

  1. Navigate to the worksheet you plan to use
  2. Select ALL the data on the page
  3. Right-click > View Data

Portals for Tableau: View Data

For this example, I want to populate my Region filter dynamically. Since all of my values are here on my Summary Data pane, I now know I can turn on Use Summary Data.

If your data doesn’t show up here, you have two options:

  1. Add the level of granularity you need to the Detail shelf on your worksheet
  2. Create a separate dedicated “Filter” worksheet – this would simply be a crosstab of all the data you need for your filters in crosstab format


There you have it. A dynamic driven filter with more control for improved data-fidelity and performance!  Happy filtering.

More About the Author

Mark Bingham

Curator Experience Lead
The Key to Embedded Analytics: Portals for Tableau “Where we’re going, we don’t need roads” – Doc Brown, 1985/2015 We’ve all got hopes about the future of technology, and ...
How to Calculate XIRR in Tableau with Python Me: “I’ll take Python for $200, Trebek.” Trebek: “The time it takes for you to create a hand-coded XIRR calculation in Python for use ...

See more from this author →

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


Love our blog? You should see our emails. Sign up for our newsletter!