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

Find Outliers from the data of previous months

prateek29c
6 - Meteoroid

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.

 

IDMonth ( Year 2020 )Data
1Jan200
2Feb190
3Mar180
4Jun210
5Jul220
6Aug270
7Sep185
8Oct205
9Nov140
wdavis
Alteryx
Alteryx

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
6 - Meteoroid

Hi @wdavis,

 

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

tonyp
10 - Fireball

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

 

Labels