I don't think its because of version incompatibility issue. You've blended two data sources. In blending filter works only from primary data source. I would suggest,
If you're using excel or csv as data source then use custom SQL to join both the sources. If you're connected with any db like oracle then create a view of your sources using join then connect to tableau. Let me know If you've any query.
Thank you for your answer. I will try your method. But, both our workbooks are using blending data sources. Seems like only my analysis can drag the Boolean calculation into filter, but hers, can't. Any aggregated calculation also can't be drag into the filter though.
I will let you know whether it work or not for problem.
1 of 1 people found this helpful
It's not a blending issue, it's a versioning issue. v9.2 added the ability to have discrete regular aggregates on the Filters Shelf, see Feature Geek: How to Have Sets with Your Secondary (9.2 Style) via Aggregated Booleans | Drawing with Numbers for more details.
Prior to 9.2 we'd make sure that a) the blend was at a fine enough grain to work so the required aggregation wouldn't miss anything and then b) instead of a boolean calculation use something like IF <true evaluation> THEN 1 ELSE 0 END and use a continuous filter for at least 1.
Hi Jonathan Drummey,
Thank you for your answer. So, it is advisable to upgrade to the latest Tableau version, right? Or is there any other way besides than upgrading the version? We have also tried IF ELSE syntax in v9.1. Seems it doesn't work too.
Thank you Jonathan
You have to make the IF/ELSE calc continuous in order to drop it on the Filters Shelf.
Sent from my iPhone