Hi All,
Lets consider the super store data...
I have a cross-tab as main page with product, sub category, sales and region with respective filters and one details button...
Also, I have multiple dashboards, all are kind of different from one another (in terms of viz and data),
The request is
If the user selects Furniture in the product filter and clicks the details button in the main page
then it should navigate to say for ex dashboard1
Similarly if office supplies and click the "SAME DETAILS BUTTON" in the main page
now it should go to dashboard 2 and so on.
there are around 10+categories and each should navigate to respective dashboards by clicking "ONE COMMON DETAILS BUTTON"
Is there is any way in achieving this?
Thanks in Advance,
Sree
This is a bit hacky, but you could use a sheet swapping technique to accomplish this (see https://www.thedataschool.co.uk/hashu-shenkar/tableau-tip-switch-between-views-dynamically-on-a-dashboard/). Essentially, you would create multiple sheets to act as your details button. They'd all look the same, but you'd need separate ones for each target dashboard. It'd look something like this:
Note: you'd need to filter each of these by a copy of the Category dimension (we'll get to that in a moment). You'll also need to make sure there is an axis for sheet swapping to work, thus the use of 0 on the rows shelf and columns shelves.
Then you'd put these into a container on your main dashboard.
Then go back and add your Category filter to both sheets (apply them across both so it's a shared filter).
When you go back to the main page, you'll only see one button.
Using that sheet, turn on the Category filter.
As you change options, you'll see that only one button is ever visible. You will see a bit of movement, but this is due to sheet padding, so remove all padding from both sheets. Now it will just look like a single button, even though it's multiple.
Finally, create dashboard actions to go to the separate dashboards.
See the attached example.
