Aggregated sprint ADS Q2 W24 - 15-19 Jun • deduplicated roll-up across included teams
This org roll-up aggregates deduplicated frozen issue facts across 4 team snapshots. Count metrics link to snapshot-exact JQL result pages. Jira IDs in the report link to live Jira issues.
Download DOCXYellow. The sprint closed 43/104 visible items. The org roll-up absorbed noise reasonably well — 25/33 added items were closed — but finish predictability was only 27.1% (16/59), and bugs made up 46.5% of completed items. Planning-baseline carryover includes 43 finish misses and 9 expected progress continuations.
| Metric | Value | How to read it |
|---|---|---|
| Committed completion | 25.4% (18/71) | Planned items marked Done ÷ all planned committed items |
| Planning-baseline carryover | 74.6% (53/71) | All planned items not Done, including expected Progress continuations |
| Finish-intent carryover | 72.9% (43/59) | Finish-intent planned items not Done ÷ all finish-intent planned items |
| Finish predictability | 27.1% (16/59) | Finish-intent planned items done ÷ all finish-intent planned items |
| Progress predictability | 81.8% (9/11) | Progress items that behaved as intended by carrying |
| Added-during-sprint load | 31.7% (33/104) | Outcome-only items ÷ all visible items |
| Added work closure | 25/33 | All added items marked Done |
| Reactive load (bug share) | 46.5% (20/43) | Completed bugs ÷ all completed work |
| Planning quality | 38.0% (27/71) | Committed items marked Ready ÷ all committed items |
| Workflow-truth mismatches | 2 | Items marked Done in review while workflow status remained non-final |
Across included teams, the sprint did not fail; it traded predictability for responsiveness. 25/33 added items were closed, but that responsiveness came with 46.5% bug share and diluted finish predictability.
The miss pattern is concentrated: 14 partial-completion carryovers, 3 dependency-driven misses, and 22 planning-baseline items that never really started.
Most misses were not caused by poor readiness. 16 of the 53 planning-baseline carryovers had been marked Ready, so the stronger hypothesis is breakdown, sequencing, and capacity protection rather than simple scoping immaturity.
| Type | Planned | Added | Stretch | Unclear | Total done | Done % |
|---|---|---|---|---|---|---|
| Story | 5 | 2 | 0 | 0 | 7 | 16.3% |
| Task | 3 | 6 | 0 | 0 | 9 | 20.9% |
| Bug | 7 | 13 | 0 | 0 | 20 | 46.5% |
| Signal | Value | Why it matters |
|---|---|---|
| Planning-baseline items | 71 | Items present in the frozen planning snapshot |
| Planning-baseline done | 18 | Closed by sprint review |
| Planning-baseline carryover | 53 | All planned items still open, including Progress continuation |
| Finish-intent carryover | 43 | Planned-to-finish items that did not finish |
| Progress continuation | 9 | Progress-intent planned items still open as expected |
| Planning-baseline items marked Ready | 27 | Planning-quality input |
| Carryovers marked Ready | 16 | Ready did not guarantee closure |
| Carryovers not started | 22 | Execution focus gap |
| Carryovers started but unfinished | 15 | Work moved, but did not close |
| Pattern | Count | What it suggests |
|---|---|---|
| Partial completion | 14 | Breakdown / sizing / stage-gating was not tight enough |
| Dependency delay | 3 | Capacity protection or dependency timing created slip |
| Not started | 22 | A committed item remained outside execution focus |
| In Progress / Code Review carryovers | 15 | Most misses were moving, but not closing |
Items marked Done in the sprint-review field while Jira workflow status was still non-final.
| Jira item | Status | Intent |
|---|---|---|
| ADS-7962 — [MOB] Translate app in French | Ready for testing | |
| ADS-7963 — [FE] - Notare cu calificative, insa in catalog PDF apare mediile in note | Code Review |
| Question | Why this matters | What evidence to ask for |
|---|---|---|
| Why did finish-intent items carry over despite planning readiness? | This tests execution quality rather than just scope quality. | Show finish-intent carryovers split by dependency, partial completion, and not-started. |
| Are Progress items being managed intentionally? | Progress items are allowed to continue, but the continuation should be visible and controlled. | Show the original slice and the specific landing expectation for each item. |
| Is added work a healthy responsiveness level or chronic interruption? | High responsiveness can hide systemic instability and diluted predictability. | Show which added items were urgent/reactive versus discretionary scope change. |
| Can we trust Done in review when workflow is still non-final? | Workflow-truth gaps reduce trust and make completion easy to game. | Show the exact mismatches and the completion rule to enforce next sprint. |
Included teams in this org pulse: Mobile, Team 1, Team 2, University.
Usage note: start with the top-line metrics, then use the traceability links to answer these questions with issue-level evidence.
| Snapshot / movement | Issue count | Calculation | Link |
|---|---|---|---|
| Planning snapshot raw list | 74 | Frozen planning export before metric exclusions | Open JQL |
| Sprint review / outcome snapshot raw list | 108 | Frozen review export before metric exclusions | Open JQL |
| Normalized sprint fact base | 104 | Deduplicated union used by metrics after canceled/cancelled exclusions | Open JQL |
| Metric planning baseline | 71 | Non-canceled issue keys present in the frozen planning snapshot | Open JQL |
| Metric outcome snapshot | 104 | Non-canceled issue keys present in the frozen sprint-review snapshot | Open JQL |
| Planned and still present at review | 71 | planning_snapshot_present = true and outcome_snapshot_present = true | Open JQL |
| Added after planning | 33 | planning_snapshot_present = false and outcome_snapshot_present = true | Open JQL |
| Planned but missing from review | 0 | planning_snapshot_present = true and outcome_snapshot_present = false | Open JQL |
| Metric-excluded canceled/cancelled rows | 4 | Rows preserved in audit but excluded from every numerator and denominator | Open JQL |
Planning and outcome are separate frozen moments. Raw snapshot counts can be larger than metric counts because canceled/cancelled rows stay in audit but leave all metric denominators.
Added after planning is snapshot-based: present in the outcome snapshot and absent from the planning snapshot. Planned but missing from review shows items that left the sprint snapshot before review.
| Metric | Value | Formula | Numerator / denominator | Denominator evidence |
|---|---|---|---|---|
| Committed completion | 25.4% (18/71) | planned committed items marked Done ÷ all planned committed items | 18/71 | Open denominator JQL |
| Planning-baseline carryover | 74.6% (53/71) | planned baseline items not Done at review ÷ all planned baseline items | 53/71 | Open denominator JQL |
| Finish-intent carryover | 72.9% (43/59) | finish-intent planned items not Done at review ÷ all finish-intent planned items | 43/59 | Open denominator JQL |
| Finish predictability | 27.1% (16/59) | finish-intent committed items marked Done ÷ all finish-intent committed items | 16/59 | Open denominator JQL |
| Progress predictability | 81.8% (9/11) | progress-intent items that carried as intended ÷ all progress-intent committed items | 9/11 | Open denominator JQL |
| Added-during-sprint load | 31.7% (33/104) | visible items absent from planning and present in review ÷ all visible sprint items | 33/104 | Open denominator JQL |
| Added work closure | 25/33 | added visible items marked Done ÷ all added visible items | 25/33 | Open denominator JQL |
| Planning quality | 38.0% (27/71) | committed items marked Ready in planning snapshot ÷ all committed items | 27/71 | Open denominator JQL |
| Carryovers marked Ready | 30.2% (16/53) | carryovers that were marked Ready in planning snapshot ÷ all carryovers | 16/53 | Open denominator JQL |
| Reactive load | 46.5% (20/43) | completed bugs ÷ all completed work | 20/43 | Open denominator JQL |
| Workflow-truth mismatches | 2 | Done rows with non-final workflow status | 2/43 | Open denominator JQL |
Planning-baseline carryover includes both finish-intent misses and expected Progress continuations. Use Finish-intent carryover when you want only planned-to-finish items that did not finish.
| Artifact | Link |
|---|---|
| Issue audit register | Open issue-level audit CSV |
| Metric lineage | Open metric lineage CSV |
| JQL traceability register | Open JQL traceability CSV |
| Sprint metrics JSON | Open sprint metrics JSON |
These companion artifacts keep the pulse debuggable when a leader wants the exact rows behind a metric or a count.