Measures

Order Inspection for each status is recorded.

Measure Mapping Note
Active Count 1 if the status is Active, else 0
Actual Quantity Accepted qmptc120.aaqa\ qmptc220.aaqa
Actual Quantity Rejected qmptc120.arqa\ qmptc220.arqa
Average Resolution Time by Days Days taken to close the order divided by the number of orders closed in that period Non-Additive
Average Resolution Time by Hours Hours taken to close the order divided by the number of orders closed in that period Non-Additive
Canceled Count 1 if the status is Cancelled, else 0
Closed Count 1 if the status is Closed, else 0
Completed Count 1 if the status is Completed, else 0
Defective parts per Million (Sum of Actual Quantity Rejected/Sum of Order Quantity) * 1000000
Defect Free Percentage Status = Closed and if rejected, the actual rejected quantity is filled.

Status = Processed and if rejected, the recommended quantity is filled.

Free Count 1 if the status is Free, else 0
Order Inspection Count Fact count sourced from qmmptc220\ qmptc120
Order Quantity qmptc120.oqua
Processed Count 1 if the status is Active, else 0
Recommended Quantity Accepted qmptc120.raqa
Recommended Quantity Destroyed qmptc120.rdqa
Recommended Quantity Rejected qmptc120.rrqa
Resolution Time in Seconds Closed Date minus Creation Date in seconds