Ticket Reopen Rate (RR) Report
This report calculates the Ticket Reopen Rate (RR) using a formula that determines the ratio between all resolved issues and those that were resolved and subsequently reopened. It provides insights into the effectiveness of issue resolutions and helps teams identify recurring problems that may need further attention.
Step 1: Add Two Data Sources:
Data Source A: Filter resolved issues from the time period you wish to analyze. In our example, this period is 30 days.
Data Source B: Duplicate Data Source A to reuse the same filters. Add a JQL query
status was in (Reopened)
to filter only the issues that were reopened from all those resolved during the selected time period.
Step 2: Click on the Formula Metric tab and enter a name for the formula metric.
Step 3: Add Two Parameters:
P1: Number of issues calculated from Data Source A.
P2: Number of issues calculated from Data Source B.
Step 4: Enter the Formula Equation. Type the formula (P2 / P1) * 100
to calculate the percentage ratio between the two parameters.
Step 5: Configure the Display by: select the ‘Resolved’ field and specify the granularity, such as by week, or another suitable option for your analysis.
Here’s how Data Source B is configured in our sample: