This post is going to build on the foundations from part 1 and part 2 of the series. If you have not read part 1 and 2, I recommend you do so, by clicking here .
Let’s get into it.
First you will need to have a dashboard with 4 charts, any 4 charts will suffice (I’ve gone with superstore data), and I am going to layout the sheets into quadrants (Top Left, Top Right, Bottom Left and Bottom Right). Then, I am going to put each sheet into its own container. In addition, the Top 2 and Bottom 2 sheets/containers need to go into their own containers.
The Logic
The Logic behind the 4 sheet swapping is to use String parameters to control each container. I will start by creating a String Parameter, and I will call it ‘Region Swapping’. Then, I will label the parameter values by the Regions; Central, East, South and West. I am also going to include an ‘All’ option to show all charts.
The Calculated Fields
Next I will write the Calculated Fields, one for each of my 4 charts.
The reason I have included the ‘All’ for each of the expressions is because I want all Charts to show when the ‘All’ parameter is selected.
The Designation
Once I have finished with the Calc fields, I will assign these Calc fields to a chart (a container in my case) on the dashboard each. Then, I will assign the Calc Fields to their respective containers, and I will do this in these steps:
- First, show the Parameter and set it to ‘All’. This ensures that the containers don’t disappear as I set the Dynamic Zoning Visibility.
- Next, assign the 4 containers with their matching Calc Fields.
The Final Product
Finally, I need to test the dashboard to make sure it is behaving as I want.
CONGRATULATIONS, You now have a fully functional 4 quadrant sheet swapping/zooming dashboard without the annoying white space place holder that we had previous to Tableau 2022.3 with our hacks.
I hope you have found the post useful, and I will see you next time.