Populate parameter labels and values by query result

Hi Community,

I don’t think it is currently possible but it would be very helpful if a parameter’s label and value fields could be populated by a query.

Ultimately, what I would like to achieve is to filter on a partition in the underlying database table. However, the partition IDs are actually associated with user-friendly labels which should be shown to the user and then automatically “translated” to the respective (ID) value.

I could of course hardcode this but I’d definitely prefer the dynamic way via query and I am sure that there are use cases where it would be quite tedious to type all the labels and values.

Has anyone else come across this issue or is this not a common use case?

Thanks,

Beate

1 1 354
1 REPLY 1

leobardor
Participant V

Hi Beate

Did you try using templated filters?

https://help.looker.com/hc/en-us/articles/360023624034-Advanced-Templated-Filters

Alternative, you can create a SQL CROSS JOIN between a catalog table and a particular view to get all possible options to select

Hope it helps!

Best,

Leo

Top Labels in this Space
Top Solution Authors