Counting specific status changes

[Madison Rojas]

My team is wanting to lessen the number of times a ticket is passed from QA back to in progress. 

Is there some sort of Query I can write in Jira that would make this possible?

[Mohamed Benziane]

Hello,

You can try this plugin Enhancer plugin 

Or you can use API to get the history:

rest/api/2/issue/{issueIdOrKey}

https://developer.atlassian.com/cloud/jira/platform/rest/v3/?utm_source=%2Fcloud%2Fjira%2Fplatform%2Frest%2F&utm_medium=302#api-api-2-issue-issueIdOrKey-get

Hope this helps.

[Zoryana Bohutska _SaaSJet_]

Hi @Madison Rojas 

As I understand, you need a solution for Jira cloud, so you need a suitable add-on for this version. One of them is Time in Status for Jira Cloud. At this app you can find the report Transition Count, whit will show the information you asked.

[Mehmet A _Bloompeak_]

Hi @Madison Rojas ,

You can use Status Time add-on. It generates status count report in addition to status time report.

 

[Emre Toptancı _OBSS_]

Hello @Madison Rojas

If you are interested in a ready-to-go solution, our team at OBSS created Timepiece - Time in Status for Jira app for this exact need. It is available for Jira Cloud, Server and Data Center.

Using Time in Status you can also see the number of times each status or transition was used (very useful for inspecting things like reopen counts). You can report how much time each issue spent on each status, each assignee or even each user group. (useful for identifying bottlenecks in your process). You can consolidate multiple statuses into a report column (useful for calculating metrics like lead/cycle times). You can also list the status entry/exit dates.

Using Time in Status by OBSS, you can produce reports based on the default 24/7 calendar or define your own business calendars with custom workdays and working hours. 

Also add system or custom fields as columns to your report and customize the view format of durations.

All data can be exported as XLS, XLSX, CSV.

Emre Toptancı

[Randy]

There should be a widget in dashboards that lets you create a "times in status" report.  Set it to show the counts for qa and in progress status's.

It wont be able to tell you the number of times a ticket went from qa back to in progress but depending on how your team works, you can get close to understanding the trend over time of tickets getting kicked back from qa by looking at the number of times a ticket goes into the in progress and qa status's.

[Randy]

With that said, if you actually want a specific count, you would need to use either a plugin to increment a custom field as a post function of the transition or leverage the API to generate a report manually with a custom script.

There may be an add on in the marketplace also but i havent looked.

[Madison Rojas]

Thanks Randy!

Ya we discussed doing a script, but wanted to see if Jira would be able to do it before we jumped to that option. I will look into this dashboard and see if it will give us what we are looking for. 

Thank you so much for your response and time!