Future forecast

[prashantg364]

I am having a date set as shown in the below table.

Zone	Date	Sales
A	01-Mar-22	7
B	01-Mar-22	7
C	01-Mar-22	15
D	01-Mar-22	3
E	01-Mar-22	43
A	02-Mar-22	43
B	02-Mar-22	35
C	02-Mar-22	13
D	02-Mar-22	3
E	02-Mar-22	8
A	03-Mar-22	8
B	03-Mar-22	35
C	03-Mar-22	20
D	03-Mar-22	2
E	03-Mar-22	26
A	04-Mar-22	18
B	04-Mar-22	34
C	04-Mar-22	44
D	04-Mar-22	14
E	04-Mar-22	31
A	05-Mar-22	23
B	05-Mar-22	17
C	05-Mar-22	31
D	05-Mar-22	23
E	05-Mar-22	17

Total sales for 5 days is 520 (Sum of Sales column)
The number of days is 5

Average sales per day 104 (520 divided by 5)
Now I want to have a calculated column to show future date sales based on the data set's average.

Date	Actual Avg sales/day	Sales forecast
01-Mar-22	104
02-Mar-22	104
03-Mar-22	104
04-Mar-22	104
05-Mar-22	104
06-Mar-22		104

[lbendlin]

Not enough data for a proper forecast.  Even if you would use a sliding window it would flatten out quickly.  You also don't seem to consider weekends/holidays/seasonality.