nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Plotting UCL/LCL defined in columns in the row

deveshchugh

Hi,

Can someone share how to script adding LCL/UCL to any type of plot when these limits are defined in a column in that specific row. The table has several parameters being plotted (identified by column Label), so each chart has a different set of limits defined for each of the chart types in that row.

For example(attached), if we had two columns of UCL/LCL in the big class example with stacked data table.

can someone write a short script to produce an overlay plot for height with LCL and UCL as defined for height in the respective column.

Hope the question makes sense.

Thanks!!

bigclass_stacked.jmp

Accepted answers

txnelson

Here is a starter script tat will produce what you want for the sample data table. It generates an Overlay Plot. To do the same for your variability charts, it will take some modifications, since each of the platforms has different options, etc.

Names Default To Here( 1 );
dt = Current Data Table();

// Get all of the by values, since separate code will have to be added for each
Summarize( dt, byVals = by( :Label ) );

// Generate the Plot code
op = Overlay Plot( X( :name ), Y( :Data ), by( :label ) );
	
For( i = 1, i <= N Items( byVals ), i++, 

// Get the LCL and UCL values for this by group
	LCL = :LCL[(dt << get rows where( :Label == byVals[i] ))[1]];
	UCL = :UCL[(dt << get rows where( :Label == byVals[i] ))[1]];

// Generate the code to produce the LCL and UCL reference lines
	Eval(
		Substitute(
				Expr(
					op << SendToByGroup(
						{:Label == __byVals__},
						Y Axis[1] << {{Add Ref Line( __LCL__, "Solid", "Medium Dark Red", "LCL", 1 ),
						Add Ref Line( __UCL__, "Solid", "Medium Dark Red", "UCL", 1 )}}
					)
				),
			Expr( __byVals__ ), byVals[i],
			Expr( __UCL__ ), UCL,
			Expr( __LCL__ ), LCL
		)
	);
);

txnelson

The best way to learn about what charts are available, is to look through the document, Essential Graphing

Help==>Essential Graphing

Then, after you have run a graph, you can select from the red triangle in the graphical output, to save the script. It is from there you will get the code on what you need to use to generate the graphs.

Below is a modification to the script that was previously provided. I have modified it to check to make sure the reference lines are displayed.

Names Default To Here( 1 );
dt = Current Data Table();

// Get all of the by values, since separate code will have to be added for each
Summarize( dt, byVals = by( :Label ) );

// Generate the Plot code
op = Overlay Plot( X( :name ), Y( :Data ), by( :label ) );
	
For( i = 1, i <= N Items( byVals ), i++, 

	// Get the LCL and UCL values for this by group
	LCL = :LCL[(dt << get rows where( :Label == byVals[i] ))[1]];
	UCL = :UCL[(dt << get rows where( :Label == byVals[i] ))[1]];
	
	// Make sure the UCL and LCL values are displayed
	chartMin = Min( :data[dt << get rows where( :Label == byVals[i])]);
	chartMax = Max( :data[dt << get rows where( :Label == byVals[i])]);
	
	If(LCL < chartMin, chartMin = LCL );
	If(UCL > chartMax, chartMax = UCL );
	
	chartRange5% = (chartMax - ChartMin)/20;
	
	chartMin = chartMin - chartRange5%;
	chartMax = chartMax + chartRange5%;
	

	// Generate the code to produce the LCL and UCL reference lines
	Eval(
		Substitute(
				Expr(
					op << SendToByGroup(
						{:Label == __byVals__},
						Y Axis[1] << {{Min( __min__ ), Max( __max__ ),
						Add Ref Line( __LCL__, "Solid", "Medium Dark Red", "LCL", 1 ),
						Add Ref Line( __UCL__, "Solid", "Medium Dark Red", "UCL", 1 )}}
					)
				),
			Expr( __byVals__ ), byVals[i],
			Expr( __UCL__ ), UCL,
			Expr( __LCL__ ), LCL,
			Expr( __min__ ), chartMin,
			Expr( __max__ ), chartMax
		)
	);
);

All comments

txnelson

1. I assume that column Name is the X axis

2. Your LCL and UCL values are all the same for each of the rows where for the rows defined as "Height". Will this be the case, or with a real data table, the LCL and UCL values will change?

3. When you say "Overlay Plot" are you specifically referring to the Overlay Platform in JMP or are you just indicating that the data value is overlayed with the LCL and UCL and the Graph Builder Platform could be used?

deveshchugh

1. I assume that column Name is the X axis

I used overlay plot as an example, any plot which has numeric value on y axis (for example height or weight). X axis can be name as you suggested.

2. Your LCL and UCL values are all the same for each of the rows where for the rows defined as "Height". Will this be the case, or with a real data table, the LCL and UCL values will change?

Limits can change for different category in tha label category. (for to clarify: One LCL/UCL for height, some other UCL/LCL for weight)

Iam attaching plot as an example, that has overlay plot and a variability plot with limits in it. (this was generated manually by adding lines in the plot), I am looking for similar plots.

Thanks a lot for your time!!

Capture.JPG

txnelson

Names Default To Here( 1 );
dt = Current Data Table();

// Get all of the by values, since separate code will have to be added for each
Summarize( dt, byVals = by( :Label ) );

// Generate the Plot code
op = Overlay Plot( X( :name ), Y( :Data ), by( :label ) );
	
For( i = 1, i <= N Items( byVals ), i++, 

// Get the LCL and UCL values for this by group
	LCL = :LCL[(dt << get rows where( :Label == byVals[i] ))[1]];
	UCL = :UCL[(dt << get rows where( :Label == byVals[i] ))[1]];

// Generate the code to produce the LCL and UCL reference lines
	Eval(
		Substitute(
				Expr(
					op << SendToByGroup(
						{:Label == __byVals__},
						Y Axis[1] << {{Add Ref Line( __LCL__, "Solid", "Medium Dark Red", "LCL", 1 ),
						Add Ref Line( __UCL__, "Solid", "Medium Dark Red", "UCL", 1 )}}
					)
				),
			Expr( __byVals__ ), byVals[i],
			Expr( __UCL__ ), UCL,
			Expr( __LCL__ ), LCL
		)
	);
);

deveshchugh

Thanks a lot Jim, this works for the overlay charts. Can you point a reference where I can plot other charts too. The scripting guide is not very helpful.

Also, one more thing, can you add a line which will make sure the limit lines are visible. At present they are not visible.

Thanks again for your time.