Filter for stories created last week

Tanmoy Sen_4y8hp2

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

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