Skip to main content
DD-INV-002 Retail and Manufacturing: Transfers, Counts and Stock Nobody Ordered — Inventory & Stock Get the data →
DD-INV-002-Q040 Very Hard Time series

Dairy cover month by month

There is no calendar table: build one from the dates. Monthly cover of a category = its stock at the month-end (both centres) / its "Issue to stores" value in that month x the days in the month. Over the twelve months of 2025, what is the lowest monthly cover of "Dairy and eggs", in days? 2 decimals.
Expected
Days, 2 decimals · KPI card
Tables
FactStockMovements, DimItem · columns
  • FactStockMovements
  • DimItem
  • MovementType
  • MovementDate
  • Quantity
  • Value
  • LocationCode
  • Category

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. Need help? Message us

Create a free account Sign in