How to use the work order insights CSV file

As mentioned in the articles that explain how to read the reports for closed and open work orders, work order insights includes emailed reports and CSV files. Basically, the reports provide the broad strokes that identify risks at a high level, whereas the CSV files allow you to take a deeper dive.

When working with the CSV file, here are some actions you might take:

  • Look at the root cause column to see exactly which work order fields are anomalous.

  • Find the field column in the CSV file and compare the actual results to the expected results. For example, if a work order is associated with the "Task Count" root cause, compare the Tasks column with the Expected Tasks column to see the difference between actual and expected results. You can also open the work order in your CMMS to try to figure out why so many (or so few) were completed.

  • In the case of abnormal failure, we list the work orders that we feel contributed to the failure. These work orders are listed under the Contributing work orders column. You can open these work orders in your CMMS to see if you can identify the issues that caused the asset to fail.

To learn more about the data included in the reports and the CSV file, see Data dictionary for work order insights.

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