Filter for stories created last week

[Tanmoy Sen]

Hi team,

I'd like to define a filter wherein the resulting dataset would be all the tickets that were created last week. Please note that the "last week" criteria is dynamic. Let's say, we are in the first week of November. I'd like to see all tickets created between Monday and Friday on the last week of October. Is such a filter possible?

[Tim Perrault · Accepted solution]

Hi @Tanmoy Sen 

Try the below. You might have to adjust the days, but I think I got it:

created >= startOfWeek("-6d") AND created <= endOfWeek("-8d")

 Tim