Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
=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
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