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

Monthly trend of on-time deliveries

How does on-time deliveries change month by month? Show every month and identify the highest month, breaking ties by earliest month.
Expected
36 rows: YearMonth, total; ascending month · Line chart
Tables
FactDeliveryOrders, DimDate · columns
  • FactDeliveryOrders
  • DimDate
  • OnTime
  • DeliveryStatus
  • 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