How can I filter records “ before Monday for 30 days”?

We have a date dimension and we want to filter using matches(advanced) the last 30 days before the recent Monday. Any suggestions would be greatly appreciated. 

0 1 235
1 REPLY 1

You can accomplish this by adding a filter using matches(advanced) "before Monday" and applying a row limit for 30 days. The {day of week} filter allows for you to set a day of the week, and you can include "before" or "after" as well. More details can be found in our documentation on filters.

Below is an example of how I applied the advanced filter with a row limit. 

Screenshot 2024-05-29 at 8.50.55 AM.png

 

Top Labels in this Space