Hello Nay Soe,
How about using the Hyperlink action functionality that Tableau has built in? You are able to fire the action from both a viz or a dashboard, and you also have the ability to include data from fields in your database into the hyperlink. This has one drawback as far as I am able to see: the target workbook always opens in a new window, hence you may end up with a ton of open instances of the same workbook.
Hope this helps a little bit!
Untitled-1.jpg 102.7 KB
Thanks for answering. Yes I have done that. The disadvantages of it are:
1) As you have mentioned, it opens in a new tab. So doesn't really give you the feeling of a single piece with different screens.
2) The URLs to the workbooks must remain fixed. Any change of name will result in URL change, and the links have to be manually updated.
I'm wondering if there is any facility in the system that will take care of these.
Unfortunately what you say is completly true, and the issues are beyond my level of competency. The only additional thing I could think of is to maintain the hyperlinks in the database and use the respective field in the action path. I am not sure is this would be useful in your case, but maybe someone else could advise better.
Sorry I was not ableto help, and wish you good luck!