Follow

How to read the work order insights report for closed work orders

Work order insights includes 2 main reports: one for open work orders, and another for work orders that are closed.

Once you've signed up, you'll receive these reports via email, along with a CSV file that contains more detailed information about each work order, including its field values, the expected field values, and all the risks we identified.

The reports have a similar layout, but contain slightly different information. This article describes the information in the report for closed work orders:

The Work Order Insights report for closed work orders, with key data highlighted. This data is covered in the sections below.

The report has the following sections:

Use the link above to jump to a specific section, or keep reading to learn more about the report as a whole.

To learn about the report for open work orders, see How to read the work order insights report for open work orders. To learn more about the data included in these reports and in the CSV file, see Data dictionary for work order insights.

Header section

This section includes the following pieces of information:

  • The reporting period

  • An indication of whether you're viewing the report for closed or open work orders

  • The number of work orders that were analyzed as part of this report

The header section from the work order insights report.

Risk Level section

In this section, you can view high-level information about the work orders at each risk level:

The risk level section of the work order insights report.

The section is divided into 3 rows that correspond to the 3 risk levels: high, medium, and low. In the far left column, we indicate the percentage of work orders at that risk level.

For each risk level, we include the following information:

Column

Description

Work orders

The number of work orders at that risk level.

Excess duration

The total number of days work order at that risk level took, beyond what we expected.

Excess duration is calculated by subtracting how long we expected a work order to take from how long it actually took. We then add up these values to get the total excess duration for that risk level.

Excess failures

The total number of maintenance-based failures (i.e. failures that we have detected were caused by maintenance work) at that risk level.

We detect excess failures by comparing the time before this failure to the MTBF. If this failure occurred in a shorter time period than the MTBF, we consider it an excess failure.

Most common risk

The most common risk identified for work orders at this risk level.

Site Health section

In this section, you can get an overview of each site's health:

The site health section of the work order insights report.

This section shows high-level data by site, including how many work orders at each site are at each risk level, and what the most common risk is at each site.

Sites are listed in separate rows, along with the following information:

Column

Description

Site

The name of that site.

High

The total number of high-risk work orders at that site.

Medium

The total number of medium-risk work orders at that site.

Low

The total number of low-risk work orders at that site.

Excess duration

The total number of excess days work took at that site. This is similar to the excess duration in the Risk Level section, but totaled up at the site level, rather than the risk level.

Excess failures

The total number of excess failures at that site. This is similar to the excess failures in the Risk Level section, but totaled up at the site level, rather than the risk level.

Most common risk

The most common risk identified for work orders at this site. For a full list of the risks we identify, see Risks identified in work order insights.

High Risk Work Orders section

In this section, you can view information about your high-risk work orders. The section is divided by site:

A site sub-section in the High Risk Work Orders section.

Each high-risk work order for that site is listed in its own row, along with the following information:

Column

Description

Code

The work order's unique identifier from the CMMS.

If you're logged in to the CMMS, you can click the code to navigate directly to the work order.

Note: If you click the link and the application displays the navigation menu with a blank, grey space where the work order should be, it means that the work order was deleted.

Description

The work order’s description from the Summary of Issue field CMMS.

Risk score

A number between 0-1000 that represents the relative risk of that work order. High-risk work orders have a risk score of 666 or higher.

Risk

The primary reason this work order was flagged as a risk. To learn more about risks, see Risks identified in work order insights.

Duration days (*)

The total number of days this work order has been open, with the expected duration (based on similar work orders) in brackets.

For example, “97 (33)” would mean that a work order has been open for 97 days, when similar work orders only took 33 days.

Delay days (*)

The total number of days this work order was overdue (past the suggested completion date), with the expected delay (based on similar work orders) in brackets.

For example, “6 (1)” would mean that a work order has been delayed by 6 days, when similar work orders were only delayed by 1 day.

Was this article helpful?
0 out of 0 found this helpful

Comments