Can i get all the tickets activities history by date?

Question

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?

e.g.

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

Benjie · Answer

Thanks for the suggestion @Julia Denys [SaaSJet] . will give it a try

Benjie · Answer

@Ste Wright thanks for replying and apology for responding too late.

I have resorted to create my own google spreadsheet and get the data through REST API.

Julia Denys [SaaSJet] · Answer

Hi @Benjie

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 the Issue History add-on, it will show you the history of all the changes that had been made in selected issues.