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?
Hi @Vandana
You can use the following JQL: "status changed FROM QA TO "In Progress"
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Also you can view the report by Chart in add-on or configure it as a Dashboard Gadget (both Grid and Chart available):
The Transition Count report shows how many times an issue has moved between all statuses in the workflow.
Chart view of report:
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 🚀
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
Disclaimer : I work for the vendor who built this app
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.