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!

Dev Space

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

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! 

 

 

 

2 REPLIES 2
KaneG
Alteryx Alumni (Retired)

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!