809518_en-US

liliconcom

Add custom formula and columns to Tabulate window

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" );<BR />(Data Table( "Semiconductor Capability" ) << Tabulate(<BR />Add Table(<BR />Column Table( Grouping Columns( :lot_id ), Statistics( Mean, Std Dev ) ),<BR />Row Table( Analysis Columns( :NPN1, :PNP1, :PNP2, :NPN2, :PNP3, :IVP1 ) )<BR />)<BR />)) << Make Into Data Table;

Thank you!

Automation and ScriptingRe: Add custom formula and columns to Tabulate window

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:
Col N Categories - and all the others ... 
No platform which has to stand behind the others

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

Re: Add custom formula and columns to Tabulate window

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

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

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

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

@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

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.