Subscribe Bookmark RSS Feed

JSL - showing spec limits as graph reference lines

erobinson

Community Trekker

Joined:

Apr 25, 2013

Hi, thanks for reading this.

When viewing a column's spec limits in column properties, there is a check box that enables the display of those spec limits in certain platforms.

I'm trying to figure out a way to show the limits with "Show Limits (1)."

With pre-selected columns, I'm working on the following script:

dt = Open();

dtcols = dt << Get Selected Columns;

addprop = Expr(

For(i = 1, i <= NItems(dtcols), i++,

//  Column(dt, Char(dtcols))<< Set Property( "Spec Limits", {Show Limits( 1 )} ); //setting the SL property erases the current values, enabling the check box but the spec limits are lost. So:

  specs = Column(dt, Char(dtcols)) << Get Property( "Spec Limits" ); //create a copy of the spec limits already in the table,

//  Insert Into(specs, Show Limits(1)); //and somehow add "Show Limits(1)" to the spec limits in "specs", but "specs" is a name and not a list

  Column(dt, Char(dtcols)) << Set Property( "Spec Limits" , {Eval(specs)} );

)

);

addprop;

Any ideas or suggestions will be much appreciated.

Evan

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

I had success uploading the spec limits directly to the column properties and including the Show Limits(1) argument. I had been importing the spec limits when running capability analysis, then trying to activate the "show as graph reference lines" check box in the column properties later which I could never get to work.

3524_SpecRef.png

5 REPLIES
Byron_JMP

Staff

Joined:

Apr 26, 2012

Evan,

The spec limits are displayed in the control chart builder.

dt=("$Sample_Data/New Heights.jmp");

dt<<Control Chart Builder(

Show Control Panel( 0 ),

Variables( Y( :height ) ),

Chart( Position( 1 ) ),

Chart( Position( 2 ) ),

SendToReport(

  Dispatch(

   {},

   "height",

   ScaleBox,

   {Min( 41.255230125523 ), Max( 77.5 ), Inc( 5 ), Minor Ticks( 1 ),

   Add Ref Line( 50, Solid, "Blue", "LSL" ),

   Add Ref Line( 70, Solid, "Blue", "USL" )}

  ),

  Dispatch( {}, "Control Chart Builder", FrameBox, {Marker Size( 2 )} ),

  Dispatch( {}, "Control Chart Builder", FrameBox( 2 ), {Marker Size( 2 )} )

)

)

Solution

I had success uploading the spec limits directly to the column properties and including the Show Limits(1) argument. I had been importing the spec limits when running capability analysis, then trying to activate the "show as graph reference lines" check box in the column properties later which I could never get to work.

3524_SpecRef.png

chrisinphi

Community Member

Joined:

Dec 13, 2016

Would you mind sharing how you did it?  This bug has been driving me insane.  I need to not only enter the spec limits, but also see them when I display data to my team.

mohamed_elhassa

Community Trekker

Joined:

Nov 24, 2015

How'd you do that? Would you mind sending out the code? Does it work for JMP 12 too?

thank you

M

tonya_mauldin0

Joined:

Jan 21, 2015

I would suggest taking a look at the following blog post.

Spec Limit Lines on Graphs