Skip to main content
DD-RET-004 Enterprise Retail Profitability and Inventory Optimisation Get the data →
DD-RET-004-Q055 Very Hard

Chronic stockout products

Among products with at least 600 transactions, which has the highest stockout rate, and how many products exceed twice the chain rate?
Expected
Product exception table · Exception table
Tables
FactSalesTransactions, DimProduct · columns
  • FactSalesTransactions
  • DimProduct
  • StockoutFlag
  • ProductID

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