Work Order Details

The Work Order Details dataset shows the full record of selected Work Orders, with their costs, parts, labour, services, resources, forms and documents.

At a glance

Item Value
Picker heading Data Tables
One row is One detail line of a Work Order, such as a part or a labour entry
Presentations Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Sparklines, Grouped Line
Default presentation Table
Default period Last 30 Days. Time charts start on Last Month.
Date basis Started At, Scheduled At or Completed At. A Work Order matches when any falls in the Period.
Default columns The main Header, Costs, Part, Labour and Service columns
Group Modes Detail tables. Charts are Consolidated.
Drill-through Not available

Measures

Measure Unit Aggregation Definition
Work Order count Work Orders Count Number of Work Orders, not detail lines.

Columns

Column labels start with their section, such as Header or Part.

Section Columns Description
Header Work Order Number, Title, Description, Status, Custom Status, Priority, Work Type The Work Order.
Header Task Type, Task Code, Task The linked Task.
Header Asset Number, Asset Description, Site or Department, Area, Location Address Where the work is.
Header Team, Crew, Contractor, Reporting To Who does the work.
Header Scheduled At, Due Date, Started At, Completed At, Completed By When the work happens.
Header Source, Failure, Cause, Breakdown, Compliance Task Why the work is needed.
Header Cost Responsibility, Purchase Order Numbers, Notes, Created By, Created At Other Work Order details.
Costs Cost Type, Expected Cost, Actual Cost, Variance, Expected Labour Hours, Actual Labour Hours One line per cost type.
Part Part Number, OEM Number, Description, Source, Status, Supplier The part.
Part Quantity, Unit Cost, Total Cost, Optional, Received, Used, PO Number The part's quantities and cost.
Labour Type, Trade, Technician, Date, Quantity, Hours, Rate, Cost, Notes One line per labour entry.
Service Description, Supplier, Source, Status, Quantity, Unit Cost, Total Cost, PO Number, Notes One line per service.
Resource Name, Quantity, Notes One line per resource.
Form Name, Status, Assigned To, Scheduled At, Completed By, Duration One line per Form.
Document File Name One line per document.
Asset Class, Group, Asset Type, Manufacturer, Asset Department The Asset's classification and department.
Asset Asset Status, Criticality, Planning Type, Hire Status, Project, Customer The Asset's details.

Filters

Filter Choice Behaviour
Work Order Multiple Specific Work Orders.
Status, Priority Multiple The Work Order's values.
Team Multiple The assigned team.
Task Type, Task Code Multiple The linked Task's type and code.
Cost Responsibility Multiple Who is responsible for the cost.
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 Multiple The Work Order's Asset.
Class, 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.
Breakdown, Compliance Task, Linked to Task, Overdue All, Yes, No Limits to Work Orders with or without the flag.

Group By

Group By Groups by
Work Order Each Work Order.
By Asset Department The Asset's department.
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.

Chart notes

  • Charts count Work Orders. They do not read the detail lines, so they stay fast and each Work Order counts once.
  • Series by, Compare and Compare with are not available.

Business rules

  • Use it for selected Work Orders. This dataset is built for reviewing a small set in full. For totals across many Work Orders, use the Work Orders dataset.
  • At least one filter is needed. With No Date Range and no filters, the report asks you to choose one.
  • A row holds one section's values. A Part line has no Labour values, so columns from other sections are blank on that row.
  • Do not add up Header values. Header values repeat across a Work Order's detail lines.

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