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.
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.