Skip to main content
DD-RSK-001-Q024 Medium Time series

The worst three months of incidents

Compute a rolling 3-month total of incident counts across the whole window (each month plus the two before it, starting once three months exist). What is the highest value that rolling total reaches?
Expected
One whole number · Line chart of rolling 3-month incident count
Tables
FactIncidents, DimDate · columns
  • FactIncidents
  • DimDate
  • IncidentID
  • IncidentDate
  • PeriodKey

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