Skip to main content
DD-RET-003 Omnichannel Sales, Customer Behaviour and Commercial Risk Get the data →
DD-RET-003-Q044 Very Hard Time series

Outlier months in net sales

Flag any month whose net sales sit more than 1.5 standard deviations from its trailing 12-month mean. How many months qualify, and which is the most extreme?
Expected
Monthly table with z-scores · Anomaly chart
Tables
FactSalesTransactions, DimDate · columns
  • FactSalesTransactions
  • DimDate
  • NetSalesSAR
  • TransactionDateKey

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