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 |
You could use a simple linear regression using chart functions:
linest_M(total aggr(Open,[Week Start]),[Week Start])*[Week Start] + linest_b(total aggr(Open,[Week Start]),[Week Start])
You could see and example here: https://aginic.com/blog/forecasting-in-qlik-guide/
Hope it helps!