Lead time is calculated as the difference between the order date and the date of each status.
Calculate by status
*DATEDIFF : Returns the difference between two dates
- Order Creation
- Pick Released : DATEDIFF("day", [ORD_DATE], [PICK_RLS_DATE])
- Load Create : DATEDIFF("day", [ORD_DATE], [LOAD_CREATION_DATE])
- WH Released : DATEDIFF("day", [ORD_DATE], [WH_RLS_DATE])
- Ship Confirm : if DATEDIFF("day", [ORD_DATE], [ACTUAL_SHP_DATE])=0 then null
else DATEDIFF("day", [ORD_DATE], [ACTUAL_SHP_DATE]) end - MMD (3PL) : DATEDIFF("day", [ORD_DATE], [LMSP_HUB_ARRV_DATE_TIME])
- Delivery Comlete (Order to Delivery Complete) :
if DATEDIFF("day", [ORD_DATE], [SALE_DATE])=0 then null
else DATEDIFF("day", [ORD_DATE], [SALE_DATE]) end - Order to Ship Confirm :
if DATEDIFF("day", [ORD_DATE], [ACTUAL_SHP_DATE])=0 then null
else DATEDIFF("day", [ORD_DATE], [ACTUAL_SHP_DATE]) end - Ship Confirm to Delivery Complete : AVG([ORD_2_DEL]) - AVG([ORD_2_SHIP])