-
1. Re: Filter another table using data blend. Global filters don't affect other table.
Alex Kerin Jan 7, 2013 12:25 PM (in response to Chris Rains)1 of 1 people found this helpfulYou can use parameters: Here's some good info: http://vizwiz.blogspot.com/2012/06/create-global-filter-in-tableau-across.html
-
2. Re: Filter another table using data blend. Global filters don't affect other table.
Chris Rains Jan 7, 2013 12:27 PM (in response to Alex Kerin)Hi Alex, thanks. However, I want to be able to select *multiple* options within one filter, without selecting "All". Any other ideas are appreciated!
-
3. Re: Filter another table using data blend. Global filters don't affect other table.
Alex Kerin Jan 7, 2013 12:33 PM (in response to Chris Rains)More tricky - I wonder if you would have to resort to custom SQL to join one table with a summary of the second? Maybe there's a way round this with a join instead of a blend and then some magic to fix multiple rows? Difficult to say without an example of your data.
-
4. Re: Filter another table using data blend. Global filters don't affect other table.
Joe Mako Jan 7, 2013 3:54 PM (in response to Chris Rains)Chris,
Is this your comment at http://vizwiz.blogspot.com/2012/06/create-global-filter-in-tableau-across.html?showComment=1357591191698#c3600400439813736514 ?
Andy alerted it to me, and yes, what you are looking for can be done in a few ways in Tableau.
I normally do it with a data blend, and two worksheets on a dashboard with an action. If you can provide a sample packaged workbook that represents your situation, an example can be created for you.
-
5. Re: Filter another table using data blend. Global filters don't affect other table.
Chris Rains Jan 7, 2013 4:46 PM (in response to Joe Mako)Yes, that is my comment there. Thanks a lot, Joe et al. I'll try this!
-
6. Re: Filter another table using data blend. Global filters don't affect other table.
Joe Mako Jan 7, 2013 4:59 PM (in response to Chris Rains)I just read my comment, and I explained that really poorly. Sorry :(
-
7. Re: Filter another table using data blend. Global filters don't affect other table.
Chris Rains Jan 7, 2013 5:01 PM (in response to Joe Mako)On the contrary. It helped!
-
8. Re: Filter another table using data blend. Global filters don't affect other table.
Ting Mao Nov 24, 2014 5:08 AM (in response to Chris Rains)Hi Chris, have you found a solution yet. I am facing the same issue. I need one single filter in the dashboard that filters data in two sheet.
-
9. Re: Filter another table using data blend. Global filters don't affect other table.
Chelsey MacNeill Jan 8, 2015 3:00 PM (in response to Chris Rains)The selected "correct" approach doesn't work for 8.2
-
10. Re: Filter another table using data blend. Global filters don't affect other table.
Kuldip Singh Mar 3, 2015 11:28 AM (in response to Chelsey MacNeill)Hi Chelsey
Did you find any solution yet for the above issue ?
I have a similar problem, trying to describe below
- Sheet-1 uses Data-Source-1
- Sheet-2 uses Data-Source-1
- There are a few common filter values between Sheet-1 and Sheet-2
- Data-Source-1 and Data-Source-2 are at different levels. Based on some common attributes of Data-Source-1 i.e. Sheet-1, i can find some static set up in Data-Source-2
Would be great if i can get some help with this. Let me know if more info is needed as above may not be fully clear
Thanks,
-
11. Re: Filter another table using data blend. Global filters don't affect other table.
Norman Dilthey Jun 23, 2015 3:38 AM (in response to Chris Rains)Hi Chris, or Joe,
did you ever find a solution to the issue? I would be very interested to see how you filtered across data sources using normal dimensions (which are shared across data sources) as filters.
Simply blending the data together does not seem to work 100% when I tested it.
Thanks!
Norman