topic Re: How to programmatically enable "Show as Graph Reference Lines" in Spec Limits property of a column? in Discussions

How to programmatically enable "Show as Graph Reference Lines" in Spec Limits property of a column?

Neo — Fri, 09 Jun 2023 16:09:41 GMT

I am the recipient of a data table where each column has spec limits defined under its Column Property. I would like show these limits as reference lines in my charts when I plot the column data. How do I enable "Show as Graph Reference Lines" in Spec Limits property for each and every (or some selected) columns in a data table?

Re: How to programmatically enable "Show as Graph Reference Lines" in Spec Limits property of a column?

jthi — Wed, 10 May 2023 11:36:07 GMT

I think using Manage Limits is easiest option even without any scripting

and it is also fairly simple to script

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");
obj = dt << Manage Limits(Process Variables(dt << Get Column Group("Processes")));
Wait(1);
obj << Show Limits All;
obj << Save to Column Properties;
//obj << Close Window;

Re: How to programmatically enable "Show as Graph Reference Lines" in Spec Limits property of a column?

Neo — Wed, 10 May 2023 12:18:34 GMT

@jthi

On JMP 16.2.0 doing it manually works (i.e. all grouped columns get the "Show as Graph Reference Lines" checked) but the script is not working i.e. "Show as Graph Reference Lines" remain unchecked.

Re: How to programmatically enable "Show as Graph Reference Lines" in Spec Limits property of a column?

jthi — Wed, 10 May 2023 12:28:29 GMT

Try Manage Spec Limits for JMP16

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");
obj = dt << Manage Spec Limits(Process Variables(dt << Get Column Group("Processes")));
Wait(1);
obj << Show Limits All;
obj << Save to Column Properties;//obj << Close Window;

Re: How to programmatically enable "Show as Graph Reference Lines" in Spec Limits property of a column?

Neo — Wed, 10 May 2023 16:00:18 GMT

@jthi

Thanks JMP16 version of the script works but the end result of having the LSL/USL on the chart as reference lines is not satisfactory. JMP appears to automatically place the text LSL and USL at the extremities of the Y axis and the reference lines are hidden outside the visible y-axis range. Any way to fix this?

Re: How to programmatically enable "Show as Graph Reference Lines" in Spec Limits property of a column?

Mark_Bailey — Thu, 11 May 2023 16:37:47 GMT

How would you adjust the scale with the data and the limits manually? I am not asking about the steps taken. I am asking about your criterion.

Re: How to programmatically enable "Show as Graph Reference Lines" in Spec Limits property of a column?

Neo — Tue, 16 May 2023 09:27:57 GMT

@Mark_Bailey I have explained the issue here https://community.jmp.com/t5/Discussions/How-to-show-USL-LSL-lines-enabled-via-the-property-quot-Show-as/m-p/631433#M82968 . Apparently on a more recent JMP version, a satisfactory result could be expected. I am (we are) on 16.2.0 and do not want to upgrade yet.