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