Binning by Spec limits

[#1]

If I have a column with spec limits defined as column properties, is there a "one-click" solution *) to bin the data into 3 groups:

x < LSL

LSL <= x <= USL

x > USL

[#2]

Here is an example of one way to handle this

Names Default To Here( 1 );

dt = // Open Data Table: semiconductor capability.jmp
// → Data Table( "semiconductor capability" )
Open( "$SAMPLE_DATA/semiconductor capability.jmp" );

dt << New Column( "bin",
	formula(
		As Constant( specs = :PNP3 << get property( "spec limits" ) );
		If( specs["LSL"] <= :PNP3 <= specs["USL"],
			1,
			0
		);
	)
);

[#3]

Thanks @txnelson for the JSL example :)

The disadvantage: a new column is added.

If I do this for all column, it gets quite crowded.

I hope a similar functionality is directly implemented in Jmp - but couldn't find it.

neither here:

hogi_0-1683865383653.png

nor here:

hogi_1-1683865461977.png

Is it hidden behind a Shift/Alt/Ctrl Click?

[#4 · Accepted solution]

I was able to create a grouping based upon the binning of the Spec Limits

txnelson_0-1683873760096.png

Using the Levels option, and specifying Create Transform Column 

txnelson_1-1683873931671.png

I simply created the following formula to create the binning

txnelson_2-1683874023026.png

and it worked as desired.

In my example, I used the Semiconductor Capability sample data table, and the PNP3 column.  It has outliers, however, it has no outliers that are less than the LSL value, so I manually changed one row to have a low value, just to test the formula.

specs = :PNP3 << get property( "spec limits" );
If(
	:PNP3 < specs["LSL"], -1,
	specs["LSL"] <= :PNP3 <= specs["USL"], 0,
	1
);

[#5]

So, there is no single click solution?
I also checked the Custom Binning menu. 

Several options are listed, but none to use the spec limits:

hogi_0-1683875335808.png