- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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 )} ) );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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 )} ) );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Add Spec Limits to Tabulated Column
Awesome that worked, thanks so much! I'm still new to JMP so I appreciate the help!