KPIs

Number of Orders

The total count of customer orders in the selected time period.

The number of orders can be calculated using this formula: Count (Order_ID)

Avg Shipment Delays

The average delay in shipment delivery calculated from the due date. If the shipment is delivered earlier than the due date or on-time, the value is displayed as 0.

The average shipment delays can be calculated using this formula: AVG( MAX(0, DATEDIFF(day, Due_Date, Actual_Ship_Date)) )

Ordered Qty

The total quantity ordered for the selected orders in the time period.

The ordered quantity can be calculated using this formula: Sum (Ordered_Qty)

Shipped Qty

The total quantity shipped for the selected orders in the time period.

The shipped quantity can be calculated using this formula: Sum (Shipped_Qty)

Net Ordered Amt

The total net order value for the selected orders in the time period. This value is calculated after excluding the tax or freight cost.

The net ordered amount can be calculated using this formula: SUM( (Ordered_Qty * Unit_Price) - Discount_Amt )

Shipped Amt

The total shipped amount value for shipped quantities for the selected orders in the time period.

The shipped quantity can be calculated using this formula: SUM( Shipped_Qty * Net_Unit_Price )

Revenue at Risk

The total value of overdue backorders.

Number of Shipped Orders

The count of orders that are shipped for the time period.

Fill Rate Order

The percentage of customer orders that are fully shipped.

On Time Orders

The percentage of customer orders that are delivered on time.