Cycle Time by Location Report

See how long it takes each Location's Items to pass through their lifecycle.

The Cycle Time by Location Report lets you see the average time it takes for a Location's Items to be completed and how long they remain in each status.

Example of Cycle Time by Location Report. For each Location, you can see the average number of days the Location's Items spent in their total lifespan and in specific Statuses. 

Who can access this Report?

Anyone with the "View Report Data" permission will be able to see this Report.

This Report can be accessed under the Activity section of the Reports page. It can also be added as a Card on a Board.

Working with the Report

• Understand the data
• Use filters to control which data are referenced by the Report
• Customize the Report's columns
• See a List of Items referenced by the Report
• Export the Report

The data

This Report displays the total amount of time a Location's Items take to be completed, the amount of time its Items are considered "in progress," and the amount of time its Items spend in each status. For this Report:

• Total: Represents the average time a Location's Items take to go from the New to the Completed status, including the time spent in the Planned and Deferred statuses, but not the Draft status.
• In Progress: Represents the average time a Location's Items take to go from the New to the Completed status, not including the time spent in the Planned, Deferred, or Draft statuses.

This Report can tell you a lot about the health of your improvement culture:

• People in Locations that take significantly longer to complete Items or whose Items spend a long time in the Overdue status may need additional coaching or may need help deligating their work.
• Locations with Items that spend a long time in the New or Resolution Submitted status be experiencing a bottleneck. The team leader or manager may need additional coaching.

The filters

Any relevant filters in use on the main Reports screen will be automatically applied to this Report but can still be configured as needed.

• There are two date-based drop-downs. First is the "Reference Date" drop-down and second is the "Range" drop-down.
  
  • Reference Date: Expand the drop-down to choose which type of date should be referenced by the Report. For example, select "Created in" if you want the Report to reference only those Items that were created in the specified date range.
  • Range: Expand the drop-down to choose the range of dates that should be included in the Report.
    • All Time removes any date range parameters. 
    • Custom allows you to enter any date range you want. 
    • Past shows you a rolling date range that counts back from the current calendar date. 
    • Current shows you data for the current week, month, quarter, or year. 
    • Last shows you data for the previous week, month, quarter, or year. 

• Workflow: Expand the drop-down to choose which workflows should be included in the Report.
• Template: Expand the drop-down to choose which Templates should be included in the Report.
• Select Originating, Responsible, or Impact to decide whether the Report should reference Items from the Originating, Responsible, or Impact Location. 
  
  • Originating and Responsible will be the default selection.
  • If Impact is selected, both Originating and Responsible will be toggled off. 

• • If no Location is selected in the Location Filter or Item Filter, the Originating, Responsible, and Impact toggles will not affect Report data. 

• Click the filter icon and the Item Filter window will open.
  
  
  • Update the item filters to control which Items are included in the Report's metrics.
  • Click Save.

• Click the Locations panel on the left side of the Report to expand it.
  
  • Filter the Report by Location and only Items tied to the selected Locations will be included in the Report.
• Level Type: Expand the drop-down to choose the types of Locations that should be listed in the Report.

Customize the Report's columns

By default, your report will have columns for Location, Total, In Progress, and the primary Status for every Status Type except for Draft and Complete. However, you can add and remove columns depending on which data you're interested in. 

To customize the columns on your report:

• Hover over the header of an existing column on your Report. 
• Select the drop-down arrow. 
• Hover over Columns to see the available columns.
  • Select the checkbox next to a column to include it in your Report. 
  • De-select the checkbox next to a column to remove it from your Report. 
  • Each Item Status column can include Avg Days and # secondary columns. Hover over the name of a primary column to see the secondary column options. 

See a list of Items referenced by the Report

Select any metric in the Report to open a list of Items contributing to that data point.

 

The Item List will include a "Days in Status" column that displays each Item's individual contribution to the average. This makes it easy to identify outliers and take action. 

Share the Report

To share the Report, select the ellipsis icon. In the resulting drop-down menu, you can export the Report as a PDF, download it as an XLSX file, or copy it to a Board. 

• Select Print/Save PDF to export the Report as a PDF. The "Print" window will open.
  • Page Size: Expand the drop-down to choose your preferred page size.
  • Scale: Expand the drop-down to choose the scale percentage. This allows you to fit more content on a single page. For example, selecting 50% doubles the amount of content you can fit on one page. Make sure to select "Fit to page" in your browser's print settings.
  • Click either Portrait or Landscape to choose the PDF's orientation.
  • Click Print.

• Select Save XLSX to export the Report as a spreadsheet document. 
• Select Copy to Board to add the Report as a Card on a Board. 
  • In the resulting window, select a Board. All Boards that you have permission to edit will appear as options. 
  • Select Copy to add the Report to your selected Board. All filters and columns included on the Report will be carried over to the Card. 
    • The Report Card will appear at the Board's top left corner.

Cycle Time by Location Report Cards

Cycle Time by Location Reports can also be added as a Card on Boards.

When creating a Cycle Time by Location Report Card, you can use the same filters discussed in this article to build the Report. However, you will have an additional Edit Columns option when the Report is in List view. 

• Edit Columns: Use the Edit Columns window to select which columns appear on the Card when the Report is in List view. These selections will persist the next time you view the Board.

Recommended Reading

Check out the following support page to learn about how Status data is tracked on Items: 

• Status History