Link to a Dashboard passing through multiple parameters

Hey @amcgrath83 and @Groovy_Growler!

So sorry that we didn’t get back to you about this!

Looker does not currently have any functionality that will carry dashboard filters through when linking to other dashboards. I’ll definitely share your support of this idea with the product team!

One of our analysts came up with a workaround using liquid that will grab the filters from the URL and pass them to the dashboard that is being linked to. It’s not pretty but may be worth some fiddling! You can play with it by throwing this block of code into the html parameter of whatever field you’re using to link. Measures will need to contain a drill_fields parameter for the link to be referenced.

Note that dimension links no longer contain filter values, so the following code will only work for measures. It can be applied to dimensions as well, but a measure link will need to be referenced instead. For example, you can replace {% assign url_split_at_f = link | split: 'f[' %} with {% assign url_split_at_f = count._link | split: 'f[' %} and put it in the html parameter of the dimension.

{% assign url_split_at_f = link | split: 'f[' %}

          {% assign user_filters = link | truncate: 0 | replace: '...','' %}

          {% assign continue_loop = link == true %}

          {% for url_part in url_split_at_f offset:1 %}

            {% if continue_loop %}

              {% if url_part contains 'sorts' %}

                {% assign part_split_at_sorts = url_part | split: 'sorts' %}

                {% assign last_filter = part_split_at_sorts | first %}

                {% assign user_filters = user_filters | append:'f[' %}

                {% assign user_filters = user_filters | append:last_filter %}

                {% assign continue_loop = link == false %}

              {% else %}

                {% assign user_filters = user_filters | append:'f[' %}

                {% assign user_filters = user_filters | append:url_part %}

              {% endif %}

            {% endif %}

          {% endfor %}



          {% assign remove_last_ampersand = user_filters.size | plus: 2 %}

          {% assign user_filters = user_filters | truncate: remove_last_ampersand  %}

          {% assign user_filters = user_filters | remove: '...' %}

          {% assign user_filters = user_filters | replace: 'f[orders.created_date]', 'Date' %}

          {% assign user_filters = user_filters | replace: 'f[products.brand_name]', 'Brand' %}

          {% assign user_filter_split = user_filters | split: '&' %}

          {% for filter in user_filter_split %}

            {% assign filter_with_amp = filter | append: '&' %}

            {% if filter_with_amp contains 'f['%}

              {% assign user_filters = user_filters | remove: filter_with_amp %}

            {% endif %}

          {% endfor %}

          {{user_filters}}

Hey @amcgrath83,

Linking filters between dashboards is a feature that we do intend on implementing at some point. Because of this, we don’t have any plans that relate to improving this workaround. Sorry that I don’t have an ETA or a better recommendation!

Hi @kshah7,

Thanks for checking in, this is not yet a feature available in looker. It is still something that is being scoped for future release but no ETA from product yet. If you run into any issues while implementing the work around don’t hesitate to hop on chat and we’ll help you through it!

At the top of this article I have added a link to our documentation on Passing a Query’s Filter Values Into a Link. Hope that helps!