Creating a dynamic URL that links to different dashboard

I’m trying to do something similar, but make the use of filters in the link dynamic (honestly, drill links in Looker are unreasonably restrictive), so that the same field from the same view can be used on multiple dashboards, and link to the appropriate other dashboards as defined by me - rather than the rigidity Looker prefers.

I want to do something like this:

dimension: team {
    link: {
      label: "View by Agent"
      url: "/dashboards/{% parameter dashboard_to_link_to %}?Date={{ _filters[{% parameter date_dimension_for_filters %}] | url_encode }}&Team={{ value | url_encode }}"
    }
  }

This dimension needs to be included on multiple different dashboards, and depending on the context of the “team level” dashboard, depends on which “agent level” dashboard I want to drill to. The Lab feature “Dashboards in Drill Menus” is no good, as it seems to fail to line-up filters and pass the values through.

Passing the parameter dashboard_to_link_to (which is a number) is no problem. I can happily set this parameter at a dashboard level, and it makes the link dynamic. The “Team” filter is also no problem, that reliable adopts the value of the item clicked on. 

My issue is trying to make the “Date” filter dynamic, as not every dashboard will be filtered on the same date dimension from the same view. I think what I want is another parameter, containing a string (or an unquoted string), to pass into the _filters[] variable. I’ll then, on a per dashboard basis, give this a value representing the dimension name being used as the filter in that dashboard; “view.create_date”, say.

The above gives me a “token recognition” error - it seems unhappy about nesting a {%%} inside a {{}} (or possibly inside the [ ]). I haven’t yet been able to find any combination of tokens or value references that works, or find another way to concatenate the url I want together.

I say all of this is what I want to do, but in truth what I really want to do is just click on a dimension in my visualisation, pick a dashboard from a list, map filters and dimensions from the source dashboard to filters and dimensions on the target dashboard, and click a “save” button. Like MS Reporting Services managed to do 15 years ago. Not sure how it’s 2022 with BI solutions that can’t easily customise drill links, but here we are.