Reports User Guide for Release 3.2

This guide will help you understand the reporting related features of the ScrumWorks Pro Desktop Client. The information contained within this guide is designed to give you in-depth knowledge of how these features work so that you may use them to their full potential.

Quick Links
Product Progress Report Product Burndown Sprint Change Report Earned Business Value Change Log

ScrumWorks Pro Desktop Client User Guide
Documentation Home

Product Progress Report

Overview
The Product Progress Report shows the status of releases across products selected for inclusion in the report. When a product is selected to appear in the Product Progress Report, the progress against the work allocated to the release is superimposed on a chronological representation of releases (as indicated by the release begin and end dates).


Work progress is measured in "Product Backlog Effort units". For example, a progress bar that shows "217/274 (79%)" means that of 274 Product Backlog effort units currently scheduled for inclusion in the release, 217 have been marked "Done". This means that 79% of the currently scheduled work has been completed by the team.

The work progress is then superimposed on a chronological schedule. If the release is currently active (i.e., today's date is between the begin and end dates associated with the release) a red line will indicate "Today". Thus the work progress can be seen in clear relation to the proposed schedule.

This report updates itself each time there is a change to the system. In Scrum, changes are accepted as a normal occurance in project work. If the release dates, total backlog effort points or number of points marked "Done" change, then the Product Progress Report will mirror the changes automatically.


» top

Settings


A release must have an associated beginning and ending date to show up in the Product Progress Report. Two date fields are supplied for creating a Product Progress Report: a start date and an end date.

Releases occurring in this range are included in the report. The release doesn't have to be entirely contained within the dates; any release that overlaps the date range selected will be included in the report.

In ScrumWorks Pro, begin and end dates associated with releases imply a schedule. The Warning Level lets users customize how releases that are behind schedule appear. When a release is behind schedule, the color of the progress bar can be either yellow or red, and the Warning Level dictates whether red or yellow is displayed. The Warning Level is the threshold above which ScrumWorks Pro displays a red bar to indicate that the release is behind schedule by a percentage greater than or equal to the Warning Level value. For example, if the Warning Level is set to 10%, the progress bar for the release will be yellow if the project is only 5% behind schedule but red if the project is 11% behind schedule.

Required Permissions: View Product Progress, Sprint Change, Product/Release Burndown Reports


» top

Preview


The Product Progress Report is accessed as a PDF file; however, a preview is available before the final PDF is published. To preview a report:
  1. In the left pane, select all Products for inclusion in the report.
  2. Then adjust the Date and Warning Level settings as desired.
  3. Click the Generate button to see a preview of the Product Progress Report.
Required Permissions: View Product Progress, Sprint Change, Product/Release Burndown Reports


» top

Launch
Once satisfied with the preview, click the Launch button to generate the actual report in PDF format. Take note of the URL associated to the report. The URL is accessible from outside of ScrumWorks Pro and is a convenient way to reference the report at a later time or to share the report via email. For convenience, the Report URL is accessible directly without the need to log into ScrumWorks Pro. As a result, be sure to keep the Report URL private if privacy is a concern.

Required Permissions: View Product Progress, Sprint Change, Product/Release Burndown Reports


» top



Product Burndown

The product burndown chart shows how much work is left to do in the product. It shows the amount of backlog effort remaining at the beginning of each Sprint. There is a basic product burndown chart and an enhanced product burndown chart available in ScrumWorks Pro.

Basic Product Burndown
This is a product burndown chart as defined by page 11 of Agile Project Management with Scrum.

Here is an example of the basic product burndown chart:

Basic Product Burndown Example

Each bar represents the amount of product backlog remaining on the first day of the Sprint. For each selected release, the product backlog consists of all uncommitted backlog items for that release and all committed backlog items in sprints in that release.

Each backlog item maintains its own effort history, recording entries as the backlog item is re-estimated over time. This historical view of each backlog item is used to calculate the total effort remaining on the first day of each sprint.

Backlog items committed to sprints can be marked "Done". This indicates to the product burndown that this backlog item's effort is now considered as work that is done; work that has been burned. This effort is then excluded from the total effort remaining and causes the sprint bar heights to decrease. Bar heights can also go down if backlog items are re-estimated at a lower effort value. The bars increase in height when new backlog items are added or existing backlog items are re-estimated at an increase.

Data for sprints ending within one week of each other are merged into one bar. This is especially useful when multiple teams are working from the same product backlog. It helps give a more accurate (and less crowded) picture of the work being done.

Required Permissions: View Product Progress, Sprint Change, Product/Release Burndown Reports


» top

Enhanced Product Burndown
This chart distinguishes between work completed and work added/removed. This can help forecast product completion. The Velocity Trendline shows the rate at which work is completed. The Work Added/Removed Trendline shows the trend of commitment change and backlog re-estimation. A new baseline is drawn as a result of work added or removed through the last completed sprint. If work is completed faster than it's added, ScrumWorks Pro can estimate how many sprints it will take to complete the product.

Here is an example of the enhanced product burndown chart:

Enhanced Product Burndown Example

This chart shows that if the current trends continue, project completion is forecast in 1-5 sprints.

The bar high positions on this chart are plotted by subtracting the amount of backlog burned during the prior Sprint. Each subsequent Sprint bar high position will either go down or stay flat, but never go up.

The lower portions extending below the previous Sprint's low position denote new backlog items added or additional effort as a result of re-estimation. The low bar position can also go up from the previous sprint. This happens when the total effort decreases, either through the removal of product backlog or a decrease caused by re-estimation of existing backlog items.

Data for sprints ending within one week of each other are merged into one bar. This is especially useful when multiple teams are working from the same product backlog. It helps give a more accurate (and less crowded) picture of the work being done.


Options for Enhanced Product Burndown Charts

In the Enhanced Chart Options tab, two Velocity Trendlines and various Velocity Projections are offered. Either trendline may be selected and specified in combination with any of the available Velocity Projections, offering a highly customizable chart. When the option for Completion Forecasts is checked, any specified trendlines and projections that will intersect in a reasonable amount of time with the Work Added/Removed Trendline will be extended to those points, and the chart will expand in scale to display the intersections. If no specified trendlines and projections will intersect with the Work Added/Removed Trendline, no completion forecast is possible and will not be displayed.

Required Permissions: View Product Progress, Sprint Change, Product/Release Burndown Reports


» top

Release Selection
Use the release selection to specify which releases are used for the product burndown. For each selected release the burndown charts will sum the following:
  1. Effort for all uncommitted backlog items in the release

  2. Effort for committed backlog items in sprints within the release
Select the Build Chart button to re-display the chart using the selected releases.

Required Permissions: View Product Progress, Sprint Change, Product/Release Burndown Reports


» top

Themes Filtering
Use the Filter chart by Themes feature to filter the Product Burndown for only those Backlog Items assigned with particular Themes.
  1. In the Themes subsection of the Releases & Themes tab, click the checkbox for "Filter chart by Themes"

  2. A Themes Filter dialog appears offering checkboxes for all Themes that exist in the Product. By default, all options are selected.

  3. Check all Themes you wish to include in the Burndown chart, and uncheck those Themes you wish to exclude from representation in the Burndown chart. Note the checkbox "(no Theme assignment)" for Backlog Items that do not have a Theme assignment. Checking this box includes in the chart any Backlog Items that have no Theme assignment.

Select the Build Chart button to re-display the chart using the selected Themes.

Required Permissions: View Product Progress, Sprint Change, Product/Release Burndown Reports


» top

Active Sprints
An active sprint is where the current date falls within that Sprint's begin and end dates. Any currently active sprints are not included in any trendline calculations. New baselines are drawn using the last completed Sprint.

» top

Marking Backlog Items Done
To show that work has been completed use the backlog editor to mark individual backlog items as "Done". The product burndown chart uses this information to draw the height of each of the sprint bars and to calculate the velocity.

Required Permissions: Mark Product Backlog Item as Done


» top

Backlog Item Effort History and Creation Dates
The current product effort remaining on the first day of each sprint is the value used to draw the height of each of the sprint bars. Sometimes a backlog item will be created after the start date of the sprint for which this backlog item belongs. You can adjust the creation date of this backlog item so that it impacts the current sprint, backdating the backlog item. Edit the first entry in the backlog item's estimate history to the first day of the Sprint you want it to impact. This allows for a more precise graphical representation within the product burndown.

Please see Edit Product Backlog Item Estimate History for more details on editing backlog item estimate history.

Required Permissions: "Product Backlog Items" > "Edit Historical Estimates"


» top

References and Links to Further Reading
The product/release burndown in ScrumWorks Pro is inspired by Mike Cohn's Alternative Release Burndown Chart


» top



Sprint Change Report

Overview
This report summarizes changes to the outstanding backlog including work completed this sprint, work added/removed from the product backlog, and how re-estimation affected the product backlog.

Required Permissions: View Product Progress, Sprint Change, Product/Release Burndown Reports


» top

Accessing
You can open the Sprint Change Report in one of two ways:
  1. Click "Reports" -> "Sprint Change Report"
  2. Open a Basic or Enhanced Product Burndown chart and select the "Sprint Change Report" tab
This presents you with a clickable chart. Single clicking a bar selects the sprint and gives you a URL that contains your report. Double clicking the bar opens your report.



Required Permissions: View Product Progress, Sprint Change, Product/Release Burndown Reports


» top

Format
The Sprint Change report is exported as an Excel spreadsheet file. Once exported, the report can be manipulated as desired. The report is divided into two sides. The left side of the report (with green headings) lists all activity that lowered the product's Backlog Effort points. The right side (maroon heading) indicates all activity that increased the product's Backlog Effort points.

Change Report Overview



» top



Earned Business Value

Earned Business Value Report
Examining the rate at which Business Value is completed over time is a useful progress reporting alternative to effort burndown reports. The Earned Business Value Report shows the rate at which business value is being completed or 'earned' per Program or Group. Business Value is "earned" when a Product Backlog Item that has been categorized into the reported upon Group/Program is marked "Done". For more on Programs, Groups, and Business Value, please see the Programs and Groups Overview in the Desktop Client User Guide.

The y-axis denotes the total business value of the Group or Program being reported upon in percentage format. The x-axis denotes chronological time. Therefore, this report shows rate at which Business Value is being delivered over time as restricted by the Program or Group selected.

In order to emphasize completion of business value in the current Group or Program rather than historical changes to the Program/Group structure, the report assumes that the selected Program or Group and its nesting structure existed in its current form when its oldest associated Backlog Item was created. That is, when the report is created, Backlog Items (and their business value) are graphed as if they always belonged to their current Groups.

To generate a report on a Program or Group:
  1. Open the Program on which you'd like to run a report

  2. From the "Reports" main menu dropdown, select "Earned Business Value Report"

  3. In the resultant dialog, specifications and optional displays for the report are entered in the tabs at left, and a preview of the graph is shown at right. Below the graph is a box showing a URL that can be used to remotely view the report from a web browser.

  4. In the Program/Group tab, specify the following:

    1. Date Range (x-axis): Specify the date range represented on the x-axis by selecting the start date for the graph. The end date will always be the current date.

    2. Program/Group: Select the entire Program or a specific Group to be graphed. 100% will equal the entire Business Value of all nested Groups and Backlog Items contained by your selection.

      Note, changes to Groups or Group structure in the Program Navigator window will not be reflected in an open report window until the report window is closed and re-opened.

  5. In the Display Options tab, choose from the following options:

    1. Display Completion Threshold on Graph (y-axis): The Completion Threshold represents the level of earned business value at which it may be acceptable to release the feature set in question. It is most often the case in Agile development that less than 100% of all defined business value of a feature set is delivered in the first (or even second, third, etc.) iteration of development. Robustness enhancements that produce diminishing returns are often left for future iterations of a feature.

      Select this option to indicate on the graph a level along the y-axis that represents a specified percentage of completed Business Value. Enter a desired value for this thershold. The threshold will be indicated by a gray background on the generated chart.

    2. Display Completion Trendline: Select this option to include on the graph a line that indicates the average rate of completion of Business Value.

      Note, the trendline is impacted by the start date indicated in the Date Range. The start date selected changes the data points displayed and the resulting trendline through those data points. For example, to trend only the most current data points, use a start date that reflects only the desired data points.

    3. Forecast Completion: Select this option to extend a burn-up trendline to 100% of Business Value completed, based on the average rate of completion. Note, the Forecast Completion option will extend the trendline through the Completion Threshold all the way to 100% even if the Completion Threshold is set below 100%.

  6. Click the "Generate Report" button below the tabbed section at any time to update the graphed data displayed at right with changes you've made.

  7. The most currently updated graph may be viewed by stakeholders from outside the desktop client at the path displayed in the Report URL box. Click the "Open Report URL" button to view the graph in a web browser. Note, this URL is not protected by authentication and can be viewed by anyone with knowledge of the URL.


» top



Change Log

The Change Log displays changes made to Backlog Items and Tasks, within the Product in focus. It is accessed from the main menu under Reports > Change Log. Users can only see changes to features for which they have at least "View" permission. For example, if a user does not have access to view Business Weight information, changes to Business Weight will be omitted from that user's view of the Change Log.
Change Log View Selector
The View selector allows the Change Log display to be toggled between types of changes: Backlog Items or Tasks. If you don't have permission to view Tasks, the chooser will be disabled and only changes to Backlog Items will be available.

» top

Time Period Filter
You can change the amount of data shown by selecting the time period at the top of the window. By default, the changes made in the last one day are shown. The maximum amount of data that can be shown is 60 hours or 60 days.

Note that for large date ranges it may take a long time to retrieve and display the data.


» top

Backlog Item Changes Tracked
The following changes are tracked:
  • Created Backlog Items

  • Deleted Backlog Items

  • Changes to Backlog Items:

    • Title
    • Description
    • Estimate
    • Estimate History
    • Business Weight
    • Status
    • Release
    • Sprint
    • Priority
    • Themes
    • Attachments

  • Date and time the change was made

  • User who made the change



» top

Task Changes Tracked
The following changes are tracked:
  • Created Tasks

  • Deleted Tasks

  • Changes to Tasks:

    • Title
    • Description
    • Estimate
    • Estimate History
    • Status
    • Backlog Item
    • Priority

  • Date and time the change was made

  • User who made the change



» top

Sorting the Change Log
The default sort order is reverse chronological. The latest changes are at the top of the Change Log.

The Change Log can be sorted by "Key", "Title", "Date/Time", or "Username" (the user who effected the change). Note, the "Event" column is not sortable because change log entries may span multiple event types (e.g., description and title). To sort by multiple columns, hold the control key and click the second column header.


» top

Filtering the Change Log
The Change Log can be filtered by clicking on the arrow in any of the following columns: "Key", "Title", "Event", and "Username". Any of these columns may be filtered by one or more available entries by checking the appropriate box. After confirming the selection by clicking "OK", only the changes matching the selected criteria are displayed. Double-clicking the row for an entry at once selects and applies a filter for only that entry and closes the filter dropdown.

» top

Refresh the Change Log
The Change Log does not automatically refresh. To get the latest data, click the "Refresh" button at the top right corner of the window.

» top