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

Vladimir Matveev
Contributor
February 27, 2020

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?

4 answers

2 accepted

0 votes
Answer accepted
Navarambh Software - Gmail
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 4, 2020

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

Screenshot 2020-03-05 at 12.15.08 PM.pngScreenshot 2020-03-05 at 12.15.04 PM.pngScreenshot 2020-03-05 at 12.14.59 PM.pngScreenshot 2020-03-05 at 12.16.06 PM.png

Regards

AIO Support

0 votes
Answer accepted
Zoryana Bohutska _SaaSJet_
Atlassian Partner
March 3, 2020

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

2020-03-02_20-43-58.png

Vladimir Matveev
Contributor
March 4, 2020

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_
Atlassian Partner
March 4, 2020

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?

2020-03-04_15-18-35.png

Regards,

Zoryana

Vladimir Matveev
Contributor
March 4, 2020

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_
Atlassian Partner
March 4, 2020

@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
Contributor
March 4, 2020

Thanks

0 votes
Sami Linnanvuo _Screenful_
Atlassian Partner
June 4, 2020

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

Screenshot 2020-06-04 at 15.29.37.png

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

0 votes
Thorsten Letschert _Decadis AG_
Atlassian Partner
February 27, 2020

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
Contributor
February 27, 2020

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_
Atlassian Partner
February 27, 2020

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
Contributor
March 1, 2020

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events