Sprint status

About this report

The sprint status report displays the overall progress of the sprint at the task level, providing a visual status of the stories, as well as acceptance criteria and a breakdown of task completion. 

The chart is especially useful to both Scrum Masters and product owners, who are seeking an unobtrusive approach to appraising the status of the team mid-sprint without the need to interrupt valuable work. This report may also be beneficial as a tool during daily stand-ups or during sprint review meetings as a mechanism for discussion.

To navigate to this report:

1. Select Teams in the top navigation bar and select the team you want to view information about.
2. Select Reports in the list of options.
3. Select Sprint status; the sprint status report displays.

Each row of the report is comprised of two sections, with first being a row containing hyperlinked story names, allowing access to the story details, followed by an icon with a link to story comments.

The second row of each story section, contains the value point(s) and effort point(s) expended in the sprint as well as the Estimated Total Hours / Actual Hour(s) spent over the sprint duration. Next in the row are two progress bars, colored green, red, yellow or gray indicating status. (Green 100%, Yellow<75%, Red <25% or Gray- no status).

Stories that have been split during the selected sprint will have the word SPLIT displayed in lieu of Value Points or Effort Points. (See Screenshot below.) The second half of the split story in the next sprint will have the Value Points and Effort Point displayed.

Hovering over either of the two progress bars will reveal the count and percent complete for the development and testing tasks respectively.

At the end of these progress bars are 5 icons displaying story health, acceptance criteria, Dev Complete status, Test Complete Status and Product Owner Acceptance. Hovering over the fuel bar for story health will show a percentage of health for the story. Hovering over the second icon displays the percentage of acceptance criteria complete. The third fourth and fifth icons change color to reveal their status of each key state of the story progression.  Dev Complete, Test Complete and Accepted. These are colored either yellow(incomplete) or green(complete). These icons also offer tooltips showing who accepted the story.

Prerequisites

1. PI must exist in the system, and be tied to a program. 
2. Features must be created and tied to the PI.
3. Stories, with point values, must be created and tied to features.
4. Stories must be assigned to the selected sprint. 
5. Stories must be detailed to the task level in order to drive the progress bars.

How are report values calculated? 

1. Value Points = Level of Value captured during planning
2. Effort Points = Story Points assigned to story during planning 
3. Hours = Sum of Development Hours / Sum of QA Hours - all time rounded to nearest whole hour 
4. Development Tasks Complete % = Count of Complete Story Tasks / Count of Total Story Tasks
5. Testing Tasks Complete % = Count of Complete Testing Tasks / Count of Total Testing Tasks
6. Sprint Health % = Color set based on number of defects per sprint.  This value is configurable by the system administrator.
7. Acceptance Criteria Complete % = Number of acceptance criteria created / number accepted
8. Dev Complete = reflects Dev Complete flag set
9. Test Complete = reflects Test Complete flag set 
10. Accepted = reflects Product Owner acceptance of story

Notes: 

1. Effort and value points for a story are credited on the day the story is accepted. 

How to interpret this report

This report is a quick way to appraise the status of the team mid-sprint, provided that the teams are tasking out stories. Progress bars for both development and test activity allow for quick assessment of each story, with effort points and hour(s) being useful in assessing the scale of the work to be accomplished.

If used during the daily stand-up, development and test completion as well as PO Acceptance can be captured here, by clicking the appropriate colored ellipses on the right side of the report. These will toggle from yellow to green.

Bars will remain gray until 25% of development and/or Test Tasks have been completed, at which point they will move to yellow. Only when 100% of development Tasks or Test Tasks are Complete will the bars turn green.

This chart when used in conjunction with the Effort Points burndown report may be useful to compare against or to assess story progress against sprint completion.