Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Linear Forecast

dwestfield
5 - Atom

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. 

 

Forecast Linear.PNG

4 REPLIES 4
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @dwestfield ,

 

Is it a time forecast you are trying to accomplish ?

 

Cheers,

 

Jean-Baptiste

jdunkerley79
ACE Emeritus
ACE Emeritus

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
5 - Atom

Hi 

 

dwestfield
5 - Atom

Hi@

 

It worked! Thanks a mil

Labels