Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Counting specific status changes

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?

4 answers

1 vote

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.

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.

2020-01-11_22-41-44.png

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.

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.

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!

Like Randy Ho likes this

Hello @Madison Rojas

If you are interested in a ready-to-go solution, our team at OBSS created Time in Status 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ı

Hi @Madison Rojas ,

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

StatusCount.gif 

Suggest an answer

Log in or Sign up to answer
TAGS

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