Skip to main content
DD-CRM-002-Q039 Very Hard Time series

The most accurate forecaster

Actual = Revenue in FactLedgerRevenue for the same AccountID and month (0 if there is none). Take the Mizan Manufacturing owners who submitted a forecast for every month of 2025. For each owner and month, error = |their total Commit - their total Actual| / their total Actual (skip a month with no Actual). Which OwnerID has the lowest average monthly error?
Expected
One OwnerID · KPI card
Tables
FactForecast, FactLedgerRevenue · columns
  • FactForecast
  • FactLedgerRevenue
  • OwnerID
  • EntityCode
  • Commit
  • ForecastMonth
  • AccountID
  • Revenue

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