I'm trying to pull a monthly report divided by weeks to see how many tickets moved from "Open" to "Resolved" per week. The tickets could have be created even before the month started.
I'm using the JIRA reports so I can pull it divided by weeks.But since I'm pulling the query at the end of the month, the problem is that the issue that was resolved in the 3rd week for example show up would just show under the numbers of the 1st week(since its only checking if the status is closed or resolved right now) which isn't what I want. Is there any "change of status on a particular time range" filter that i can use or maybe a query condition
This is my starting query:
issuetype in (Bug) AND status in (Closed, Resolved) AND created >= 2021-03-01 ORDER BY resolved DESC, created DESC