Date Range Filter with Relative Dates

low_priority
file
filter
done
(Davis Esplin) #1

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 Likes

(Izzy) #2

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!

0 Likes

(Izzy) split this topic #3

3 posts were split to a new topic: Relative Range filter

0 Likes

(Izzy) #4

I split those posts out to a new Feature Request topic.

0 Likes