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

Routes explaining 80% of growth in distance driven

For latest-year growth in distance driven, 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
  • ActualDistanceKm
  • 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.