topic Re: Add custom formula and columns to Tabulate window in Discussions

Add custom formula and columns to Tabulate window

Jackie_ — Sun, 03 Nov 2024 22:00:09 GMT

Hello,

Is there a way to add a custom formula and column to the tabulate window?

Eg: I want to add LSL, USL, and Cpk columns to the tabulate window, not the data table box.

Any suggestions on how to do this would be appreciated.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" );
(Data Table( "Semiconductor Capability" ) << Tabulate(
Add Table(
Column Table( Grouping Columns( :lot_id ), Statistics( Mean, Std Dev ) ),
Row Table( Analysis Columns( :NPN1, :PNP1, :PNP2, :NPN2, :PNP3, :IVP1 ) )
)
)) << Make Into Data Table;

Thank you!

Re: Add custom formula and columns to Tabulate window

jthi — Mon, 04 Nov 2024 06:22:10 GMT

You have to add the columns first either to your table or as transform columns to tabulate and then you can use those in Tabulate platform.

Re: Add custom formula and columns to Tabulate window

Jackie_ — Mon, 04 Nov 2024 13:35:17 GMT

@jthi I want to add as a column (tall table format) not as a wide table

Re: Add custom formula and columns to Tabulate window

jthi — Mon, 04 Nov 2024 13:45:13 GMT

I don't think that is possible with the original data format you had as you would be mixing analysis and grouping columns (Tabulate).

Re: Add custom formula and columns to Tabulate window

txnelson — Mon, 04 Nov 2024 14:22:03 GMT

Have you looked at

Analyze=>Quality and Process=>Process Screening

It may give you a usable format.

Re: Add custom formula and columns to Tabulate window

Jackie_ — Mon, 04 Nov 2024 15:39:22 GMT

Thanks Jim, is there a way to get LSL and USL columns in the window table?

Re: Add custom formula and columns to Tabulate window

txnelson — Mon, 04 Nov 2024 16:15:49 GMT

I am not completely sure what you are asking for, however below is a guess. I ran the Process Screening on a subset of the Semiconductor Capability that only has 2 lots. I placed lot as a By column

I then used the red triangle in the output window and added the Spec limits to the output window.

Next, I right clicked on the displayed report and selected "Make Combined Data Table"

Finally I went into Tabulate and generated a table that somewhat resembles what you originally showed

Re: Add custom formula and columns to Tabulate window

hogi — Mon, 04 Nov 2024 22:15:30 GMT

What's great about JMP is that for all kinds of aggregations, there is at least one platform which provides the aggregation option.

I wonder who decides which platform gets which aggregation option - and which platform doesn't get an aggregation option ...

To keep it slim, OK, on the main level just list the aggregation options which were selected for the respective platform.

My Dream:
In a submenu, please list all aggregation options:

No platform which has to stand behind the others :)

N Categories, Kurtosis, and maybe yes: Cpk : )