With Tableau if I filter data everything else (the complement data set) gets out of the scope and I can't calculate on them to compare. That is, say I have Selected 'East' Region and I want to select separately 'South' Region to compare. But once I select 'East' I don't get to select 'South' since the data is already filtered out to 'East' (Here note, I could allow multi-selection to achieve the same, but it's a constraint - we have to allow separate selection, neither we could go with Parameter). I heard this data filter issue could be handled with creating an additional data connection. Could you please help me on the same - how to create another connection to handle the situation?
Hello Amit Ray,
I belive you are talking about a strategy such as the one outlined by Jonathan Drummey here: Creating a Dynamic “Parameter” with a Tableau Data Blend | Drawing with Numbers
I hope that works for you and if not, please let us know.