Yeah this can be possible but double click is not possible If you double click then that particular value gets filtered in your viz. In dashboard action you have "run on single select" option. For hover action you can do something like this
Selected field will be product in your case.
Give a try and let me know If this help.
"Run on Single Select Only" is a confusing term ...
Thats why I have posted this idea to ask for accurate functionality on this topic
Single click navigation is possible via dashboard action.
You need to prepare your data accordingly, see attachment for details
One Click Navigation.twbx 506.7 KB
naveen.chebrolu I have tried to explore this option for one of my requirement but had no luck. Single click and double click functionality is not possible at one time.
For somewhat similar type of functionality, you can use MENU option in action filter which gives the name of the Action Filter you want to apply or navigate to the required dashboard (as mentioned in action filter) when you click on the field in sheet. This works seamlessly and allows you to move to different locations within worksheet through clicking on a single field, based on the user requirement. Hope this helps.