I am trying to get a report on how many times tickets have changed status from "ready to test" to "Reopened" in certain period. Is this achievable for Jira Cloud?
I have 3 tickets A, B and C. It was reopened 2,3,4 respectively. I want to be able to get the data as per below
Ticket Number | FromStatus | ToStatus | TimesStamp | Updater name |
Not in Jira Cloud as standard.
The only thing I know which is (near) what you're looking for is history searches in Jira - for example, you could search for all issues which have changed for your two statuses after the start of the day:
status changed FROM "Ready to Test" TO Reopened AFTER startOfDay()
Alternatively, you could search for all issues which have moved from resolved to unresolved during the last two days:
resolution changed FROM Done TO EMPTY DURING (2019-11-01, 2019-11-02)
There is some great information on these on this blog post. However, the results will be the same as you get in a normal issue search, so this will only include metadata you have access to on your environment (eg. current status, last updated date, etc).
If you want more specific details as fields, you'll need to consider using add-ons to create custom fields to house this data. Apps you could consider:
Yes, you can use Time in Status for Jira Cloud reports to get the needed information.
With this add-on, you can not only get the report of how many times an issue went from status to status, but also the report of the time that a particular assignee was assigned to each issue, the report of how long your issues has been staying in each status, how many times an issue has been in each status, and much more.
This add-on has an advanced filtering system by project, filter, report, label, sprint, and assignee (also by issue creation, update, and resolution date).
Moreover, you can view your data in charts (Pie, Bar and Area Charts). And, of course, you can export the data both as numeric reports and graphical.
You can also try Issue History add-on, it will show you the history of all the changes that had been made in selected issues.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event