BookmarkSubscribe
Choose Language Hide Translation Bar
xdcurryx
Community Trekker

Add Spec Limits to Tabulated Column

Hello,

 

I am trying to add spec limits to a new column that I created via Tabulate, but cannot get JMP to recognize the column in which I want to add spec limits to. Here is the portion of the code I am working on.

 

tab = dt << Tabulate(
Show Control Panel( 0 ),
Add Table( Column Table( Analysis Columns( :Data ), Statistics( Mean ) ), Row Table( Grouping Columns( :Pitch # ) ) ),
invisible,

);
dt_tab = tab << make into data table;
dt_tab << set name( "Avg Pitch Length" );

dt_tab = Current Data Table( )
Column( "Mean(Data)" ) << Add Column Properties( Set Property( "Spec Limits", {LSL( 853 ), USL( 858 ), Target( 855.5 ), Show Limits( 1 )} ) );

 

When I debug the script, it says "could not find column in access or evaluation of 'Column', Column/*###*/("Mean(Data)"). Mean(Data) is the column name that the tabulate function automatically assigned to the new column, but JMP doesn't recognize that column name. What am I doing wrong?

Thanks!

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Add Spec Limits to Tabulated Column

try changing to the following

Current Data Table(dt_tab )
Column( dt_tab,"Mean(Data)" ) << Add Column Properties( Set Property( "Spec Limits", {LSL( 853 ), USL( 858 ), Target( 855.5 ), Show Limits( 1 )} ) );
Jim
0 Kudos
2 REPLIES 2
txnelson
Super User

Re: Add Spec Limits to Tabulated Column

try changing to the following

Current Data Table(dt_tab )
Column( dt_tab,"Mean(Data)" ) << Add Column Properties( Set Property( "Spec Limits", {LSL( 853 ), USL( 858 ), Target( 855.5 ), Show Limits( 1 )} ) );
Jim
0 Kudos
xdcurryx
Community Trekker

Re: Add Spec Limits to Tabulated Column

Awesome that worked, thanks so much! I'm still new to JMP so I appreciate the help!

0 Kudos