The Tableau Performance Checklist: Filtering – Use Dashboard Filter Actions

Data

The Tableau Performance Checklist: Filtering – Use Dashboard Filter Actions

The Tableau Performance Checklist series is designed to help you streamline your dashboard performance and Tableau Server configuration. Each post expands upon one item listed in the master Tableau Performance Checklist.

We’ll continue on with the next item in the Filtering category:

Replace quick filters showing ‘Only Relevant Values’ and high count of quick filters with dashboard filter actions. They will cascade as your user interacts, and they perform faster.

Cascading filters? Sounds exciting!

I Got 99 Problems …

As we discussed here, here, and here in previous Tableau Performance Checklist articles, there are big potential performance problems when you use quick filters. Whether this is too many quick filters, using the Only Relevant Values option or using quick filters that have a lot of values (i.e. high-cardinality), you are going to impact the performance of your dashboard.

The gist of the problem is that the Tableau must do extra work behind the scenes to populate the values for these quick filters. This often means multiple sub-queries before Tableau can finish loading.

… and a Filter Action Ain’t One

Dashboard filter actions to the rescue! We’ve already addressed why dashboard filter actions are an optimal replacement for multiple quick filters here and how to build dashboard actions here. In short, they do not require Tableau to run additional queries and add a level of intuition to the user experience in interacting with your dashboard. This is because there are no quick filters that must be queried and populated before the view can load. The filter works on a user action, such as clicking on a mark. Not only that, but dashboard filter actions can apply across the dashboard whereas global quick filters will apply to the entire workbook, which more often than not is not desired.

Let’s now address how dashboard filter actions can work as cascading filters.

Cascading Filters

Cascading filters operate by working in a filter hierarchy. The top-level filter, when a value is selected, will reduce the options available in the other filters. For instance, let’s assume that the top-level filter is Region and we select West. With cascading filters, that selection would then change the options in the State filter to all of the western states.

Dashboard filter actions work best in tandem in guided analytical paths that allow the report consumer to drill further down from the macro into the micro. Let’s take a look at an example:

Dashboard filter actions
 
Our view above allows us to filter by clicking on a state on the USA map, to filter on a region by clicking on any of the region names, or to filter on a state by clicking on any of the marks in the plot. Using any of these filter actions will bring up the county map at the bottom:

County map

We can filter again by clicking on any of the counties for even more information:

Single county view

Mastering Best Practices

If you’re interested in becoming a Tableau Server guru, then learning these performance best practices is essential. Check back frequently as we add new posts and dive deeper into each point in the Tableau Performance Checklist.

Another great way to identify best practices is to leverage the insights offered by our Performance Analyzer, part of Workbook Tools for Tableau. It will examine all of your workbooks, worksheets, dashboards and data sources against a list of best practices to ensure that you’re using all the tips and tricks to guarantee your visualizations are moving at light speed.

As always, feel free to get in touch with us if you have any questions regarding performance or anything Tableau related! We’d be happy to help.

Contact Us!

Want More The Tableau Performance Checklist

  1. The Tableau Performance Checklist
  2. The Tableau Performance Checklist: Data – Keep Analysis Simple
  3. The Tableau Performance Checklist: Data – Bring in Only Needed Data
  4. The Tableau Performance Checklist: Data – Use ‘Describe’ to Explore
  5. The Tableau Performance Checklist: Data – Remove Unused Columns from Extracts
  6. The Tableau Performance Checklist: Data – Use One TDS File
  7. The Tableau Performance Checklist: Data – Use Extracts
  8. The Tableau Performance Checklist: Filtering – Minimize Quick Filters
  9. The Tableau Performance Checklist: Filtering – Avoid ‘Only Relevant Values’ in Quick Filters
  10. The Tableau Performance Checklist: Filtering – Avoid High-Cardinality Quick Filters
  11. The Tableau Performance Checklist: Filtering – Avoid Quick Filters That Drive Context Filters
  12. The Tableau Performance Checklist: Filtering – Keep Range Quick Filters Simple
  13. The Tableau Performance Checklist: Filtering – Use Dashboard Filter Actions
  14. The Tableau Performance Checklist: Filtering – Don’t Be Lazy with User Filters
  15. The Tableau Performance Checklist: Custom SQL – Limit in Live Connections
  16. The Tableau Performance Checklist: Custom SQL – Avoid Parameters
  17. The Tableau Performance Checklist: Custom SQL – Watch for Useless Clauses
  18. The Tableau Performance Checklist: Calculations – Use Calculated Fields Carefully
  19. The Tableau Performance Checklist: Calculations – Limit Blended Calculations
  20. The Tableau Performance Checklist: Calculations – Avoid Row-Level Calculations Involving Parameters
  21. The Tableau Performance Checklist: Rendering – Avoid High Mark Counts
  22. The Tableau Performance Checklist: Rendering – Limit Text Tables With Lots of Marks
  23. The Tableau Performance Checklist: Rendering – Minimize Image & Shape File Sizes
  24. The Tableau Performance Checklist: Rendering – Use Transparent Background PNGs
  25. The Tableau Performance Checklist: Local Computations – Server Performance
  26. The Tableau Performance Checklist: Local Computations – Table Calculations
  27. The Tableau Performance Checklist: Dashboard Layout – Limit Number of Worksheets
  28. The Tableau Performance Checklist: Dashboard Layout – Fix Dashboard Size

More About the Author

Robert Curtis

Managing Director, APAC
Building Solutions with InterWorks at Corinium’s Data Architecture Conference in Melbourne InterWorks was a proud sponsor of the Data Architecture Conference hosted by Corinium in Melbourne on 21 and 22 June 2023. Hundreds of ...
Virtual Event Recap: Deep Dive of Tableau Parameters For our June Lunch and Learn, we did a deep dive on parameters for our friends across Australia and Singapore. Tableau is the premier ...

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

×

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