Sprint Rollover Ratio KPI
Calculate the ratio of rolling issues in the sprint versus all issues in the sprint using the formula feature. This report tracks how many issues from previous sprints are carried over into the current sprint, and compares them to the total number of issues. Set a maximum allowed value for the ratio per sprint to help manage scope creep and maintain sprint focus.
Step 1: Add a Data source. In our example, we have filtered our Scrum demo project ‘Aqua’ and have disabled the date range to view all previous sprints.
Step 2: Select ‘Number of issues in Sprint‘ metric.
Step 3: Choose Sprint for ‘Display by‘ field to uncover more filtering options for your metric and add the Sprint Board you want to analyze.
Step 4: Go back to ‘Number of issues in sprint’ metric and select Formula Metric tab.
Step 5: Add two parameters for your Ratio formula. One (P1) for all issues in sprint, and the second one (P2) filtering only rolling issues in sprint.
Step 6: Add formula equation: (P2/P1)*100 to calculate the ratio in %.
Step 7: Assign a custom name to your formula metric like ‘Rolling vs All Ratio‘.
Add target in a few simple steps:
Step 1: Turn on the Target section and choose the Fixed target type.
Step 2: Select the Per x-axis item target calculation.
Step 3: Add the fixed target value. In our case, the maximum number of issues rolling from sprint to sprint is 30%.
Step 4: Specify that exceeding this maximum target is considered "Bad."
Step 5: Under the More Settings section, add a warning threshold to signal early when approaching the maximum.
Step 6: Adjust the target label to reflect the negative aspect of exceeding the target maximum.
Watch the video tutorial at our website: https://devacrobats.com/sprint-rollover-ratio-jira-dashboard/