🙏 is in spec (value)

hogi

☑ cool new feature
☑ could help many users!

☐ removes something that feels like a „bug“

☐ nice to have

☐ nobody needs it

What inspired this wish list request?

JMP provides many useful platforms and great functionality for exploratory data analysis.

But there is still some low-hanging fruit to be picked - such as is in spec(value)

What is the improvement you would like to see?

For a column with Spec limits, please provide

a JSL function
```
is in spec(:value)
```
which compares the value of the current row with the spec limits of the column and returns 1 if the value is in spec,
missing, if the value is missing
and 0 if the value is out of spec
a functions
```
is out of spec(:value)
```
which compares the value of the current row with the spec limits of the column and returns
0 if the value is in spec
missing, if the value is missing
-1 if :value[] < LSL
+1 if :value[] >USL

Both functions should be available via the right click "new formula column" menu.

Then users can easily generate new transform column on the fly in every platform - to group and add color to specific data points.

Why is this idea important?

Is the value in spec is a question that is often asked. Right?
-> JMP users will love the new easy to use functions.

other wishes from

hogi

cool additional ideas:
https://community.jmp.com/t5/Discussions/is-in-spec-value/m-p/774330/highlight/true#M95601

@jthi wrote:

"Select out of spec rows" (right click menu on column header)
and then we could have a << Get out of spec rows which could be send to a column which would return missing if spec limits aren't set and empty matrix if they are set but there are no such values.
Though, what would happen if we get the multiple spec limits which we have asked for for quite some time?

hogi

maybe even some aggregation functions like:
- Col N in spec (:value, groupby)

- Col N out of spec (:value, groupby)

- Col N above USL (:value, groupby)

- Col N below LSL (:value, groupby)

?