Skip to main content
DD-LOG-004 Fleet Network Performance and Capacity Planning Get the data →
DD-LOG-004-Q036 Hard Time series

Routes explaining 80% of growth in actual delivery cost

For latest-year growth in actual delivery cost, identify the smallest set of routes explaining at least 80% of positive growth. Exclude declines from the denominator, show their combined decline separately, and reconcile to net growth.
Expected
Sorted positive route changes, cumulative positive share, cutoff set, decline total, net change · Variance bridge
Tables
FactFleetTransactions, DimRoute, DimDate · columns
  • FactFleetTransactions
  • DimRoute
  • DimDate
  • FuelCostSAR
  • DriverCostSAR
  • OtherCostSAR
  • 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.