Find Outliers from the data of previous months

[prateek29c]

Hi Guys,

I was trying to find outliers from the previous months data.

As you can see in below table, data from Aug and Nov month are somewhat different from the group. Can we find out outliers in Alteryx without using python / R . How should I go about it?

Any help would be appreciated. Thanks in advance.

ID	Month ( Year 2020 )	Data
1	Jan	200
2	Feb	190
3	Mar	180
4	Jun	210
5	Jul	220
6	Aug	270
7	Sep	185
8	Oct	205
9	Nov	140

[wdavis · Accepted solution]

Hi @prateek29c 

This is definitely possible within Alteryx, it would depend on your own experitse on the data and what you would consider as an outlier.

I have attached a workflow which would provide the framework for this. You can use the Summarize to generate Mean and Standard Variations from the data and then filter all of the data based on these values.

Let me know if you have any questions

Kind Regards,

Will

[prateek29c]

Hi @wdavis,

Thank you so much for this solution. This worked for me.

[tonypreece]

Check out @MarqueeCrew's excellent Modify Outliers macro that you can download from the gallery. You can easily identify outliers, get data on their values (average/upper/lower limites etc) and have the option to remove them from your data and process downstream tools without them.

I use it weekly!

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