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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.