Skip to main content
DD-LOG-003 Fleet Cost, Maintenance, Service Quality and Delivery Risk Get the data →
DD-LOG-003-Q039 Hard Time series

Routes driving change in on-time deliveries

Which three routes contributed most to the year-over-year change in on-time deliveries in the latest year? Reconcile all route changes to the fleet total, using absolute changes rather than averaging growth rates.
Expected
RouteID, prior, latest, absolute change; descending change then ID; reconciliation total · Variance bridge
Tables
FactFleetTransactions, DimRoute, DimDate · columns
  • FactFleetTransactions
  • DimRoute
  • DimDate
  • OnTime
  • DeliveryStatus
  • RouteID
  • DispatchDateKey
  • YearMonth

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in