How to Flag out of Bound Values

[ReidM]

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!!

[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.

[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?

[mattnason1 · Accepted solution]

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

[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