Skip to main content
DD-LOG-003 Fleet Cost, Maintenance, Service Quality and Delivery Risk Get the data →
DD-LOG-003-Q028 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
FactFleetTransactions, DimDate · columns
  • FactFleetTransactions
  • 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