Hey everyone!
I’m a data scientist/engineer who is pretty new to Looker. Currently I’m trying to use Looker Explores to enable data self-service for my team’s non technical members. I would like to know how to create cleaner date filter logic in the generated SQL.
Right now, adding a user defined date filter in Explore is generating a super messy SQL for something that should be really simple.
I’m sure I’ve overlooked some docs so would appreciate this community’s guidance!
Thank you,
Sung
Explore filter:
Lookml definition:
Resulting SQL