topic Re: Change Line Color and Line Style in all platforms in Discussions

Change Line Color and Line Style in all platforms

vikramavtar — Thu, 28 Nov 2024 22:23:16 GMT

I am looking for a method to automatically change line color and style on all platforms (Distribution, variability, bivariate, oneway) for all columns with spec limits.

I loaded spec limits from "Limits Table" at "Analyze-Quality and Process-Manage Spec limits" and saved to column properties.

These spec limits are shown as reference lines in all platforms ((Distribution, variability, bivariate, oneway) which is great.

But, default line color (Blue) and style are not ideal.

Is there a way to automatically change line color and style for all columns ?

I can manually line color and style one at a time within each platforms, but that is too manual when trying to create hundreds of charts.

I am using JMP 16.1.0

Thank you

Vikram

Re: Change Line Color and Line Style in all platforms

jthi — Fri, 29 Nov 2024 12:25:56 GMT

I don't think you can set any specific color for spec limits column property which would apply to all platforms. You can attempt to create a script which you could run when you want to recolor all the spec limits in the open report(s). This is most like quite annoying to do as platforms do not handle spec limits in same way.

Here is a wish list item related to this

Re: Change Line Color and Line Style in all platforms

vikramavtar — Fri, 29 Nov 2024 13:45:53 GMT

Can you please give me sample script that can recolor and change reference line style for all the spec limits in the open report(s) ?
Just looking for ideas / starting point.
Thank you

Re: Change Line Color and Line Style in all platforms

jthi — Fri, 29 Nov 2024 13:58:21 GMT

Which platforms? Do they have to be spec limits or could you create new lines on top of them? Are the reports created via a script or does it have to work with any report user has created manually?

Re: Change Line Color and Line Style in all platforms

vikramavtar — Fri, 29 Nov 2024 14:12:46 GMT

Ideally all of these platforms ((Distribution, variability, bivariate, oneway.

New lines on top of spec limits is ok, but please note that spec limits in my data table are already saved as column property.

Ideally, looking to update line colors and styles for any report user creates manually.

Thanks.

Re: Change Line Color and Line Style in all platforms

jthi — Fri, 29 Nov 2024 14:59:34 GMT

Some platforms use ref lines and some use graphic scripts for this.

Distribution, Graph Builder, One Way, Variability Chart - use ref lines

Process Capability histogram - uses Graphic Script:

I will only handle the ref lines:

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");

ml = dt << Manage Limits(
	Process Variables(dt << Get Column Group("Processes")),
);
ml << Show Limits All;
ml << Save to Column Properties;
ml << Close Window;

dt << Distribution(
	Stack(1),
	Continuous Distribution(
		Column(:NPN1),
		Horizontal Layout(1),
		Vertical(0),
		Process Capability(Use Column Property Specs)
	)
);

// "Tool script" starts from here
Names Default To Here(1);
abs = Current Report() << XPath("//AxisBox");

idx = 0;
For Each({ab}, abs,
	s = ab << get script;
	For Each({cur_s}, s,
		If(Head Name(cur_s) == "Add Ref Line",
			l = Substitute(Name Expr(cur_s), Expr(Add Ref Line()), Expr(List()));
			If(Contains(l, "LSL") | Contains(l, "Target") | Contains(l, "USL"),
				// this isn't documented
				idx++;
				Eval(EvalExpr(
					ab << Update Ref Line(1, Expr(idx), "Solid", "Orange", l[4], 3);
				));
			);
		);
	);
);

I does require some testing and I will most likely turn this into add-in when I have bit of time