Tableau: Multiple sheets swapping on action filter

A short explanation behind what its all about and how it works. Refer to the attached workbook (SheetSelection_ThroughActions.twbx):

Problem Statement: Clicking on the Region section should show its corresponding State sheet, while hiding State sheets belonging to other Regions, i.e. a single click from source sheet should show destination 1 and hide destination 2.

Issue: This functionality is not native to Tableau.

Solution Steps:
  • Create multiple dimension calculated fields with value 1, 2, 3 etc. depending on the number of source sheets. We have three source sheets (Central, East & South) and hence have three calculated fields.
  • Create various dashboard action filters from each source to each destination, and pass the appropriate dimension field in the ‘Target Fields>>Selected Fields’ section.
  • Select 'Leave the Filter' option under 'Clearing This Selection Will' section.

Why/How does this feature work?:
In passing the action from source to destination, the passed dimension fields (Filter1 & Filter 2) that don’t have the same value will go Null/Blank, while those that match (Filter1 & Filter1) get displayed. This forces dashboard actions to behave in a binary way helping hide & show two different sheets with a single click.

Caution: The number of dashboard actions increases by a factor of n^2 as number of source/destination sheets increase (assuming each source has unique destination sheet).

Comments

Post a Comment

Popular posts from this blog

Learning and Staying Fresh on Alteryx

Image
Alteryx often means different things to different people, depending on who they are and their professional and educational backgrounds. But a common emotion amongst those who persist with it is that of joy -that feeling of thrill and fulfillment when they solve a problem using Alteryx.   Hardcore data scientists as well as newcomers to the field of analytics/data science find Alteryx a joy to use simply because they get to focus their thought and emotion on the problem at hand, as opposed to writing code.   But is the journey of learning and solving problems with the tool linear for everyone? It wasn’t for me. I came into Alteryx from a non-technology background and was quite reluctant to give it a try. My initial days with the tool were daunting and I had moments where I conveniently avoided using it. Looking back, I was that person who thought in terms of Excel and would try and replicate it in Alteryx. But over time I found ways and mechanisms to try and use this tool ...
Read more