There has been a conversation floating around on how to successfully navigate around different sheets of a workbook. On the face of it there doesn’t appear to be an obvious way of doing this in Tableau (perhaps Tableau 8.0 will address this!!).
However it is possible and below is an example of a menu system within a Tableau workbook which uses actions to navigate from sheet to sheet.
It is definitely a useful trick to know about but is a little bit fiddly to set up.
It is achieved by creating a series of sheets which will be used for navigation purposes. One will need to be created for each target dashboard plus an extra one for the return to main menu if you want. The example above has 4 dashboards so requires 5 separate sheets to create the navigation. Each sheet will then have its own filter action created from the worksheet menu to target the required dash. This can either be done as a select or menu link (both are used above).
The text itself is created through a simple calculated field with the string written inside and dropped onto the label shelf.
Create a menu dashboard to drop all the link worksheets onto, format to taste and you’re ready to go.
The example is very simple but there is no reason not to include some sort of metric onto each of the links (they are worksheets after all) then rather than simply a menu list it becomes a KPI overview with links to more detail if some target is reached and flagged.