🙏 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

#myTop10_2024
#myTop10_2025

What inspired this wish list request? 

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

But even after 18 versions of JMP - 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

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

2.  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?

---

<< get out of spec rows :

Where(not(is in spec(:value)))

• Though, what would happen if we get the multiple spec limits which we have asked for for quite some time?
  
  One of THE arguments for an official function
  ... with an additional argument to specify which spec is used for the calculation.

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

?

.... and Tables/Summary, Tabulate and Graph builder Summary statistics ?

Hmm, maybe not ...
They can easily be broken down into

- Col Sum(is in spec(:value), groupby)

- ...

[hogi]

by the way: grouping
Where they should be added: header statistics
(here one cannot use custom, broken down code)

[hogi]

.

[hogi]

@Jeff_Perkinson 
the other issue we discussed yesterday.

This function will allow very cool custom transforms!

https://community.jmp.com/t5/JMP-Wish-List/Option-or-function-to-evaluate-a-custom-column-formula-at... 

[mia_stephens]

Marking this as acknowledged, as we understand the request and are following this thread.

[hogi]

thanks.

[hogi]

The wish was mentioned / discussed in the last session of the Scripters Club:

Scripters Club Recordings: Tips and Tricks