ITERATION Dashboard
- 1 KPI Definitions
- 1.1 Iteration Commitment
- 1.2 Planned Work Status
- 1.3 Unplanned Work Status
- 1.4 Work RemainingÂ
- 1.5 Issues likely to spill
- 1.6 Closures possible today
- 1.7 Quality Status
- 1.8 First Time Pass Rate
- 1.9 Wastage
- 1.10 Defect count by RCA
- 1.11 Defect count by Status
- 1.12 Defect count by Priority
- 1.13 Iteration Burnup
- 1.14 Estimate vs Actual
- 1.15 Estimation Hygiene
- 2 Real-time data refresh
- 3 Azure Boards Implementation Explained
Â
KPI Definitions
KPI Name | Definition | Calculation logic | Filters | Overlay Screen |
---|---|---|---|---|
Iteration Commitment | Iteration commitment shows in terms of issue count and story points the Initial commitment (issues tagged when the iteration starts), Scope added and Scope removed. | The widget should show
 | Filter by issue type Filter by Status |
|
Planned Work Status | It shows count of the issues having a due date which are planned to be completed until today and how many of these issues have actually been completed. It also depicts the delay in completing the planned issues in terms of days. | Planned - Show only the ones with due date Actual Delay is calculated between due Date & completed Date of issue. Potential Delay is calculated between due Date & Predicted Completed Date. Â | Filter by Issue type Filter by Priority |
|
Unplanned Work Status | It shows count of the issues which do not have a due date. It also shows the completed count amongst the unplanned issues. | Overall Unplanned - Show the issues which doesn’t have due date Completed - Show amongst the ones which are not having due date and completed. | Filter by Issue type Filter by Priority |
|
Work Remaining | Remaining work in the iteration in terms count of issues & sum of story estimates. Sum of remaining hours required to complete pending work. | Issue count - Total no. of issues that are not completed. Story Points - Sum of story points of all issues not completed Hours - Sum of remaining hours of all incomplete issues in Jira Potential Delay - Show in Days (sum of max. delay of each assignee) Source of this KPI is Jira. To see the latest data, run the Jira processor from KnowHOW settings  The Delay of in progress stories was getting add up to subsequent stories, so we have changed the logic as per below On Overlay we are showing delay of all the stories, but on kpi, calculation of only in progress stories are applied In Active sprint ** - *(1)* {+}In progress stories{+}: the delay will be calculated as per today's date i.e., todays's date + remaining estimate, for all the stories marked as *in progress* -
** Â - the delay in all the stories will be calculated from sprint end date + remaining estimate | Filter by Issue type Filter by Status |
|
Issues likely to spill | It gives intelligence to the team about number of issues that could potentially not get completed during the iteration. Issues which have a Predicted Completion date > Sprint end date are considered. | This widget shows number of issues likely to spill. It is based on the logic of remaining estimate of an issue and comparing it with the remaining time in the sprint. 1 day considered as 8 hours | Filter by Issue type Filter by Priority |
|
Closures possible today | It gives intelligence to users about how many issues can be completed on a particular day of an iteration. An issue is included as a possible closure based on the calculation of Predicted completion date. | This widget should show Closures possible on a day based on
One multi-select filter of issue type Logic to calculate is
 |  |
|
Quality Status | It showcases the count of defect linked to stories and count that are not linked to any story. The defect injection rate and defect density are shown to give a wholistic view of quality of ongoing iteration |
Note:
| Â | The overlay window shows linked defects grouped for each story (Release 8.0.0) |
First Time Pass Rate | Percentage of tickets that passed QA with no return transition or any tagging to a specific configured status and no linkage of a defect. | First Time Pass Stories - Stories which are not having return transition or defect tagged. Total Stories - Complotted issues from sprint report. First Time Pass Rate - First Time Pass Stories/Total Stories. Note:
| Â | Â |
Wastage | Wastage = Blocked time + Wait time , Blocked time - Total time when any issue is in a status like Blocked as defined in the configuration or if any issue is flagged., Wait time : Total time when any issue is in status similar to Ready for testing, ready for deployment as defined in the configuration etc. |
| Filter by priority Filter by issue type |
|
Defect count by RCA | It shows the breakup of all defects within an iteration by root cause identified. | Â | Â | Â |
Defect count by Status | It shows the breakup of all defects within an iteration by status. User can view the total defects in the iteration as well as the defects created after iteration start. | Â | Â | Â |
Defect count by Priority | It shows the breakup of all defects within an iteration by priority. User can view the total defects in the iteration as well as the defects created after iteration start. | Â | Â | Â |
Iteration Burnup | Iteration Burnup KPI shows the cumulative actual progress against the overall scope of the iteration on a daily basis. For teams putting due dates at the beginning of iteration, the graph additionally shows the actual progress in comparison to the planning done and also predicts the probable progress for the remaining days of the iteration. | User should able to see count of issues closed daily broken by issue type Chart type - Clustered Column X-Axis - Days (Dates) Y-Axis - Count | Â |
|
Estimate vs Actual | Estimate vs Actual gives a comparative view of the sum of estimated hours of all issues in an iteration as against the total time spent on these issues. | Shows 2 data points
The above information should be summed up for all issues in the selected sprint This KPI can be filtered based on
Both work in combination
| Â |
|
Estimation Hygiene | It shows the count of issues which do not have estimates and count of In progress issues without any work logs. | KPI to be renamed to 'Issues without Estimates' One Multi-select Dropdown to filter by issue type Legend has to be changed toÂ
One Multi-select Dropdown to filter by issue type Legend has to be changed toÂ
Remove Stories without estimates Missing |  |
|
Real-time data refresh
Users can see real-time data for the active sprint by clicking the Refresh CTA. When a user clicks on Refresh, he is asked for a confirmation. Upon confirmation, data fetch gets initiated and it takes up to 30 sec for the dashboard to be refreshed with the latest updates in Jira/Azure tool. While refresh is in progress, the ‘Refresh’ CTA changes to ‘Syncing’. When the sync is finished, the last updated date gets refreshed.
This functionality allows to review that latest KPI information
Azure Boards Implementation Explained
Required Configuration Field Mapping -  Iteration Dashboard & SPEED KPIs Completion Status - identify completed issues in the sprint report.
Based on field mapping divide into completed and not completed issues for sprint report
when configuring Azure project and the first initial run saved that time of snapshot for closed sprint data, after that closed sprint details data will not change.
For Active sprint, Compare saveddbTotalIssues and fetchedTotalIssues , if any new issues found then it will be consider as added issues, and if any issues is missing then it will be considered as punted issues.
and every run it will compare issues and maintain a snapshot of the sprint and after the closed sprint it will be saved the last day snapshot of the sprint.
for future sprint data will be only saved for first time after that it will be data will be updated when that particular sprint will be active.
Â
Limitation to Azure Boards implementation for snapshot KPIs
 if any user delete data of the project , impact lost all snapshot sprint details after the next run fetch data based on the latest data.
 If a user added any issues type from field mapping ( Issue Types to be fetched from Jira) then sprint report data will be mismatched . for example closed sprint snapshot will be not change. new issues type will be not shown in closed sprint report and for active sprint all new issues will be counted as added issues in the sprint report .
In case of last day active sprint between the sprint closed time , it will be any changes and did not run processors then may be some delta data will be missing for not completed issues.
© 2022 Publicis Sapient. All rights reserved.