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
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:
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'
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
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.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot