topic Re: want scripted Graph Builder to show control limits that are saved as Column Properties in Discussions

want scripted Graph Builder to show control limits that are saved as Column Properties

tim_reeves — Sun, 11 Jun 2023 11:19:13 GMT

I have a script that opens a data table and generates charts with Graph Builder. Many columns in the table have control limits saved as column properties. How can I get the Graph Builder to display the control limits on the charts? I'd use Control Chart builder but I haven't been able to make that work with column switcher.

Edit: I figured out how to make the columns switcher work with Control Chart Builder, but I'd still prefer to use Graph Builder because it lets me color or overlay by a column which Control Chart Builder doesn't let me do. I'd also like to have a logarithmic y-axis sometimes which Control Chart platform doesn't allow.

Re: want scripted Graph Builder to show control limits that are saved as Column Properties

txnelson — Tue, 09 Nov 2021 21:40:07 GMT

I assume the issue is that you have not selected the "Show Limits" in the Spec Limits Dialog window.

Re: want scripted Graph Builder to show control limits that are saved as Column Properties

tim_reeves — Mon, 15 Nov 2021 18:02:25 GMT

That would work for Spec Limits but it doesn't work for control limits. These are pre-calculated control limits that have been stored as column properties.

Re: want scripted Graph Builder to show control limits that are saved as Column Properties

txnelson — Mon, 15 Nov 2021 22:29:39 GMT

Oops, my error

You can add an Add Ref Line to your code.

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Big Class.jmp" );
biv = Bivariate( Y( :weight ), X( :height ), FitLine );
rbiv = biv << report;
axisbox = rbiv[axis box( 1 )];
axisbox << Add Ref Line(
	108.3182, "Dashed", blue, "M mean", 2
);
axisbox << Add Ref Line(
	100.9444, "Dotted", red, "F mean", 2
);

The main item you will have to add to this, is to code to extract the Control Limits. You can use

CL = :weight << get property("Control Limits");

retrieve the limits. Take a look at what is retrieved into CL, so you can determine how to parse out the limits you need.