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.
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?