Using dashboard filter in click behaviour custom destination

[jpoel]

Hi All,

I am trying to pass a dashboard filter into a click behaviour custom destination url.

As a test, I have added an "example" text filter to my dashboard. I have then added a graph with click behaviour to navigate to https://www.google.com?test={{example}}

After entering an example value, the chart links to https://www.google.com?test= i.e. doesn't include the example value.

Clicking the "values you can reference" hint shows the "example" filter that I'm trying to include.

I am including the dashboard as a static embedded dashboard. If I view it via SSO, it works. Is passing filters into the url on an embedded dashboard not supported?

[vaibhav-vqb]

Hi Did you get any solution to this, as i am also facing the same issue ?

[Luiggi]

Please upgrade to the latest version

[vaibhav-vqb]

Hi @Luiggi , Thanks for the reply, following is the issue in detail.

I configured the custom destination and added the filter variable in URL.

In static embedding i have configured the parameter as editable, so that i can set from app and if not set user will set from embedded filter UI.

When i generate the URL without any params I get the filter and when i set the value there and click on the configured click behaviour i get the variable populated in custom URL destination

But, when i set the parameter from the app and i do not get the filter which is expected but now when i click on the custom URL destination, the category filter is not populated.

As i could only add 5 images so couldnt show the redirection image but the custom URL opens as "http://localhost:3301" expected was "http://localhost:3301/Gadget"

Can you please check into this and let me know how can i resolve this issue, or is this a bug ?

[Luiggi]

have you moved to 51.4?

[vaibhav-vqb]

Yes using the latest version.

[Luiggi]

Sorry, in the last screenshot I don't see any filter in that dashboard... that's why it's not populating

[vaibhav-vqb]

Yes that is because, I have set the filter values in the signed embedded URL. The filter is already set from the api using this code.

import jwt
import time

METABASE_SITE_URL = "http://localhost:3000"
METABASE_SECRET_KEY = "<redacted>"

payload = {
  "resource": {"dashboard": 1},
  "params": {
      "category": "Gadget"
  },
  "exp": round(time.time()) + (60 * 3600) # 10 minute expiration
}
token = jwt.encode(payload, METABASE_SECRET_KEY, algorithm="HS256")

iframeUrl = METABASE_SITE_URL + "/embed/dashboard/" + token

[vaibhav-vqb]

@Luiggi did you get time to check this ?

[jpoel]

Hi @vaibhav-vqb,

Just to let you know, the issue you have described was the exact issue I was experiencing in that parameters passed through static embeds are not available in click behaviour. We weren't able to find a workaround for the issue.

[vaibhav-vqb]

Thanks @jpoel for confirming. Hoping to get some solution as it's become an important feature for us to implement.