Dropdown in explore to change column in a derived table

templatedfilter

#1

Hey folks, I want to change the column s.creation_at to s.completion_at from an explore with a handy dropdown filter.

in the derived table section in lookML the condition that I want to change looks like this:

where h.hit_time < s.creation_at

How do I get parameters and filters set up that it populates s.creation_at or s.completion_at in this where clause depending what I choose in the explore?


(jeffrey.martinez) #2

Hey Chris, this sounds like a pretty good use case for parameters in LookML.

The “label” parameter would specify what appears in the dropdown, and the “value” parameter would specify what would be imputed into the SQL where the parameter is tagged.

There are a few examples in this article that show parameters in action, just to give you an idea.

If you need more in depth help, feel free to ask us on chat or email support@looker.com.