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

Logest Function with Alteryx

Becky
8 - Asteroid

I often use "Logest function"(excel function) for making forecast.

 

However, I can't find this logest login in alteryx now...

If there is some method to get logest result, I really want to know.

(Some tool I didn't realize or connect with R system???)

 

 

Reduction rate with Logest function (2).JPG

 

I also attached sample file.

It is very greatefule is someone help me.

3 REPLIES 3
jdunkerley79
ACE Emeritus
ACE Emeritus

Fun challenge :)

 

I have attached a macro recreating the Excel calculation of LogEst.

 

Back to first principles mathematics. Am sure there is an easier but it was fun to make a Linear Regression macro directly in Alteryx using just core tools.

 

The macro takes an X and Y series and will return the slope (m) and intercept (b).

 

On your test data matched the result!

Becky
8 - Asteroid

Thank you very much! It is perfect for me!

Your reply is optimum for my purpose, thanks!

Watsa
8 - Asteroid

This macro is perfect! Thank you very much for the solution. 

Labels