How to Flag out of Bound Values

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?

Thanks!!

Developer

Accepted answers

mattnason1

Not knowing your data I'd do something like this.

Flag Out Of Bound Values.yxmd

All comments

gabrielvilella

You have to determine which are those points outside those limits within the workflow, not by just looking at the chart. Once you have this data available in the workflow you can trigger an email.

ReidM

Yes I understand that if I just wanted to know every value that fell outside the limits. I could do a formula tool with IF statements and flag every point over 12.2 and under 9.5. For this I want it to alert only when it happens 3 times in a row. I'm sure there's a formula that would work, I just cant wrap my head around how to do it.

gabrielvilella

If you have that data in rows, you can use the multi row formula to check if there is a value three times consecutively. Sample data would help us show you how to do this.

ReidM

I attached what the end result of my data currently looks like.

Sample Workflow.yxmd

gabrielvilella

The input file is not included in the workflow file. You can export the workflow so it will include all the assets in the package. Go to Options > Export Workflow.

ReidM

Sorry about that, did this work?

Sample2.yxzp

mattnason1

Not knowing your data I'd do something like this.

Flag Out Of Bound Values.yxmd

gabrielvilella

@ReidM You don't have any points that are below limitlow or higher than limimax.

mattnason1

Mistake in my multi-row

Should have been:

if [Row-1:Value] = 0 then [Value]
elseif [Value] = 0 then [Value]
else [Row-1:New Field] + [Value] endif

ReidM

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

gabrielvilella

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

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.

gabrielvilella

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

Sample Workflow.yxzp

ReidM

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703