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