Help required in Forecast chart

[manojkulkarni]

Good Morning All,

I am looking for suggestion or solution to draw a forecasting line using the 2 or 4 weeks average calculation on current data till the it reaches 0. Below is the sample data on which i am trying the solution. Any help will be much appreciated and thanks in advance.

Week Start	Open
20-Jun-2022	271
27-Jun-2022	273
04-Jul-2022	275
11-Jul-2022	275
18-Jul-2022	276
25-Jul-2022	275
01-Aug-2022	275
08-Aug-2022	275
15-Aug-2022	270
22-Aug-2022	268
29-Aug-2022	267
05-Sep-2022	265
12-Sep-2022	260

[Kayde_72]

=avg( 1 {<DateField = {">=$(=Date(Today()-14,'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"}}Open)

use -14 for 14 days and -28 for 28 days

[manojkulkarni]

Hi @Kayde_72 ,

Thanks for your reply. I am not looking for this average. 

I would like to  draw a projected line from 12 Sep 2022 till date using the last 2 weeks average.  Below is the example : last 2 weeks burndown rate from current data is (267-260)/2 -> 3.5 per week.

29-Aug-2022	267
05-Sep-2022	265
12-Sep-2022	260

When i plot the forecast 19 Sep 2022 should show (260-3.5) = 257

26 Sep 2022 - 254

3 Oct 2022 - 251 ...

same follows till it reaches 0