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

Routes driving change in planned delivery cost

Which three routes contributed most to the year-over-year change in planned delivery cost 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
  • PlannedCostSAR
  • 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