Adding a Sprint Attainment Widget

Owned by YoungIn Attucks
Last updated: Jun 19, 2024 by Graham Langdon
4 min read

*Note: This widget may be behind a feature flag for your org. Please reach out to your Customer Success Manager if you don’t see it.

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

  • 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

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

 

 

Widget View and Calculations

The Attainment With Scope Changes widget displays the following details:

 

  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)

 

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

 

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

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 }