Keep track of workflow status changes?

Our venture is using JIRA for keeping track of specific actions we take with our clients (nothing to do with bug-tracking). 

We therefore have relatively long workflows with 20 or so statuses. I would really need to understand how each issue transitions into each status and would also need to keep track of these changes. The end goal of this archiving and reporting is to understand the conversion rates between each status, throughout our pipeline. 

I haven't seen any plug-in that allows me to archive changes between statuses, therefore I was thinking of using "advanced search" with some JQL that would allow me to see on a daily basis how many issues moved from one status to another.

I am no master with JQL so could someone tell me what code I would need to write into the advanced issue search in order to see all the issues that moved from "new lead" to "contacted" (these are to consecutive status)?

On the other hand, if someone knows of a better and more efficient solution feel free to share it with me laugh 


7 answers

1 accepted

1 vote
Accepted answer

For getting the number of issues that had changed their statuses today, you can create a gadget in your dashboard in which your saved Favorite Filters will be shown together with the number of issues which that JQL return. 

In order to achieve this:

  1. Enter Configure System Dashboard page. (press 'g' key twice and type system dashboard)
    1. Click on Add Gadget button, on the top-right corner.
      1. Select the gadget Favorite Filters.
      2. Click on Add Gadget.
          (The gadget will be shown on the dashboard)
          Check the checkbox to display the number of issues that each filter returns. 
  2. Check the gadget shows the number of issues returned by the JQL, and a link to actually perform the query.

thanks, i didn't see the numbers appearing on the right!

1 vote
Joseph Pitt Community Champion Aug 19, 2015

A simple way is to copy the current date to a custom date field with a post function in the transition. Only put them on the view screen. They will be visible in the issue details and easily available if you export a report with them. I use this for 'milestone' events in our workflows. You need to put the copy post function AFTER the update function or you may get a date other than 'today'

Cool solution! +1ed!

1 vote

JQL to get all issues which status had changed today from "new lead" to "contacted":

status changed FROM "new lead" TO "contacted" AFTER startOfDay()

It would be handy saving this JQL as one of your favourite Filters, so that you can perform that search with a mouse click.

Is the list static once the page is posted? i.e. if I change a status tomorrow, will it be added to the list or not?

I wish that it isn't because I want to keep track of all the issues that were passed from "Submitted" to "Accepted" during a particular meeting in the meeting notes of this meeting.

 all the issues that moved from "new lead" to "contacted"

For this you can use this JQL

status changed from "new lead" to "contacted" and updated > -24h and project=<your project name>

Also refer to this JQL article to familiarise yourself to JQL


Thanks for the great answers. My issue now is that I have 20 status and like 30 transitions so if I have to input 30 JQL queries every day, it would be a total waste of my time. Any idea if there is a way to create a single query that outputs the amount of issues transitioning in-between each status (therefore automatically counting the amount of issues that moved)? I'm assuming this should be possible since JIRA operates as a database and I know this could be done with a normal SQL based database. Anyhow thanks again for your responses. 


0 votes

JQL to get all issues which status had changed today:

status changed AFTER startOfDay()

I meant more something like this: new lead -> contacted: 3 contacted -> follow-up: 5 follow-up -> ... : 2 etc. So pretty much a counted list of all movements in each possible transition between status

Check my last comment. You can do so by saving all those JQL queries as your favorite filters and then, add the Favorite Filters gadget to your dashboard. This will require to save one filter for each change from one status to another one.

Good discussion. I am wondering if someone knows how to view the "changed from" state on the filter results screen or elsewhere.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in Jira

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,094 views 0 8
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you