Can I get forecast.ets to update according to new data added to the table?

Copper Contributor

I've got a table with monthly number of application data. And another one where I've used linear forecasting to forecast let's say Jan, Feb, and Mar of 2023 applications. However, I think exponential forecasting is more suited for this. Previously when I entered December's data, it would update the forecast for Jan, Feb, and March accordingly with the new data entered (linear). But when I switched to forecast.ets, the values remain static. Is there any way I can make sure the forecasts update with the new values entered so that I don't have to manually update it every month?

 

0 Replies