Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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!


Outlier detection

5 - Atom

I have a data set and I need to delete outliers from it (as you normally would) however the process I have followed seems to delete far more than the outliers. Attached is my data and the below image is the process I have done to detect outliers


My data has ~4900 rows of data, however this outlier detection is cutting that number down to ~390 rows. The formulas I have in the formula tool are:


and in the filter I have the following custom filter:


Does anyone have any idea where I have gone wrong and how I can improve this for a more accurate outlier detection?


16 - Nebula
19 - Altair
19 - Altair

@Wakelij2 ,


i built an outlier macro that will allow you to pick an outlier method and identify, modify or delete the outliers.!app/CReW-Modify-Outliers/5a80861feffc2a2658b0ad96  





Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.