Filter to include data for dates from last friday through this thursday?

[Todd_Meyer]

I could be missing something, but the filter expressions https://docs.looker.com/reference/filter-expressions?version=7.14 do not cover what I’m trying to achieve.

I want to only show data starting from last week’s Friday through this week’s Thursday.

If I were to run this on Tuesday, I’d see data from last Friday through current (Tuesday)

Ideally something like last Friday for 7 days would work, but it is not valid because ‘last Friday’ is not supported. Any ideas?

[mprogano]

You could filter for only last week and CASE WHEN for the day of the week. Alternatively, you can figure out the last weeks Monday and manually addday() for a range