Question

A sales analyst adds a line chart showing 36 months of monthly revenue and uses the Analytics pane Forecast feature. The revenue clearly rises and falls in a repeating yearly pattern, but the generated forecast ignores this pattern and produces a nearly straight projected line. Which Forecast setting adjustment will produce a forecast that reflects the yearly repeating pattern?

Accepted Answer

Set the Seasonality value to 12 so the algorithm accounts for the 12-month repeating cycle

Answer

Lower the Confidence interval from 95% to 75% to tighten the projected band

Answer

Increase the Forecast length to 24 points so more future periods are shown

Answer

Enable Ignore last and set it to 12 to exclude the most recent year of data