I want to click on a gauge on a dashboard and activate another sheet. On the activated sheet there is a container containing multiple charts. I want the click from the dashboard to display a specific chart in the container when the sheet is activated, all automatically by that single click. I would appreciate your help if you have been able to achieve that or know how I can. I have tried the various options under Action but have not found a solution yet.
