Question

show measures in look dynamically based on value in dashboard filter

  • 10 May 2022
  • 1 reply
  • 18 views

Hi,

 is it possible to make the set of measure shown it the look change when I change the dashboard filter? For example, I have a dashboard filter ‘category’ with values A and B. When I set the filter to A, measures avg, sum should appear in the look. And if I choose category B, mesures min, max, mean should be shown in the look.

I hope the question is clear. Is there a way to make this work?

Thanks a lot.


1 reply

Userlevel 7
Badge +1

Dynamic measures can be achieved using Liquid but since you’re talking about multiple ones, there’s quite a bit of work you need to do to set it up. Here is a helpful doc: https://help.looker.com/hc/en-us/articles/360001288108-Dynamically-Select-Fields-Using-Parameters

But I would also ask the question whether showing different metrics based on a filter is worth all this work?

Reply