Count 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 requires 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 Jira Misc Custom Fields (JMCF) or ScriptRunner for Jira app, 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.

Configure your Jira instance

1. In Jira, install the Jira Misc Custom Fields (JMCF) or ScriptRunner for Jira app.

2. Create a new JMCF custom field of type Calculated (scripted) Number Field, or a ScriptRunner custom field of type Scripted Field. Name the field "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.

3. For a JMCF or ScriptRunner custom field, use the following script (replacing 'Reopened' with your status of interest):
   
   

   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

   If using a ScriptRunner custom field, select Number Field for the Template field setting.

4. Reindex Jira. This is necessary whenever adding a new custom field in Jira.

5. Once Jira is reindexed, click Dataplane Reports → Administration → Configuration. On the Indexer tab, click the Sync Index button to have Dataplane register the newly added custom field.

We're now ready to create the Dataplane report.

Create the report

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

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

Select the /wiki/spaces/dataplaneDraft/pages/442728497.

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

Option	Selection	Comments

Option	Selection	Comments
Time Period	any	Select your dates of interest using relative dates ("Last 3 Months", "This Year") or a custom Start Date and End Date.
Search	any	Select your Jira projects, project categories, and filters of interest. Or click the JQL tab in that field to enter a command using Jira Query Language (JQL).
Value Of	Reopen Count	Select the newly added JMCF or Scri’s reopen count will be plotted. You might alternatively choose "Created Date" or a custom date field.
Chart Type	Open	Select the Column Chart

Click the Run Report button to create your report.  

We see a clear report of issue reopen counts across the selected time period.

Open

To better understand which issues in this project were most frequently reopened, let's go back to the report configuration page and add Issue Type (Historical) to the Segment By field to break down the results.

Here's what the report configuration now looks like:

Open

Running the report again, we now get the same results segmented by issue type:

Open