Work Orders

The Work Orders dataset lists Work Orders with their counts, hours and costs, for tracking workload, completion and spend.

At a glance

Item Value
Picker heading Data Tables
One row is One Work Order in Detail, or one group in Consolidated
Presentations All
Default presentation Table
Default period Last 30 Days on Scheduled At
Date basis options Scheduled At, Started At, Completed At, Created At
Default columns Work Order Number, Title, Task Type, Asset Number, Started At, Completed At, Asset Description
Group Modes Detail and Consolidated, for tables and charts
Drill-through Select a chart value to open its Work Orders, on all charts except Chart shows Measures

Measures

Measure Unit Aggregation Definition
Work Order Count Work Orders Count Number of Work Orders.
Open Work Orders Work Orders Count Work Orders with status Open.
In Progress Work Orders Work Orders Count Work Orders with status In Progress.
Complete Work Orders (Last 30 Days) Work Orders Count Status Complete and completed in the 30 days before now.
Cancelled Work Orders (Last 30 Days) Work Orders Count Status Cancelled and completed in the 30 days before now.
Work Orders (Status Summary) Work Orders Count The four counts above added together.
Total Expected Duration Hours Hours Sum Sum of each Work Order's Expected Duration Hours.
Total Expected Labour Hours Hours Sum Sum of expected labour hours on cost items.
Total Actual Labour Hours Hours Sum Sum of actual labour hours on cost items.
Total Expected Parts Cost Cost Sum Sum of expected parts cost on cost items.
Total Expected Labour Cost Cost Sum Sum of expected labour cost on cost items.
Total Expected Services Cost Cost Sum Sum of expected services cost on cost items.
Total Expected Cost Cost Sum Expected parts, labour and services cost added together.
Total Actual Parts Cost Cost Sum Sum of actual parts cost on cost items.
Total Actual Labour Cost Cost Sum Sum of actual labour cost on cost items.
Total Actual Services Cost Cost Sum Sum of actual services cost on cost items.
Total Actual Cost Cost Sum Actual parts, labour and services cost added together.

These measures are also the Consolidated table columns, along with Group. The status counts are not shown until you add them.

Columns

These columns are available in Detail tables and View records.

Column Type Description
Work Order Number Text The Work Order's number.
Work Order Numeric Number The numeric part of the Work Order number.
Title Text The Work Order's title.
Description Text The Work Order's description.
External Work Order Number Text The number from an external system.
Parent Work Order Text The parent Work Order's number.
Status Text The Work Order's status.
Custom Status Text The tenant's custom status. Your tenancy may use a different label.
Priority Text The Work Order's priority.
Work Type Text The type of work.
Task Type Text The type of the linked Task.
Task Code Text The Task code.
Task Text The linked Task's name.
Modifier Code Text The modifier code.
Source Text Where the defect was identified.
Source Type Text How the Work Order was created.
Failure Text The failure code.
Cause Text The cause code.
Symptom Text The recorded symptom.
Notes Text Work Order notes.
Breakdown Yes/No Whether this is breakdown work.
Statutory, Compliance Task Yes/No Whether this is compliance work. Both columns read the same value.
Linked Tasks Yes/No Whether the Work Order comes from a Task.
Linked Work Request Yes/No Whether a Work Request is linked.
Overdue Yes/No Open or In Progress with a Due Date in the past.
System Generated Yes/No Whether the system created the Work Order.
Is Modified Yes/No Whether the Work Order was modified.
Locked Yes/No Whether the Work Order is locked.
Potential Warranty Yes/No Whether a warranty claim may apply.
Confirm Completion Yes/No Whether completion must be confirmed.
Job Ready Yes/No Whether the job is ready.
Job Ready By, Job Ready Date, Job Ready Notes Mixed Who marked it ready, when, and any notes.
Asset Number, Asset Description Text The Work Order's Asset.
Asset Class, Asset Group, Asset Type, Manufacturer Text The Asset's classification.
Asset Planning Type, Asset Status, Criticality, Hire Status Text The Asset's planning and operating details.
Asset Department Text The Asset's department.
Project, Customer Text The Asset's Project and Customer.
Department Text The Work Order's own department.
Area Text The Work Order's area.
Organisation Text The organisation.
Cost Responsibility Text Who is responsible for the cost.
Team, Crew Text The assigned team and crew members.
Contractor Name Text The contractor.
Reporting To, Meeting Point Text Site arrangements for the job.
Location Address, GPS Coordinates Text Where the work takes place.
Completed By, Created By, Updated By Text The people who completed, created and last updated it.
Scheduled At, Started At, Completed At, Due Date Date The Work Order's key dates.
Created At, Updated At Date When the record was created and last updated.
Generated From Date Date The date the Work Order was generated from.
Event, Event Start, Event End Mixed The linked Event and its dates.
Expected Duration Hours Number The planned duration.
Expected Labour Hours, Actual Labour Hours Number Labour hours from cost items.
Expected Parts Cost, Expected Labour Cost, Expected Services Cost, Expected Total Cost Number Expected cost from cost items.
Actual Parts Cost, Actual Labour Cost, Actual Services Cost, Actual Total Cost Number Actual cost from cost items.
Purchase Order Numbers Text Purchase Orders linked through parts.
Cycle Group Order Number The order within a Task cycle group.
Ignore Component Life Yes/No Whether component life is ignored.
Component Start Value Number The component's start value.
Removed Component Serial Number, Fitted Component Serial Number, Fitted Component Start Usage Mixed Component changes. Shown only when component serial tracking is on.

