Forum Discussion
Forecast Moving Average wih 3 condition
Hi Anonymous ,
I am afraid that this cannot be achieved, because the forecast value is based on the sales of the previous months. And the sales of the previous month does not actually exist. For example, calculating the forecast sales in August 2021, which is equal to the average sales of May, June and July. But the sales in July does not actually exist. . .
Maybe you can try to apply forecasting to the line chart. Select the related line chart, then expand the Forecast section of the Analytics pane. Input the value for Forecast length or the Confidence interval.
Best Regards
Hi Anonymous ,
I am afraid that this cannot be achieved, because the forecast value is based on the sales of the previous months. And the sales of the previous month does not actually exist. For example, calculating the forecast sales in August 2021, which is equal to the average sales of May, June and July. But the sales in July does not actually exist. . .
Maybe you can try to apply forecasting to the line chart. Select the related line chart, then expand the Forecast section of the Analytics pane. Input the value for Forecast length or the Confidence interval.
Best Regards