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

Routes explaining 80% of growth in delay hours

For latest-year growth in delay hours, 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
  • DelayHours
  • 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.