Skip to main content
DD-LOG-001 Shipment Delivery Performance and Fleet Efficiency Get the data →
DD-LOG-001-Q029 Hard Time series

Vehicles driving change in delivered units

Which three vehicles contributed most to the year-over-year change in delivered units in the latest year? Reconcile all vehicle changes to the fleet total, using absolute changes rather than averaging growth rates.
Expected
VehicleID, prior, latest, absolute change; descending change then ID; reconciliation total · Variance bridge
Tables
FactShipments, DimVehicle, DimDate · columns
  • FactShipments
  • DimVehicle
  • DimDate
  • DeliveredUnits
  • VehicleID
  • 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