Sprint Attainment Widget

Sprint Attainment Widget

This article explains Sprint Attainment widgets and walks you through adding them to a dashboard:

image-20240311-164815.png

There are two versions of Sprint Attainment in Allstacks:

  • Sprint Attainment

    • Shows the average completion rate of work committed to a sprint when each sprint started

  • Sprint Attainment with Scope changes

    • Shows the ratio of Committed, Completed, Added, and Removed work

How to Add a Sprint Widget to a Dashboard:

To add, click on the image-20240311-142750.png icon and select ‘Add Attainment’:

image-20240311-142658.png

Select the desired settings for Jira or ADO:

JIRA

Important for understanding how sprints appear in Allstacks.

In Jira, every sprint has an originBoardId—this is the board where the sprint was originally created. However, Jira can also link a single sprint to multiple boards through a field called all_board_ids. That means a sprint can show up on boards it wasn't created on, depending on how it's shared across teams.

This setup isn’t always visible to customers in Jira, but it becomes noticeable in Allstacks when creating widgets like Sprint Attainment. You might see sprints missing that you expect to be there—or see extra ones from other teams—because of this multi-board association.

  • Source: Jira

  • Measured by: Story Points or Issue Count

  • Widget Type:

    • select ‘Attainment with scope changes’ for the comprehensive view (Added, Removed, etc.)

    • or the ‘Attainment’ option for a simpler Committed vs. Completed ratio

  • Jira Project: select the appropriate Jira project/board

image-20240311-143254.png

ADO

  • Source:

    • Select: ADO

  • Measured by:

    • Select: Story Points or Issue Count

  • Widget Type:

    • Select: Attainment with Scope Changes or Attainment

  • Iteration Depth:

    • Select a level of depth from the Parent Sprint (or as ADO calls it “Iteration) to look for this team’s iterations

  • ADO Parent Sprint:

    • Select the Iteration Path that contains the iterations that belong to this team

  • Scope To:

    • Select the Area Path the team works within

 

image-20240311-143825.png

 

Widget View and Calculations

The Attainment With Scope Changes widget displays the following details:

 

image-20240311-165046.png
  1. Blue = Committed

  2. Grey above blue= Added

  3. Purple = Completed

  4. Grey above purple = Removed and rolled over

  5. Percentage = (Completed of Committed + Completed of Added) / (Committed + Added Committed)

 

Clicking on the widget expands to a ‘modal’ view where you’ll see the ratios per sprint

image-20240311-164901.png

 

Clicking on this icon will allow you to download a CSV of the attainment source data:

image-20240311-165849.png

Calculation Details:

Below is a set of sample attainment data for two sprints.

[ { 'sprint_name': 'sprint 1', 'committed': 5, 'added': 2, 'completed': 3, # completed 2 of added, 1 of committed 'incomplete': 4 # removed 1 of committed, did not complete 3 of committed }, { 'sprint_name': 'sprint 2', 'committed': 8, 'added': 3, 'completed': 7, # completed 2 of added, 1 of committed 'incomplete': 4 # removed 1 of committed, did not complete 3 of committed } ]

The Sprint Attainment with Scope Changes widget is doing a rollup view that takes the average of ratios for these 2 sprints.

{ 'sprint_name': 'sprint 1', 'commited': ((5/7) + (8/11)) /2, 'completed': ((3/7) + (7/11)) / 2, 'committed_completed_ratio': ((3/5) + (7/8))/2 }