Supplier performance - Stockful

Purchase-order delivery reliability by supplier: on-time rate, deliveries and average days late, judged on the first receipt against the expected date.

Example

FROM supplier_performance
  SHOW on_time_rate, deliveries
  GROUP BY supplier
  ORDER BY on_time_rate DESC

Metrics

Metric	Type	Description
`on_time_rate`	Percent	Percentage of deliveries whose first receipt landed on or before the expected date.
`deliveries`	Number	Received purchase orders that carried an expected date, in the period.
`on_time_deliveries`	Number	Deliveries whose first receipt was on or before the expected date.
`late_deliveries`	Number	Deliveries whose first receipt was after the expected date.
`avg_days_late`	Number	Average days between the expected date and the first receipt (negative = early).

Dimensions

Dimension	Description
`supplier`	The purchase order’s supplier.
`destination`	The location the purchase order was received into.

Filters

Filter	Type	Description
`supplier`	Text	The purchase order’s supplier.
`destination`	Text	The location the purchase order was received into.