How to find outlier in the workflow

[AntonioM]

Hello Everyone,

I am very new with Alteryx and I wonder if you can help to understand how to find out outliers for the workflow attached.

Thank you.

Antonio

[alexnajm]

How would you like to define an outlier? there are a few options, so I would see if there is anything internally or online that can help give some logic, then we may be in a batter position to help.

also without seeing the data, we can't really help further!

[AntonioM]

Hi Alex, 

I have one table with net time in hours and minutes and another with net time in seconds, it could lead to inconsistencies or errors when I try to merge or compare the data. Maybe a solution can be to link both tabs and convert the values. 

[alexnajm]

This seems like a different question than outliers... yes you should convert them into one format (seconds is probably your best bet) first before anything else

[AntonioM]

I think as an outlier,  for example the tickets that took much longer than the average time to resolve, so it could be cause by same product for example.

[alexnajm · Accepted solution]

What defines "much longer than average"? by interquartile range? z-score? How to Detect Outliers in Machine Learning - GeeksforGeeks