Hi,
I am trying to use the =forecast.ets function to forecast a call volume assumption for a 30 minute interval.
However the forecast function is including the zeroes in the process which lessen the forecast value, what is the best way to counter that but still using the forecast function?
this is the current formula I have used.
=FORECAST.ETS($Q$3,C5:P5,$C$3:$P$3,,,1)
I am trying to use the =forecast.ets function to forecast a call volume assumption for a 30 minute interval.
However the forecast function is including the zeroes in the process which lessen the forecast value, what is the best way to counter that but still using the forecast function?
this is the current formula I have used.
=FORECAST.ETS($Q$3,C5:P5,$C$3:$P$3,,,1)
