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!

SOLVED

Outlier detection

Wakelij2
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

Wakelij2_0-1612181265027.png

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:

Wakelij2_1-1612181391114.png

and in the filter I have the following custom filter:

Wakelij2_2-1612181427471.png

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

 

Qiu
16 - Nebula
MarqueeCrew
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. 

https://gallery.alteryx.com/#!app/CReW-Modify-Outliers/5a80861feffc2a2658b0ad96  

 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

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