Linear Forecast

[dwestfield]

Hi folks,

I have a simple scenario which can be done is excel using the "Forecast linear" or "Trend" tools. However, I am unable to get this done in Alteryx. Please Help!!!

I have attached a photo of an example, excel Forecast linear gave a result of 32.67. 

[Jean-Balteryx]

Hi @dwestfield ,

Is it a time forecast you are trying to accomplish ?

Cheers,

Jean-Baptiste

[jdunkerley79 · Accepted solution]

Hi @dwestfield,

I put together a post on creating a least-squares macro for Alteryx: https://jdunkerley.co.uk/2019/05/14/least-squares-in-an-alteryx-macro/

For this specific case, it can be a simpler set of tools computing the totals you need and then can fill in the gaps.

I have attached an example doing it (and yes gets 32.66...)

Hope it helps

[dwestfield]

Hi Jean-Balteryx,

Yes. The x variables represent time. We are trying to determine the value of the y variable in the 7th year. Excel Forecast linear/trend tool usually does the trick. 

[dwestfield]

Hi@jdunkerley79

It worked! Thanks a mil