In version 2019.2, Tableau introduced show/hide containers. These enabled the dashboard consumer to show or hide a container – along with any objects within it such as charts and filters – by clicking a button.
With the recent release of 2022.3, this concept has been taken to the next level with Dynamic Zone Visibility, which I’m thinking of as “data-driven show/hide containers” or more accurately “data-driven object visibility” as it’s not just containers but any object (or ‘zone’) – a chart, a filter, a text object, a web object, a download button or a container that holds any combination of these.
The fundamental difference here is that the visibility of the object is not manually triggered by the user (by pressing a button) but rather by the values contained in your data or by a parameter value.
Of course you could also combine these two features.
- A button for the user to manually show a container
- The contents of that container (i,e. the objects within it) determined by the value of a calculated field or parameter
For example, the user could manually click a button to show filters. The filters in the container could be determined by who is logged in – maybe Finance group members see an additional ‘Cost Centre’ filter.
Examples use cases for Dynamic Zone Visibility
The possibilities are really open ended with this feature but below are a few examples:
- Show zones or customise dashboards based on who is logged in. For example, only allow a specific person or members of the Finance Group to see certain charts or filters.
- Customise the dashboard based on how many Orders were placed last month, for example, if quotas weren’t met, show a chart or map where that was the case. If all quotas were met then don’t show the chart.
- Show zones based on which was the top selling product. For example showing a specific chart types or combination of charts that best analyses the sales for that product or category of products
- Zoom into a chart to show more detail and options. See this example from Tableau Visionary, Sam Parsons.
- Show zones based on the day of the week. For example, on Mondays, show a chart with a summary of last week’s sales. On Fridays, show a container that holds a text object with a reminder message to fill out the weekly feedback form or survey along with a web object showing a Google form to submit information on sales made this week or survey (…or many other possibilities).
- Enable the ability of dashboard users to trigger an external workflow based on boolean conditions, for example, users are members of certain Tableau groups or they have selected relevant marks in the view.
- Show a different combination of charts based on selections made in the view and/or the analysis being undertaken at the time.
The video below walks through some examples of customising dashboards based on user selections (#7 above). More detailed tutorial videos will be available soon.
What calculations or parameters can be used
- Selecting the object on the dashboard
- Checking the Control visibility using value checkbox in the dashboard pane
- Selecting a calculation or parameter from the drop down menu
Only calculations or parameters meeting specific criteria can be used. According to Tableau’s help page, this is as follows:
To be used for Dynamic Zone Visibility, a field or parameter must be:
- Single value.
- Independent of the viz, meaning the field returns a constant value independent of the structure of the viz, such as a fixed level of detail (LOD) calculation.
Examples of Invalid Calculations
Examples of Valid Calculations
A few things to watch out for
- As mentioned above you may need to wrap your calculation in (another) Fixed LOD
- Don’t ‘Hide all unused fields’ – or at least not the fields you’re using for dynamic zones as they then won’t appear in the drop down list of fields to use and may make existing dynamic zones where those fields are use invalid
- If you’re working with overlapping dynamic zone containers with multiple objects within them, you may have issues moving the objects around within (some of) those containers. Shifting the container you’re editing out to the left or right temporarily (so it’s not occupying the same screen space) should help.
I’m still exploring and learning more about this new features but will create some YouTube tutorials soon that step through how to create some of the above scenarios.
UPDATE: an in-depth tutorial video is now available here: https://youtu.be/aqunvBEpnJY
It’s great to see Tableau dedicating time and resources to developing these types of very practical features that will enable analysts to create improved and more customised user experiences for their dashboard consumers.
Latest YouTube video
This video tutorial steps through how to create a dot plot in Tableau.