Populate parameter labels and values by query result

  • 3 May 2022
  • 1 reply
  • 17 views

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 reply

Userlevel 2

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

 

Reply