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 

Thanks

7 answers

1 accepted

1 vote

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
Joe 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.

 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

https://confluence.atlassian.com/display/JIRA/Advanced+Searching

Pilar

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 vote

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

143 views 0 3
Join discussion

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