Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I want to create a bar chart which will project the data for next 4 months. I am aware of the fact that linest_m and linest_b can be used for linear regression. However, I am not able to do that properly and data seems incorrect.
I am attaching the input file. The file contains data from Nov-2016 to Mar-2017 data for three different countries. In the Bar chart, for each country, for next 4 months i.e. from Apr-2017 to July-2017, data needs to be projected. Can anyone help me with this.
Thanks.
May be this:
=If(Sum(Cost) > 0, Sum(Cost),
LINEST_M(TOTAL <Country> Aggr(Sum(Cost), Country, Month), Month)*Month + LINEST_B(TOTAL <Country>Aggr(Sum(Cost), Country, Month), Month))