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?
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 visit help.looker.com.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
