Sprint Rollover Ratio KPI

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‘.

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.