Today’s blog is all about how to link an Overview dashboard to Detailed dashboards (these dashboards reside in different workbooks).
The simple fact that we are working with dashboards on different workbooks (.twbs / .twbxs) means that we cannot rely on the standard ‘Filter’ action, so we’ll be exploring URL actions as well as a common warning message that may appear.
Note: This article assumes basic understanding of Tableau Desktop Dashboard actions.
1. Background: Real Life Business Requirement
For the past few months I’ve been based out at an iconic Australian brand, building dashboards for different subject areas – that being Finance, Safety, Sustainability and Strategic Workforce Planning. The consumers of those dashboards are members of the Group Leadership Team who want to see a quick snapshot of performance in all 4 areas before delving into the detail, i.e. analyse an Overview page by interacting with filters, then clicking on an icon in order to navigate to a subject area-specific dashboard of choice. The desired user experience is such that they want to pass through whatever filter has been applied to the Overview page, through to the Detailed dashboards just so they won’t have to reapply each of the filters (“click economy”). It also ensures that there will be less confusion involved in wondering why values didn’t successfully pass through.
Join me in this video as I’ll be walking through step by step how this navigation experience is achieved. In addition, I’ve also thrown in some additional features into the mix:
- How to dynamically pass through filter values through URL actions
- What’s a common warning message and what’s an easy fix
- How to force URL actions to open in the same window on Tableau Server