Last Modified Date: 26 Jan 2022
Environment
- Tableau Desktop
Resolution
The request is to add a filter function under "Edit Calculation" or "Create Join Calculation" for each table in Join or Relationship in Data Source panel. By filtering the tables before join/relationship can increase performance. See screenshot below.The possible workaround is to create corresponding Custom SQL for each table with Where clause to apply some filters before making Join or Relationship.
Cause
The ability to filter values on tables in Join or Relationship in Data Source panel is currently not built into Tableau products. At the moment the filter is applied after the joins.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials