Closed vs. reopened reporting apps comparison for Jira

In the world of IT service management, the efficient closure of support tickets is paramount. Yet, what if those tickets, once closed, rise up again because the initial resolution didn’t quite hit the mark? The need to monitor and enhance this process is where the Closed vs. Reopened issues report comes into play. After all, Reopened Issues are the sequel we didn’t ask for (as we explained in our previous article)

A specialized ITSM called Closed vs. Reopened report equips you with the essential tools to track, analyze, and ultimately improve your service management.

Let’s navigate the world of Jira reporting and discover the tools that can transform your data into actionable intelligence.

How to track closed and reopened issues in Jira?

Unfortunately, Jira Software does not have a built-in report specifically named “Closed vs. Reopened Issues.” To create such a report in Jira, you would typically need to use workarounds and custom reporting configurations.

First workaround

1. Ensure that you have the “Reopened” status defined in Jira project configuration.

2. Use JQL to search for issues that have ever been in the “Reopened” status.

3. Export the issues to other tools for building graphs, or use the Average Time in Status graph from Atlassian.

4. Analyze the data and make decisions.

Second workaround

You could also try to use the Jira Service Management built-in Time series report.

1. In Jira Service Management, you can set up a Jira report to track the number of issues closed and reopened over time. To do this, you need to create a report that includes two date series:

   1. Resolved Issues in statuses such as closed, Closed, done, etc.

   2. Resolved Issues in the same statuses but have also been in the “Reopened” status (if this status exists in your workflows).

   The report will typically look like the example shown below:

Third workaround

Yet another option is to use Jira automation (or Jira Script runner) to calculate the number of reopens per Jira issue.

Thus, despite having powerful features to create workarounds for the reopening rate of issues, Jira does not allow for comprehensive reporting on this metric out of the box. The great thing about the Atlassian ecosystem is that we can find various reporting tools specifically designed for this purpose! Let’s take a look at them.

Jira apps to monitor closed vs. reopened issues compared

You could use many apps to report against ticket Reopens. Since issue reopens case is always related with status and status category change, we selected a number of popular Jira reporting apps allowing you to report against statuses, time in status and transitions from one status to another. We will now look at the selected applications together:

EazyBI by EazyBI

Make sure you have established the required scope of Jira projects to be imported into EazyBI as a data source. Don’t forget to establish regular updates to ensure that you report against actual data.

No-coding variant: You can create a new Jira report and use the “Transitions from status” pre-defined measure, which will provide you with a view of all transitions that have occurred on your Jira issues. When using this measure in the “Columns” section of the report, and using the “Time” dimension in the “Rows” section of the report, you will get a nice-looking report. You can remove unnecessary transitions to only see those that you consider as reopens.

In our example, we only considered transitions from “Done” to “In progress” status.

You can transform the table into any required chart using EazyBI.

Coding Variant

One possible solution is to define a new calculated measure that checks the number of transitions from the “Done” status to the next statuses using calculated measures. Then, we can define a new measure using MDX.

The measure added to the report accurately displays the number of transitions that occurred from the “Done” status to the next statuses. We can verify this by comparing the manually obtained results with the calculated measure-defined ones.

You can also define specific measures to calculate the percentage of reopened tickets or create dimension members to ensure that you only count specific transitions from the “Done” status to other statuses. However, this will require extended coding using MDX. The same applies to calculations of the “reopening rate,” which you will need to define using MDX.

Report and Timesheets for Jira by Appfire

To create a Jira report against Jira issues transitions, you may use a combination of fields “Current Status“, “History Status“, “Last transition for status?“. An example of a simple report created with this technique is given below. Please note that you need to use JQL filter or Jira filter to filter issues belonging to specific projects or any other specific criteria.

Time in Status for Jira – Reports | Charts | Dashboard by SaaSJet

To check what Jira issues were reopened in any of your projects, simply create a report against “transition count“ metrics as shown below. Using this Jira report, you can easily track the number of issues that have been moved from one status to another. This will help you identify any instances where Jira issues with a “Done” status were migrated back to other statuses. In our example, there were no such cases detected.

Note: this report can be created in a table, or bar chart view, and then exported for further analysis.

Status Time Reports app by Bloompeak

To build Jira reports which will provide us an info about tickets reopenings, we need to click “new report” in the app. Then select the necessary filters and click “Search“.

You will see the list of tickets and transitions happened to them. By default, you see the duration of time Jira issues were in specific statuses. To see how often a ticket was reopened, you need to switch “count“ setting as shown below:

Now, you can see how many times each issue was in every status.

Despite the report not providing information on whether the issue has been reopened until it is closed again (i.e. you can only calculate the report against issues that were finally closed and not stuck in any other statuses), it still provides valuable information on reopens.

Time in Status by OBSS

The Time in Status application displays the duration of each status for filtered project Jira issues by default. To switch to viewing status transitions, you need to select “Count reports” in the application menu and then choose “Status count”. Additionally, you can select “Transition count” to see the direction of each transition.

Combining the resulting table analysis with “Transition count analysis“, you may understand the number of reopens, and the directions of the actual transitions during reopens.

A huge advantage of “Time in Status“ app is a capability to see graphs of the statuses.

Overall, this app also provides a flexible, yet easy way to report against issues reopenings.

Report Builder for Jira by Actonic

Report Builder has a dedicated “Closed vs. Reopened” report, which provides information on the number of Jira issues created, reopened issues, and the reopening rate as a percentage.

The “Closed vs Reopened” ratio is calculated by comparing the number of closed tickets to the number of reopened tickets. This ratio offers insights into the effectiveness of ticket resolution, with a higher ratio indicating a lower rate of reopened tickets and suggesting better overall process management performance. Monitoring and analyzing this ratio helps identify areas for improvement, implement preventive measures, and ensure thorough resolution of tickets on the first attempt.

Actonic’s “Closed vs Reopened Report” also provides users with a Data Source table that enables quick analysis of when the reopening occurred, what the exact transition was, and provides a supportive comment to explain if the transition is counted in the Jira report itself.

If necessary, you may choose to only keep the graph displaying the rate of reopened tickets as a percentage. This will hide the numbers of actually closed and reopened tickets themselves.

As a Manager, you may also be interested in getting a helicopter view on the numbers of tickets being ever reopened, rather than know ever reopen case. To fulfill this need, simply click on “Count multiple close and reopens only once per issue” and your task will be completed!

The Jira reporting app comparison at a glance

All apps were tested without custom workflows, where reopened issues end their lives in the “reopened” status. We aimed to reproduce the typical business flow where any issue ends up in “Resolved” or “Closed” status after it has been re-resolved since reopening.

Conclusion

In the realm of Jira reporting, Atlassian Marketplace offers a diverse selection of apps to cater to a multitude of needs. While the apps showcased here represent just a handful of the available options, they demonstrate the versatility of reporting solutions within Jira.

When it comes to generating closed vs. reopened reports directly within Jira, Report Builder stands out as a top choice. This app not only allows you to calculate reopens but also provides the capability to calculate the reopen rate, all without the need for extensive MDX scripting knowledge. With Report Builder, you can effortlessly gain valuable insights into the state of your Jira issues, making it the optimal solution for simplifying your Jira reporting needs in Jira. Your path to enhanced reporting capabilities begins here!