How can use matches(advanced) in looker to filer records last 30 days before the recent Monday

[Kepler31]

I'm working on a Looker dashboard, and I need to filter records based on a date dimension for the last 30 days before the most recent Monday. I understand that I can use the matches(advanced) filter in Looker, but I'm unsure how to write the expression for this specific requirement. Could someone provide guidance or an example of how to achieve this using matches(advanced) in Looker? Thank you! I have tried using “before Monday for 30 day” but it’s not working. I know “before Monday” returns all records before the most recent Monday, but i wanna limit that to the last 30 days before the most recent Monday.

[hutcheric]

It doesn't look like this is possible using the "matches(advanced)" filter, however it can be accomplished using a LookML filter field that calculates that date range using SQL. You could then filter on that field in your query.

If you need a quick way of accomplishing it without using lookml, you can filter "before Monday" and then set the row limit on the query to "30," which will only bring back 30 rows/dates into the query.