Display rollup progress or totals

Azure Boards | Azure DevOps Server 2020

Rollup columns allow you to view progress bars or totals of numeric fields or descendant items within a hierarchy. Descendant items correspond to all child items within the hierarchy. You can add one or more rollup columns to a product or portfolio backlog. For information on linking work items in a hierarchy, see Linking, traceability, and managing dependencies, Parent-child work item links.

For example, here we show Progress by Work Items which displays progress bars for ascendant work items based on the percentage of descendant items that have been closed. Descendant items for Epics includes all child Features and their child or grand-child work items. Descendant items for Features includes all child User Stories and their child work items.

Progress bars showing rollup by work items

Important

Rollup data supports progress or counts within a project. Child items that link to a different project aren't counted within the parent rollup calculations.

Rollup and hierarchical work items

The default set of backlog work items which support a natural hierarchical grouping varies depending on the process chosen for your project. The easiest way to group work items into a hierarchy is by mapping them, or adding them to the parent item on a Kanban board. To learn more, see Organize your backlog, map child work items to parents and Kanban board features and epics.

The following image shows the Agile process backlog work item hierarchy. Each team can configure how they manage bugs—at the same level as User Stories or Tasks— by configuring the Working with bugs setting.

Agile process hierarchy, conceptual image

Open a product or portfolio backlog

Each user can set their own column options which persist for each backlog across the user's sessions.

  1. Open a product or portfolio backlog. Optionally, enable Show parents from your view options. Note that even if child items aren't listed, rollup for them displays.

    Tip

    Consider opening a portfolio backlog and choose to view In Progress Items and Completed Child Items. That way, you can check the State value of items against the rollup value.

    Open column options

  2. Choose Column options, or choose the actions icon and then select Column options.

    Open column options

    Tip

    Remember that the Column options you choose are for the selected backlog level. They persist across your sessions until you change them.

Add a rollup column

  1. In the Column options dialog, choose Add a rollup column, select From quick list, and then choose from one of the options listed.

    Column options dialog

    Note

    The menu options vary depending on the process chosen for your project, the backlog level you've selected, and whether or not you have the Show parents view option enabled.

  2. Choose from the menu provided.

    • Progress bar displays progress bars based on the percentage of associated descendant work items which have been completed or closed.
    • Total number displays the sum of descendant items or the associated fields of descendant items. Totals provide a measure of the size of a Feature or Epic based on the number of its child items. For example, Count of Tasks shows the sum of all tasks that are linked to parent items. The active or closed state is ignored.

    Rollup column menu

    For example, the following image shows the Count of Tasks for the parent user stories is 2 and 4, respectively. The Count of Tasks is 6 for the parent Feature and Epic.

    Count of tasks

  3. Remaining Work of Tasks shows the sum of Remaining Work of tasks that are linked to the parent item.

    Sum of Remaining Work

    Tip

    Reminder that when a task is closed, the Remaining Work field is set to zero.

Analytics, latency, and error states

Rollup data is calculated from the Analytics service. When there is a large amount of data, it's possible to experience some latency in displaying rollup. If you hover over the rollup icon, you can determine the state of the data.

If an error occurs in retrieving rollup data, you'll see an info icon and empty rows. Errors indicate when the Analytics data was last updated. This means that the Analytics services is still processing changes made which may affect rollup calculations. Once the Analytics data is up-to-date, the rollup columns will refresh with the latest data.

Error getting data

To learn more about the service, see What is Analytics?.

Change the column order or remove a rollup column

To change the order of the fields, drag-and-drop the field where you want it within the set of selected fields. And, to remove a field, choose the delete icon.

Rollup of custom work item types or custom fields

If you add a custom work item type or field to a backlog level, you can view rollup based on those options. For example, the Customer Request type is added to the Requirements category, and a Count of Customer Requests is shown in the following image.

Count of Customer Requests, custom work item type

  1. From the Column options dialog, choose Add a rollup column, select Configure custom rollup option.

  2. Choose the options you want from the Custom Rollup column dialog.

    Custom Rollup column dialog

  3. Choose OK. and then OK to complete your operations..

    Tip

    If you add custom fields or custom work item types, you must refresh the backlog page to reflect your changes.

Use keyboard shortcuts to change the column order, column width, or sort options

You can change the column order, column size, or sort options by using the following keyboard commands:

  • To change the column order, click the field and drag it to a new location
  • To re-size a column, choose the column divider to the right of the field and drag to a new location