Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have data sale from 2016-2017 as below, How do I create forecast chart for view 3 months in the future (Jan-Mar 2018)?
| YearMonth | Sale |
| 201601 | 51,430 |
| 201602 | 88,265 |
| 201603 | 80,294 |
| 201604 | 77,470 |
| 201605 | 77,790 |
| 201606 | 82,874 |
| 201607 | 79,558 |
| 201608 | 75,460 |
| 201609 | 69,899 |
| 201610 | 71,511 |
| 201611 | 87,371 |
| 201612 | 102,744 |
| 201701 | 67,424 |
| 201702 | 78,588 |
| 201703 | 90,834 |
| 201704 | 85,888 |
| 201705 | 76,152 |
| 201706 | 74,970 |
| 201707 | 82,990 |
| 201708 | 80,470 |
| 201709 | 82,600 |
| 201710 | 67,080 |
| 201711 | 82,221 |
| 201712 | 38,686 |
May be this?
Left(YearMonth,4) as Year
Expression should be this?
if(Year<>'2017',sum(Sale), Linest_m(total aggr(if(sum(Sale),sum(Sale)),Year),Year)*Year+Linest_b(total aggr(if(sum(Sale),sum(Sale)),Year),Year))
What are the expected numbers you hope to see for the future months? Is this something you need in the script or on the front end?