1 of 1 people found this helpful
One way to do it is to create a dashboard and house your text table there, publish this, instead of the worksheet.Then in your original dashboard create filter actions straight to the worksheet containing your text. This filters the sheet in the background while you're making selections on the original dashboard, but because the sheet itself is not published you remain on the dashboard. Then you set your 'View Details' action to filter to the Detail dashboard, this will navigate to the pre-filtered table.
Hope I'm clear, and that it works!
Thanks for the response.
However we have a Desktop/Reader environment at present, so this workaround for publishing to Server doesn't work for us. I tried adding the text table to its own dashboard and filtering the sheet but this still then diverts immediately to the sheet. I even tried hiding the sheet but interestingly this then diverted to the dashboard instead.
Any other ideas...?
Ah, okay. Unfortunately I don't have any experience with Reader, so out of ideas for the moment. Good luck!
This issue still has me stumped. Anyone have any bright ideas please? Thanks, R
As per my understanding, when you are clicking on Dec in first sheet, it will make respective changes in the second sheet. Now, when you want to see the detailed view of the value that you are getting in the second sheet based on the selection in the first sheet.
What I did: Apply action from first sheet to the second sheet and then go inside the second sheet where in you can see the action that has been applied from the first sheet. Right click on that action-> apply to worksheets-> all using this data source or apply on a selected worksheet(as per your requirement)
PFA the Tableau file with the changes. I hope this will solve your issue.
ActionFilterIssue.twbx.zip 1.1 MB
This article here has a really good solution through including but hiding the target sheet on the first dashboard. Your filtering sheets will filter the hidden one, and the filters will persist when you click through (because it's the same sheet); you just need to make sure to remove the filter from your action that initiates the click through otherwise it will replace the subsequent filters.
Thanks to you, I was able to solve my problem on multiple action filters. I am facing another problem though. Since one of my sheets on the dashboard is just a count of a single selection on a filter, I am unable to deselect it and get all the values back on the details dashboard.
Kindly help with this.