Any idea if there’s any workaround for an Insight to navigate to another sheet ?
Depending on how you want your insight formatted you can look to make it a table and navigate through that.
You can make a static calculated field like this.
Then reference that calculated field in a table.
Then you can pretty up the table by getting rid of extraneous stuff.
Finally, you can change the settings to be how you want it.
That is how we have gotten around it, but the only real use case is for titles. At least what we have found.