Logistics & Transportation Analytics · Mission 24 of 30Expert

Carrier scorecard — four metrics in one query

Compute multiple performance metrics in a single GROUP BY query using conditional aggregation

Unlock with Pro→Back to Logistics & Transportation Analytics

The Brief

You'll practice

CASE WHENGROUP BYJOIN
← Previous
Mission 23
Next →
Mission 25
All 30 missions in Logistics & Transportation Analytics ↓
  1. 1. First look at the shipment roster
  2. 2. Meet the carrier network
  3. 3. Lane inventory
  4. 4. Delivered shipment count
  5. 5. Status breakdown
  6. 6. Carrier shipment volume
  7. 7. Total freight spend
  8. 8. On-time delivery rate by carrier
  9. 9. In-full rate by carrier
  10. 10. Average freight cost per mode
  11. 11. Monthly shipment volume trend
  12. 12. Detention hot spots — lanes with high dwell
  13. 13. Top 5 most expensive shipments
  14. 14. Overbilled invoices
  15. 15. Carrier spend with invoice data
  16. 16. Failed shipments with carrier detail
  17. 17. Duplicate tracking events
  18. 18. Carrier OTD vs. target gap
  19. 19. Monthly freight cost trend by carrier mode
  20. 20. Lane-level OTD with carrier names
  21. 21. Perfect score carriers — OTD and in-full combined
  22. 22. Weight-normalized freight cost per mile
  23. 23. Invoice audit: billed vs shipped amounts
  24. 24. Carrier scorecard — four metrics in one query
  25. 25. Tracking event timeline for a shipment
  26. 26. Regional origin performance — cost and OTD
  27. 27. Shipments with accessorial charges — detention deep dive
  28. 28. Shipment delivery delay analysis
  29. 29. Rolling 3-month freight cost vs prior period
  30. 30. End-to-end carrier risk index