Main Dashboard: Carrier

% On Time Pickup

Percentage ratio of total number of on-time pickup stops and total number of pickup stops.

case when ("- Shipment Stop Pickup Targets"."% On Time Pickup Target" is NULL or "- Shipment Stop Pickup Targets"."% On Time Pickup Target" = 0)  and ("- Shipment Stop Pickup Facts"."% On Time Pickup" is NULL or "- Shipment Stop Pickup Facts"."% On Time Pickup" = 0) then 100  else "- Shipment Stop Pickup Targets"."% On Time Pickup Target" end

Percent on time pickup is greater than 100% of target value then green.

Percent on time pickup is less than 100% of target value then red.

If no data exists for the selected criteria then gray.

% On Time Delivery

Percentage ratio of total number of on-time delivery stops and total number of delivery stops.

case when ("- Shipment Stop Delivery Targets"."% On Time Delivery Target" is NULL or "- Shipment Stop Delivery Targets"."% On Time Delivery Target" = 0)  and ("- Shipment Stop Delivery Facts"."% On Time Delivery" is NULL or "- Shipment Stop Delivery Facts"."% On Time Delivery" = 0) then 100  else "- Shipment Stop Delivery Targets"."% On Time Delivery Target" end

Percent on time delivery is greater than 100% of target value then green.

Percent on time delivery is less than 100% of target value then red.

If no data exists for the selected criteria then gray.

% Tender Acceptance

Percentage ratio of total number of accepted tender transactions and total number of tender transactions.

case when ("- Tender Performance Targets"."Tender Performance Target" is NULL or "- Tender Performance Targets"."Tender Performance Target" = 0)  and ("- Tender Performance Facts"."% Tender Acceptance" is NULL or "- Tender Performance Facts"."% Tender Acceptance" = 0) then 100  else "- Tender Performance Targets"."Tender Performance Target" end

Percent tender acceptance is greater than 100% of target value then green.

Percent tender acceptance is less than 100% of target value then red.

If no data exists for the selected criteria then gray.

Average Pickup Hours

Average ratio of total pickup hours difference* of pickup stops and total number of stops * Total pickup hours difference: Time difference (in hours) between planned arrival time and actual arrival time at a pickup stop.

case when ("- Shipment Stop Pickup Targets"."Average Hours Outside Pickup Time Target" is NULL or "- Shipment Stop Pickup Targets"."Average Hours Outside Pickup Time Target" = 0)  and ("- Shipment Stop Pickup Facts"."Average Hours Outside Pickup Time" is NULL or "- Shipment Stop Pickup Facts"."Average Hours Outside Pickup Time" = 0) then 100  else "- Shipment Stop Pickup Targets"."Average Hours Outside Pickup Time Target" end

Average pickup hours are greater than 100% of target value then green.

Average pickup hours are less than 100% of target value then red.

If no data exists for the selected criteria then gray.

Average Delivery Hours

Average ratio of total delivery hours difference* of delivery stops and total number of stops * Total delivery hours difference: Time difference (in hours) between planned arrival time and actual arrival time at a delivery stop.

case when ("- Shipment Stop Delivery Targets"."Average Hours Outside Delivery Time Target" is NULL or "- Shipment Stop Delivery Targets"."Average Hours Outside Delivery Time Target" = 0)  and ("- Shipment Stop Delivery Facts"."Average Hours Outside Delivery Time" is NULL or "- Shipment Stop Delivery Facts"."Average Hours Outside Delivery Time" = 0) then 100  else "- Shipment Stop Delivery Targets"."Average Hours Outside Delivery Time Target" end

Average delivery hours are greater than 100% of target value then green.

Average delivery hours are less than 100% of target value then red.

If no data exists for the selected criteria then gray..

Percent Claims

Average ratio of total claims made and total shipments.

case when ("- Shipment Targets"."Actual Cost Base per Pallet Target" is NULL or  "- Shipment Targets"."Actual Cost Base per Pallet Target" = 0)  and ("- Shipment Facts"."Actual Cost Base per Pallet" is NULL or "- Shipment Facts"."Actual Cost Base per Pallet" = 0) then 100  else ("- Shipment Targets"."Actual Cost Base per Pallet Target") end

Percent claims are greater than 100% of target value then green.

Percent claims are less than 100% of target value then red.

If no data exists for the selected criteria then gray.