Logest Function with Alteryx

[Becky]

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???)

I also attached sample file.

It is very greatefule is someone help me.

[jdunkerley79 · Accepted solution]

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]

Thank you very much! It is perfect for me!

Your reply is optimum for my purpose, thanks!

[Watsa]

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