I have a Dashboard which has multiple tabs, 1st tab contains list of reports , so when a user clicks on certain row which contains name of the report , it should navigate to that particular tab (report) in the Dashboard
Hi @bhumika18s,
Sounds like you want to leverage custom actions as described here in our documentation. As “Navigation action” only allows to jump to a specific pre-defined static sheet, you could use the “URL action” if you make the sheet-id of your final dashboard available in a column of your dataset (and e.g. use it as a hidden column in the table) and then construct the QuickSight URL (format https://<REGION>.quicksight.aws.amazon.com/sn/account/<ACCOUNT_NAME>/dashboards/<DASHBOARD_ID>/sheets/<SHEET_ID>) accordingly using that field.
Did this answer your question? If so, please help the community out by marking this answer as “Solution”!
So my first sheet (tab) in the Dashboard contains multiple rows, multiple rows meaning different names of report so when user clicks on particular report name or cell let’s say then it should navigate to the particular report /particular sheet in the Dashboard. let’s say first sheet have 3 rows- 1st row contains text Finance Data, so when user click on it , this shall navigate to Finance Data report in the Dashboard. When user clicks on HR data row, it shall navigate to HR Data report in the Dashboard, and so on and so forth
Thanks for sharing the additional context. This is matching with how I had understood and responded to your first post. Did you explore my suggestion or have any specific questions about it?
not really, please elaborate Thomas
Hi @bhumika18s,
I’ve created a quick and simplistic example in the QuickSight Arena that you can find and access here: Dynamic Sheet Linking
Important is that you’ll have to update the dashboard Id/sheet Ids based on the Ids of your published dashboard and update the region in the URL (in my case us-east-1) to the region in which your dashboard is being published.
The dataset and action defined on the table in the overview sheet is defined as follows:
I hope this gives you all information you need to reconstruct it at your end.
PS: Given the embedding nature of the QuickSight Arean, it could be that the example that I’ve constructed doesn’t work for you when you click on the report names, but you could create a copy of the analysis to analyze how I created the dashboard and action. Reconstructing it in your own account should work based on the instructions given above.
Did this answer your question? If so, please help the community out by marking this answer as “Solution”!