It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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?

3 answers

2 accepted

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

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.

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

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.

@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

0 votes
Answer accepted

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

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

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.

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

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
Community showcase
Posted in Jira Software

Metrics Fun: 2019 in Review

Hello, Atlassian Community!  I thought it would be fun to do something different for my teams' last retrospective of 2019 so I'm planning to do a "year in review" with info-graphics.  Wha...

1,892 views 10 14
Join discussion

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you