Counting Status Transitions

Overview

Reporting on the number of times a Jira issue transitioned to a particular status can be extraordinarily helpful for tracking metrics like:

• Jira issue reopen counts
• the number of revisions a story or specification required before moving into development
• management approval passes
• efficiency in triaging tasks, stories or bugs
• QA, testing or other approval failure counts
• the number of exchanges required with customers to qualify reported issues

Using Dataplane Reports and the ScriptRunner for Jira add-on, tracking these metrics in Jira is simple.

In this example, we'll report on the number of times a Jira issue was reopened.  You can easily adapt this example to report on any particular Jira status or statuses relevant to your workflows or processes.

Configuring Your Jira Instance

1. Install the ScriptRunner for Jira add-on.

2. Create a new ScriptRunner custom field ("Scripted Field") in Jira, called "Reopen Count" (or whatever status you'll be tracking). Select Number Searcher for the "Search Template" option for this field, since the field will be returning numeric values.

   See our Reporting on Calculated Values with ScriptRunner documentation for details on using ScriptRunner custom fields with Dataplane. 

   You may also wish to review the general ScriptRunner primer on how to work with Scripted Fields.

3. After creating the new custom ScriptRunner field, go to Jira's Administration -> Add-ons page.
4. Click on Script Fields under the ScriptRunner section of the left sidebar.
5. Click Edit.

6. Enter the following script. (Substitute your status of interest for "Reopened".)

   import com.atlassian.jira.component.ComponentAccessor
   
   def theStatus = 'Reopened'
   def changeItems = ComponentAccessor.changeHistoryManager.getAllChangeItems(issue)
   def transitionsCount = changeItems?.findAll{it.field == 'status' && it.getTos().values().contains(theStatus)}.size()
   return transitionsCount as Double

7. Select Number Field for the Template setting for this field.
8. Reindex Jira. This is necessary whenever adding a new custom field in Jira.
9. Once Jira is reindexed, go to Dataplane Reports -> Administration and click on Sync Index to have Dataplane register the newly added custom field.

We're now ready to create the Dataplane report.

Creating the Report

For this example, we'll use a Dataplane historical report to display a count of issue re-openings plotted against issue resolution date.

In the Dataplane report directory, under New Report, select the Advanced category of reports. 

Select the Sum Numeric Field by Date Report.

For report configuration options, set up your report as follows: