Date Range Filter with Relative Dates

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!

0 4 6,870
4 REPLIES 4

If I’m in a pinch, I often just filter on two different timeframes, like this:


which accomplishes the end goal but isn’t a great solution.

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

Top Labels in this Space
Top Solution Authors