Skip to main content
DD-LOG-002 Delivery Orders, Route Performance and Vehicle Utilisation Get the data →
DD-LOG-002-Q032 Medium Time series

Year-on-year change in delivery cost variance

How did annual delivery cost variance change between the last two complete calendar years? Report both totals, the absolute change and percentage change.
Expected
One row: prior, latest, change, percentage · Line chart
Tables
FactDeliveryOrders, DimDate · columns
  • FactDeliveryOrders
  • DimDate
  • PlannedCostSAR
  • FuelCostSAR
  • DriverCostSAR
  • OtherCostSAR
  • 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