Can I link another dashboard to the data grid in the current dashboard?
You can add a formula to a worksheet that contains a URL, that links to a dashboard, then create a table or a pivot.
And in the URL, you can have URL parameters that will drive dashboard filters, explained here: https://help.sigmacomputing.com/hc/en-us/articles/360045978434-Dashboard-Controls-in-the-URL
I am almost there with this suggestion. The latest problem i am trying to overcome is URIencoding my parameter value in my formula field.
For instance my formula is Concat(“https://sigma/dashboard?parm=”, [Parm Name])
The problem is the value stored in Parm Name is “Test Test,X…” I need this value URIencoded, but I don’t see any function that does this.
Do I have to supply my own URIencodeing?
Hello, Eric,
We don’t have a URL/ URI Encode function, but you should be able to hand-encode this by replacing spaces with a “%20” (sometimes a “+” also works) , comma with a “%2C” etc.
Another option is to add a javascript UDF to Snowflake, here is an example of something somewhat similar (they are decoding a URL - scroll to the bottom of the page).
I will add a feature request for this.
Thanks