Filters

Filter Choice Behaviour
Site or Department Multiple The Asset's department, or else the Area's, or else the Work Order's own.
Asset Department Multiple The Asset's department.
Asset Number Multiple The Work Order's Asset.
Asset Class, Asset Group, Asset Type, Manufacturer Multiple The Asset's classification.
Asset Status, Criticality, Planning Type Multiple The Asset's details.
Hire Status Yes, No, All Whether the Asset is on hire.
Project, Customer Multiple The Asset's Project and Customer.
Task Type, Task Code Multiple The linked Task's type and code.
Team Multiple The assigned team.
Crew Member Multiple Assigned crew. Can follow the person viewing the Dashboard.
Work Order Status Multiple Includes these statuses.
Exclude Work Order Status Multiple Leaves out these statuses.
Custom Status Multiple Needs permission to view Custom Status.
Priority, Source, Area Multiple The Work Order's values.
Scheduled Within One choice Next 24 Hours to Next 180 Days, or a Custom Date Range on Scheduled At.
Actual Within One choice Work Orders active in the range: started by its end and not completed before its start.
Created Within One choice Created in the last 24 Hours to 180 Days, or a Custom Date Range.
Created At One choice Age filter: created at least 7, 30, 60 or a custom number of days ago.
Linked Tasks Both, Linked, Not Linked Whether the Work Order comes from a Task.
Compliance Task, Recurring, Overdue Yes, No, All Limits to Work Orders with or without the flag.
Linked Work Request, Job Ready, Confirm Completion Yes, No, All Limits to Work Orders with or without the flag.
Removed Component Serial Number, Fitted Component Serial Number Text Shown only when component serial tracking is on.
Fitted Component Start Usage Number Shown only when component serial tracking is on.

Group By

Group By Groups by
By Asset The Work Order's Asset Number.
By Work Order Number Each Work Order.
By Status, By Priority, By Work Type, By Task Type The Work Order's values.
By Breakdown, By Job Ready Yes or No.
By Site or Department The Work Order's own department.
By Asset Department The Asset's department.
By Cost Responsibility, By Event The Work Order's values.
By Class, By Group, By Asset Type, By Manufacturer The Asset's classification.
By Planning Type, By Asset Status, By Criticality The Asset's details.
By Hire Status On Hire or Off Hire.
By Project, By Customer The Asset's Project and Customer.

Records with no value appear under Unknown. Series by offers the same list on stacked charts.

Chart notes

  • Compare offers Expected versus actual labour hours, and Expected versus actual cost.
  • Compare with on a Line or Area chart plots the total over time, so Group By is not available. Over Time charts allow Compare with and Group By together.
  • Compare with mixes units only on Column, Line, Area and Over Time charts.
  • Group Mode set to Detail draws one bar per Work Order, grouped by your Group By choice.

Business rules

  • Dates differ from the Reports page. A widget applies its Period to one Date basis. The Reports page matches a Work Order if Started At, Scheduled At or Completed At falls in the range, so its totals can differ.
  • The 30-day status counts ignore the Period. Complete and Cancelled always look back 30 days from now, and the widget's Period still applies as well.
  • Empty values add nothing. A Work Order with no duration or cost adds 0 to a sum, and a period with no records shows 0.
  • A Metric Tile is one total. It ignores Group By and Group Mode.
  • Consolidated tables need a Group By. With no grouping, the table uses Detail.
  • Consolidated Pie, Donut and Treemap charts are not limited to 5,000 records. They read group totals directly.

For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.