I need to shows how many times tickets have transitioned from QA status back to In Progress.

Vandana November 13, 2024

 

 

I need a report that shows how many times tickets have transitioned from QA status back to In Progress status. Is it possible or feasible?

5 answers

2 votes
Marc - Devoteam
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.
November 13, 2024

Hi @Vandana 

You can use the following JQL: "status changed FROM QA TO "In Progress"

1 vote
Hannes Obweger - JXL for Jira
Atlassian Partner
November 15, 2024

Hi @Vandana

viewing the actual number of transitions is a bit tricky in native Jira; you'd either have to go through the issue history yourself, or perhaps tricker an automation rule (in Jira Automation) anytime that the transition occurs, and increase the number in a custom field. 

Alternatively, if you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called history columns that aren’t natively available, including number of transitions to [status], number of transitions between [status] and [status], and many, many more.

This is how it looks in action:

number-of-status-changes.gif

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Of course, you can also export your data to e.g. Excel or CSV in just two clicks.

This all just works - there's no scripting or automation whatsoever required. 

Any questions just let me know,

Best,

Hannes

1 vote
Vitalii_Bobak_SaaSJet
Atlassian Partner
November 14, 2024

Hello @Lubna Malik 

You can utilise JQL that @Marc - Devoteam suggested

Also if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on - Time in Status

For your exactly need we have Status Count report or Transition Count report

The Status Count report shows how many times an issue has been in each status.

Status count .png

Also you can view the report by Chart in add-on or configure it as a Dashboard Gadget (both Grid and Chart available):
Status count  chart view.png
The Transition Count report shows how many times an issue has moved between all statuses in the workflow.Transition Count report.png

Chart view of report:

Transition Count report Chart view.png

You can also book a live session or contact us at Support - we'll help you with Time in Status. 

I hope you find this helpful 🚀

0 votes
Madhu_RVS
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.
November 15, 2024

Hi @Vandana 

As suggested by everyone, a mktplace app can help here for detailed reportin. if you would be interested in the same, please try out an add-on we have developed for the same use case.

Time in Status Reports 

The app has more than 20+ reports to meet a variety of use cases. For your requirement, the report below can help track the issues with the status date change details.

More details here

Disclaimer : I work for the vendor who built this app

TIS - STatus Transition Count.PNG

0 votes
Gizem Gökçe _OBSS_
Atlassian Partner
November 15, 2024

Hello @Vandana ,

You can get a basic count of how many times tickets transitioned from “QA” to “In Progress” using a JQL query in Jira. Here’s a quick way to do this:

JQL Query: You can use the following JQL query to see all tickets that have transitioned from “QA” to “In Progress” at least once:

status changed FROM "QA" TO "In Progress"

This query will show you the list of tickets, though it won’t specify the exact number of transitions for each ticket.

Alternative Solution:
For a detailed report showing how many times each ticket has transitioned between “QA” and “In Progress,” our app, Timepiece - Time in Status for Jira, the oldest and leading 'Time in Status' app in the Atlassian Marketplace, which is developed by my team at OBSS, has several report types that will meet your need. With Timepiece, you can:

Transition Count Report: Track the exact number of transitions between specific statuses for each ticket, which is ideal for monitoring rework and process flow.

Transition Count.png

JIRA Dashboard Integration: Add this report to your Jira dashboard using the Timepiece Dashboard Gadget to view these metrics in real time.

Timepiece is available for both Jira Cloud and Data Center. Let me know if you’d like help setting up this report or need more information! If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

 

Suggest an answer

Log in or Sign up to answer