Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

RMSE and MAE Macro

Highlighted
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! 

 

 

 

Highlighted
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!

Highlighted
6 - Meteoroid

Great idea! Thank you!