Date Range Filter with Relative Dates

[Davis_Esplin]

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!