showing tickets open end of Last week

[Michael Macarthur]

hey guys, In our ServiceDesk environment, I need to report on tickets that were OPEN at the end of last week, and end of the week before to show a trend. I have built the JQL...

queue = "IT" AND Status was not in (Resolved, Closed, Done, "Done with Issues") on endOfweek(-1w) (and also other query with EndOfWeek(-2w)

These both work but pull in currently open tickets as well (i can see one created 38 mins ago). If i created a query asking what was OPEN last Saturday by date the same result applies

im going nuts, other JIRA users in-house seem to think the query is good, so I dont know how to capture this historical data in a consistent manner.

oh, this is all on an in-house JIRA server, not cloud

[Pete Rooney]

How about including AND Created < StartOfWeek()

I ran a query with and without this and without showed 2 more than with - the two extra ones were created today.

Hope this helps

Pete