Issues moving back from QA to 'Fix needed' column

[Ajay thirth]

I wish to create a report that has the following columns: ... As an example, active issues have transitioned backwards from "QA" or "UAT". to 'Fix needed'

[Rustem Shiriiazdanov _Actonic_ · Accepted solution]

Hi @Ajay thirth

You can achieve that with some JQL. For instance, create a JQL query like

"resolved = EMPTY and status CHANGED FROM (3, 10001) to 123", where 3, 10001, 123 are IDs of your statuses (i.e. imagine 3 in yourinstance is id for QA, 10001 for UAT and 123 if for "Fix needed").

You can save such a search as a filter and use then as a report.

Alertnatively, if you are up to Marketplace solutions, you may use that JQL with any JQL-supporting tools like the Report Builder by Actonic to have a fancier look of a report, or a pivot as shown below

P.S. Unforunately, using status names instead of ID causes a bug, so you will have to stick to ID. See details here https://community.atlassian.com/forums/Jira-questions/JQL-searches-for-quot-status-Changed-From-quot-and-quot-status/qaq-p/1226048 

[Ajay thirth]

Wow - Fantastic - thanks so much , Is it also possible to get the count of ; How many times a particular story moved back and forth ? 

[Rustem Shiriiazdanov _Actonic_]

Thanks @Ajay thirth ! Well, you can’t get that purely via JQL alone, but you can have Jira keep track of “how many times” each issue jumps between your key statuses by either Automation, or a 3rd party apps (For instance Script Runner, or a special reporting apps like https://marketplace.atlassian.com/apps/12218%C3%A526/status-time-reports-time-in-status?hosting=cloud&tab=overview  or, again, the Report Builder app developed by my team https://marketplace.atlassian.com/apps/1216997/report-builder-custom-reports-and-dashboards-for-jira?hosting=cloud&tab=overview)

To do it with automation you will need to crate one or more custom numeric fields, and update them (write +1 into a specific field) every time issue changes the status. 

You may also consider using workflow postfunctions https://developer.atlassian.com/cloud/jira/software/modules/workflow-post-function/ to update a custom fields containing the info about number of times issue transitioned from one status to another.

[Ayça Erdem_OBSS_]

Hello @Ajay thirth 

Welcome to the community. 

If you'd like to report on how many times issues have moved backwards from QA or UAT to a status like "Fix needed", I recommend using a third-party app like Timepiece - Time in Status for Jira developed by our team at OBSS.

Timepiece offers a Transition Count Report, which shows how many times each issue has transitioned between any two statuses. This is especially helpful for identifying rework patterns or quality issues in your workflow.

With the Transition Count Report, you can track the exact number of transitions between any two statuses  for example, how many times an issue has been sent back from “QA” or “UAT” to “Fix needed.” This is particularly useful for identifying regressions, rework patterns, or bottlenecks in your QA and UAT stages.

The app calculates reports using your existing Jira issue histories, so you don’t need to modify your workflows or add custom fields. You can also group the results by fields like assignee, sprint, or issue type to gain more detailed insights.

Reports are accessible from the Timepiece reporting page, Jira dashboard gadgets, and the issue view tab. You can also export data or use the REST API for further integration.

If you'd like to explore this solution further, feel free to check out Timepiece - Time in Status for Jira on the Atlassian Marketplace.

Hope it helps,
Ayça

[Rahul_RVS]

Hi @Ajay thirth 

Welcome to the community !!

If you would be interested in a mktplace app for this requirement, you can try out

Time in Status Reports 

For your specific need the Status Transition details report can help. It shows the transitions the issue went through and on which date as well.

With this app you generate time in each workflow status for multiple issues with multiple filter and grouping options. The app has 20+ reports to meet a variety of use cases.

More details here.

Disclaimer : I am part of the app team for this add-on

[Iryna Menzheha_SaaSJet]

Hello @Ajay thirth 👋
Welcome to the community!

Hi @Ajay Thirth 
Welcome to the Atlassian Community!

If you're open to exploring marketplace solutions, I’d love to introduce you to the app my team and I are working on — Time in Status

For your exact need, we offer two helpful reports: 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 🚀