dashboard link does not pass clicked value

mary_schulte · 08-03-2021 11:34 AM

I am trying to link 2 dashboards.

I have this in my model:

view: account {

sql_table_name: account ;;

dimension: account_id {

type: string

primary_key: yes

sql: ${TABLE}.account_id ;;

}

dimension: account_name {

type: string

sql: ${TABLE}.account_name ;;

link: {

label: "Account Prosepcts"

url: "/dashboards-next/26?account%20id={{ account.account_id._value | url_encode }}"

#url: "/dashboards-next/26?account_id={{ account.account_id._value | encode_uri }}"

#url: "/dashboards-next/26?account_id={{ _filters['account.account_id']| url_encode }}"

icon_url: "/favicon.ico"

}

I have this little dashboard that I want to link TO:

It has a filter on account_id.

On the dashboard

I want to link from:

When I click on a particular company, I want to send that I to the dashboard above but only show that company. This is not working.

When I click on “Account Prospects” for a particular company, my browser URL changes to this but only briefly. This looks correct.

But then immediately, the browser url changes to this, which as you can see has lost the filter.

The result is the dashboard above that has no filter applied.

I’ve tried endless combinations of syntax in the link suggested in other similar threads and in the help center to no avail.

Why is this happening and how do I fix it?

thanks!