topic Re: is in spec(value) in Discussions

is in spec(value)

hogi — Fri, 08 Nov 2024 13:56:26 GMT

For a column with property Spec Limits, is there a function

is in spec(:value)

which compares the value of the current row with the spec limits of the column?

The best approach which I found up to now: let JMP color the cells and analyze the colors by @Neo

A cool trick - but is there any direct / implemented function available in JMP?

Re: is in spec(value)

jthi — Sat, 20 Jul 2024 14:00:58 GMT

To my knowledge no. You have to either use one of the platforms which is able to do this (coloring) or utilize column properties and perform the comparison.

Re: is in spec(value)

hogi — Sat, 20 Jul 2024 14:10:56 GMT

hm, surprising.

the ultra-low hanging fruits.

Re: is in spec(value)

jthi — Sat, 20 Jul 2024 14:20:24 GMT

I'm not sure how it should be implemented but I think there definitely should be an implementation for it (column properties are excellent feature in JMP but they are under utilized, in my opinion).

Maybe column specific something like "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?

Re: is in spec(value)

hogi — Wed, 24 Jul 2024 10:29:52 GMT

I really love the right click new formula column. Such a great invention!

It's a pity that it's so restricted.
Many cool functions are still missing - and for many cool functions there is not even a chance to be added manually.

The drawback at the moment:
Custom Functions evaluate their argument. So, there is no chance to write a user define Custom Transform which checks for the Spec limits and classifies the rows accordingly :(
And it seems that it will stay like this: https://community.jmp.com/t5/JMP-Wish-List/Option-or-function-to-evaluate-a-custom-column-formula-at-once/idc-p/694940/highlight/true#M5007

So, the only way: hope for an official transform
... here is the wish: