Hi there,
Looking for a way to create a date range filter that has relative start and end points (i.e., create look that shows purchases that happened between 3 and 6 months ago from when the look is viewed). I’ve tried to create a dimension in LookML to do this but have had no success. Any suggestions or alternate methods would be appreciated.
Thanks!
If I’m in a pinch, I often just filter on two different timeframes, like this:
You could do something similar and just create 2 purpose-built date dimensions, one “Date Start” and another “Date End” that you could filter on!
I know there are better approaches out there, but they require a little more digging around in the LookML, and this could be enough— If you’re interested in the more advanced methods happy to explain!
3 posts were split to a new topic: Relative Range filter
I split those posts out to a new Feature Request topic.
I got around this by creating a custom dimension which is just the regular dimension and using that in my filter. In this example, I want the members who were approved between 7 and 30 days ago