Skip to main content
Skip table of contents

Working with Columns

Structure columns allow you to view key information about your work items at a glance. You can customize the information that is available by adding new columns or changing the arrangement of your columns.

Structure with several columns

By default, the following columns are visible in a structure:

  • Summary - Displays the work item summary. This is also where your work item hierarchy is visible – the summary for child work items is indented relative to their parent work items.

  • Key - Displays the work item key.

  • Progress - Displays work item progress based on time tracking, and aggregates that progress up the hierarchy.

You can add additional columns to visualize data for your project. The following column types are available:

  • Progress - Display an aggregate work item progress, which is calculated based on values from the work item and its sub-work items.

  • Formula - Perform calculations or comparisons based on work item fields or other attributes.

  • Number - Create and track custom numeric values.

  • Text - Create and track custom text values.

  • Date - Create and track custom date values.

  • Time in Status - Track how much time work items spend in a particular status.

  • Test Run - Build custom testing solutions.

  • Other Structure Fields - Data related to the structure hierarchy, such as Count Leaves, Row ID, and Sequential Index.

  • Jira fields - Track and aggregate values from Jira fields.

  • Tempo fields - Manage values from other Tempo products, including Tempo Work Logged, Tempo Planned Time, Tempo Accounts, and Tempo Teams

To learn more about the available columns, see Adding Columns.

Adding Columns

To add new columns, click the sign to the far right of the column headers.

Adding a column

Sorting by Columns

To quickly sort items in a structure, click the header of the column you want to sort and choose the sort order you prefer. Your structure will be sorted on every level.

Column dropdown menu with Sort options highlighted

Sorting by column makes a temporary, local adjustment to the structure, without changing it for everyone else. If someone opens the same structure while you have a column sort applied, they will still see items in their original order.

Sum over sub-items

The Sum over sub-items option allows you to aggregate values within a column based on the value of sub-items. In the example below, the Σ Remaining Estimate value for Epic 3 is the total of its sub-work items' Remaining Estimates.

Aggregate columns.png

To show aggregate values for a column, click the column header, select Edit column, and check the Sum over sub-items box. Sum over sub-items is only available when an aggregate value is available: numbers, durations, and formulas.

When using sum over sub-items:

  • When an aggregate value is displayed for a work item that also has its own value in the field, its own value is displayed next to the aggregate value in gray (see Story 2 above).

  • Since work items can be present multiple times in a structure, you can select whether you want to count every instance of a work item or count it just once. By default, duplicates are counted each time they appear. To exclude them, select Exclude Duplicates in the column options.

Next Steps

Next, we'll look at how to edit work items from within a structure.

Editing Work Items in Structure

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.