Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

RMSE and MAE Macro

pirroav
6 - Meteoroid

Hello there Alteryx community, 

 

I looked around but I was not able to find anything quite like this, so I've gone ahead and built  it for myself and thought I should share it. I built a simple macro that takes in a set of actual values and forecasted values, and returns a root mean square error (RMSE) and a mean absolute error (MAE) value. RMSE and MAE are often used to measure the effectiveness of regression analysis, forecasting, time series, etc.

 

Please let me know what you think and anything fun that you use it for! 

 

 

 

KaneG
Alteryx
Alteryx

Nice and simple! I like it. You may want to publish this to the public gallery as well so that more people can find it!

pirroav
6 - Meteoroid

Great idea! Thank you!