None. A Heatmap uses Required Date (Work Order Due Date).
Default columns
Work Order Number, Work Order Title, Asset Number, Department, Part Number, Supplier, Purchase Order Number, Requested Quantity, Ordered Quantity, Received Quantity, Outstanding Quantity, Status, Required Date, Expected Date, Asset Description
Group Modes
Detail tables. Charts are Consolidated.
Drill-through
Column Chart only
Measures
Measure
Unit
Aggregation
Definition
Part order line count
Lines
Count
Number of part lines on order.
Columns
Column
Type
Description
Work Order Number, Work Order Title
Text
The Work Order the part is for.
Work Order Due Date
Date
The Work Order's Due Date.
Part Number, Part Description
Text
The part.
Supplier
Text
The Purchase Order's supplier, or else the part's supplier.
Purchase Order Number
Text
The linked Purchase Order.
Requested Quantity, Ordered Quantity, Received Quantity, Outstanding Quantity
Number
How much was requested, ordered and received, and how much is still due.
Status
Text
The part line's order status.
Required Date, Expected Date
Date
When the part is needed and expected.
Department
Text
The Work Order's own department.
Asset Department
Text
The Asset's department.
Asset Number, Asset Description
Text
The Work Order's Asset.
Class, Group, Asset Type, Manufacturer
Text
The Asset's classification.
Asset Status, Criticality, Planning Type, Hire Status
Text
The Asset's details.
Project, Customer
Text
The Asset's Project and Customer.
Filters
Filter
Choice
Behaviour
Asset Number
Multiple
The Work Order's Asset.
Asset Department
Multiple
The Asset's department.
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.
Group By
Group By
Groups by
By Asset
The Work Order's Asset.
By Supplier
The Purchase Order's supplier, or else the part's supplier.
By Department
The Work Order's own department.
By Asset Department
The Asset's department.
By Year
The year of the Work Order's Due Date.
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.
Chart notes
Line and Area charts draw one point per group, because this dataset has no time periods.
A Heatmap places each line on its Required Date.
Series by, Compare and Compare with are not available.
Business rules
Only parts still on order appear. A line must be linked to a Purchase Order line, with status Backorder, Pending Approval, Approved or On Order.
The Event must still be pending. Lines appear only when the Work Order's Event has a Pending status.
There is no Period. The dataset shows what is on order now.