Saving Time in Tableau 10 with Cross Database Filters

For a long time now when you wanted to filter multiple data sources you'd have to use a parameter in Tableau. This worked well but had is not without its own limitations. Namely, the limited parameter interface choices and the need to use a calculation to apply the filter.

Now in Tableau 10 you can achieve the same capability with an even better user experience using Cross Database Filters. I'm super excited about this as the maintenance issues with using parameters and calculated fields has plagued me more than once.

Video Tutorial

How To

  1. Build two or more views using different data sources
  2. In one of the data sources, add a filter
  3. Right click on the filter and choose “Apply to all related data sources”
  4. (optional) Adjust which data sources get the filter using Data > Edit Relationships

Finished Example

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.