We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to Flag out of Bound Values

ReidM
7 - Meteor

I currently have a a data set of torque values. I made a scatterplot with upper/lower limits and the average to help visually see how my data fits. Upper limit is 12.2 and lower limit is 9.5. Separately, I want to flag and then alert via email when I have three points in a row that our outside of these limits. I know how to flag every value that falls outside the limits, but not strictly three in a row. Any help on how I would go about doing this?

ReidM_0-1645476321141.png

 

Thanks!!

14 REPLIES 14
ReidM
7 - Meteor

What do you mean? All of these are outside my limits 

 

ReidM_1-1645541854520.png

 

gabrielvilella
14 - Magnetar

If I am seeing correctly, the red line is the Average. The blue line is the lower limit. Those values are below the red line. The blue line is not showing probably because it's too low. 

ReidM
7 - Meteor

Yes you're correct, the red line is the average. In this example the average and the lower limit are very close to each other so it is hard to see the blue line unless you zoom in. 

 

If you look at the data it shows what the lower limit, upper limit, and average. 

 

ReidM_0-1645542565669.png

 

gabrielvilella
14 - Magnetar

I got confused with the field names you have. See if this is what you are looking for.

ReidM
7 - Meteor

Yes I can go off of this! Thank you for you help!

Labels
Top Solution Authors