How to create a report on tasks that at least 1 time returned to the "To Do" status from the "Done"

[Vladimir Matveev]

In our Sprint, the workflow scheme is as follows:
To Do --> In Progress --> Waiting for Code Review --> Code Review OK --> Done --> Product Review OK.    

After the developer has written and verified the code and moved the problem to the status “Done”, the Product Manager checks it. If there are no comments, then the Product Manager moves the problem to the status of "Product Review OK".  If it is necessary to make corrections in the task, then he returns it to the "To Do" status.   In particular, I need to compile a report only on those tasks that were returned from the status “Done” to the status “To Do”.

How to do it?

[Navarambh Software - Gmail · Accepted solution]

Hi,

Please refer to the attached screenshots for such a report created using our app.

https://marketplace.atlassian.com/apps/1212942/aio-reports-and-timesheets-for-jira?hosting=cloud&tab=overview

This is a very simple report and much more advanced features are available with the app. 

Documentation: https://aioreports.atlassian.net/wiki/spaces/ART/overview

In case of any questions or issues, please feel free to email us at support@aioreports.com

Regards

AIO Support

[Zoryana Bohutska _SaaSJet_ · Accepted solution]

Hi @Vladimir Matveev 

If you on the cloud version of Jira and if you want to get data automatically, add-on Time in Status for Jira Cloud by SaaSJet can be helpful for you. This app can be useful to you precisely because of the reports it has:

- status count - let you monitor how many times an issue has been in each status

- transition count - will show you how many times an issue went from one status to other

[Vladimir Matveev]

Hi, Zoryana!

Thank you, I managed to get a report which, in particular, shows all changes in the status of all tasks. The filter allows you to select tasks by the project / sprint / assignee/ label/reporter/... But, unfortunately, there is no way to select, for example, only those tasks from this project in which there was a change in the status of the task that interests me.
Or am I wrong?

Best regards,

Vladimir.

[Zoryana Bohutska _SaaSJet_]

Hi @Vladimir Matveev 

If I understand you correctly, you can select statuses you need in the column manager. After configuration, you will see issues wich were at those statuses you selected before. Please let me know, is it that you mean?

Regards,

Zoryana

[Vladimir Matveev]

Hi, Zoryana!

No, you misunderstood me:
I made a selection of "transition count" and received a report on all tasks and on all changes in their statuses that occurred earlier. But out of more than 300 tasks, only 20 - 30 had 2 or more transitions from the status "Done" to the status "To Do", i.e. those tasks that were returned to the developer. But it is precisely these tasks that interest me.

In the report it is very inconvenient  to search for 20-30 necessary lines (with value 2 or more in the column " Done > To Do ") among 300 other lines. But to make an additional filter that allows you to remove extra lines (where the value of column " Done > To Do " is less than 2), I did not find the possibility.

Best regards,

Vladimir.

[Zoryana Bohutska _SaaSJet_]

@Vladimir Matveev  thank you for the clarification. Yes, you are right, now there aren't such ability to filter data by amount of transitions. We add it to our add-on development roadmap.

Thanks for your feedback!

Best Regards

Zoryana

[Vladimir Matveev]

Thanks

[Sami Linnanvuo _Screenful_]

@Vladimir Matveev Screenful Dashboard for Jira can show out-of-box issues that were reopened. Here's an example dashboard screen:



The columns on the right are configurable and in this example the column "reopened" shows the number of reopened tasks. When you click the number, the list of issues is shown. It's a pivot table so you can group it as you like (or just show totals per board). 

This add-on is also available on the Atlassian Marketplace. 

[Thorsten Letschert _Decadis AG_]

Hi @Vladimir Matveev ,

depends on what you'd expect as a 'report'. However, you'll get to the tickets you're interested in by running a JQL search like

status changed FROM "Done" TO "To Do"

 Obviously this search can be further extended by AND or OR clauses. A simple report could then be an export of the issue navigator or even adding a filter subscription in order to receive those tickets on a regular basis automatically via email.

Cheers
Thorsten

[Vladimir Matveev]

Hi, Thorsten!
Thank you.
Unfortunately, I have little experience working with Jira and your answer is not entirely clear to me:
 - regarding the “report” - this may be a list of tasks that changed the status from “Done” to “To Do” in this sprint...
 - What should I do in Jira to get such a report?
Best regards,
Vladimir.

[Thorsten Letschert _Decadis AG_]

Hi @Vladimir Matveev ,

I'd like to recommend starting in the documentation, e.g. looking for advanced searching in Jira or this blog post as a starting point for JQL.

How to export those search results afterward or 'generate your report', is explained in this part of the documentation.

Cheers
Thorsten

[Vladimir Matveev]

Hi Thorsten!
I did what you recommended to me:" project= AAA AND status changed FROM "Done" TO "To Do". But the result did get: "No issues were found to match your search", despite the fact that I have changed the status of several tasks before this from "Done" to "To Do".

Best regards,

Vladimir