topic Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID? in Discussions

How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Wed, 04 Oct 2023 16:08:29 GMT

My data table has got part_ID entries in column 1. In column 2, the 5 summary parameters - Min, Q1, Median Q3, Max and the test limits LSL, USL appear. In column 1 the part ID is repeated 7 times (corresponding to 5 summary parameters + LSL & USL, total 7) after which the next part ID appears (and corresponding 7 numbers in column 2).

I do not want to change the format of the data table (i.e. do not want to transpose).

I want to create box plot trend chart (with part ID on X-axis) using the 5 summary parameters and the limits. How to do this via JSL?

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

jthi — Wed, 04 Oct 2023 16:14:32 GMT

Is there some specific reason of not changing the data format to something better?

From

to something easier to manage

If you don't have any indicator which row is which, are you sure they are always in the same order?

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Wed, 04 Oct 2023 16:45:21 GMT

@jthi Thanks. My original data is in the form of your bottom table but additionally with measured parameter name as an additional column. In this form I know how to do the box plots using the 7 parameters.

I use JMPs Summary () function to get my data in the form of your top table.

I need this form to plot other charts in the format I want where the measured parameter data (e.g. your column 3 in the top table) in a column. There are multiple measured parameters for the same part with different ranges (appearing in separate columns) which I plot on the Y-axis and only having the data for different measured parameters in columns allows me to have the different Y-axis scale for them in JMP (with part ID on X-axis). Different measured parameter are correlated and such a plot helps understanding the relative trends.

Hope above explains why my data is in a format of your top table.

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

jthi — Wed, 04 Oct 2023 19:14:39 GMT

This post might give some ideas .

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Thu, 05 Oct 2023 09:17:01 GMT

@jthi . Thanks. I have looked at the recipe in your link. The described method only seem to work when the data is the format of your second table, which is not what I want.

If it is possible to tell JMP to create box plots using Min, Q1, Median, Q3, Max given in an adjacent column (Label in attached example data set) for a given part ID (column 1 in attached) instead of it JMP calculating these values itself from the distribution of the values for each part, I think I will get what I want. Is this possible to do via JSL?

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

jthi — Thu, 05 Oct 2023 17:02:04 GMT

You could try building the boxplot using Rect() and Line() (there is also box plot seg which might work, but you need to simulate the data or use frequencies).

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Fri, 06 Oct 2023 09:35:22 GMT

@jthi Thanks, I think, the box plot seg can be used to do what I want.

From the scripting index example, It is not clear to me how one would generate the box plot for each part ID (on x axis) as in my example data (attached before)

Would I need to loop through the part ID? In which case, how to decide the frame size, scale?

It would be useful if I could get basic example using my example data.

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

jthi — Fri, 06 Oct 2023 11:13:22 GMT

It might be that box plot seg can only be used to create single box plot for a single frame box and it will be in the center

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Fri, 06 Oct 2023 12:42:02 GMT

@jthi Thanks.

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

jthi — Fri, 06 Oct 2023 13:30:01 GMT

If you are forced to the data format you have, you can still add new columns to the table. You can create one column for each of the statistics to follow option one in the earlier link or add two columns (value + freq) and then follow the second option. Or build it fully customized from different parts using graphic script

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Fri, 06 Oct 2023 18:59:45 GMT

@jthi . The whole reason for having the data in format of your top table (and mine which is attached) is only so that I can have different scales in a group by Y plot.

https://community.jmp.com/t5/Discussions/Can-you-change-y-axis-scale-independently-from-other-y-axis/td-p/17649

I do not want to you the Page option so I went and followed @txnelson 's suggestion to put the relevant data in form he suggested i.e. in separate columns (assuming I have understood his suggestion correctly).

If there is any other way without using Page or @txnelson 's suggestion (another similar here), I am all ears :).

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Thu, 19 Oct 2023 11:54:03 GMT

@jthi Thanks for your suggestions on this topic which I am returning to as I have to keep the data format as in my example data attached in this thread earlier. I can get almost what I need with the script below (there could be better ways to do this but below is my tale). I need help with two things.

I need to draw a vertical black line connecting Min and Max for each partID (currently not selected in the local data filter, left chart below). When Min/Max is selected in the local data filter (right chart below), they get connected by a vertical black line (in place of black dots now on right chart), I will get to almost the anatomy of a box plot, which I think is enough and fit for purpose. How to get this vertical line via JSL for each part ID (V Line ()?)?
Secondly, my measured parameters (Current, Resistance in the example data) in actual data will be >40. So, I do not want to do the Legend color setting the way I have done in my script. How to set the legend color as black by default (otherwise JMP colors each Y-group differently and not how I have set the marker colors).

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

//Set LSL/USL marker and color
dt << Row Selection(
	Select where( Contains( :Label, "LSL" ) | Contains( :Label, "USL" ) ),
	Match case( 1 ),
	Dialog( Edit( Contains( Source Column( :Label ) ) ) )
) << Markers( 29 ) << Colors( "Red" ); 
dt << Clear Select;

// Set Q1/Q3 marker and color
dt << Row Selection(
	Select where( Contains( :Label, "Q1" ) | Contains( :Label, "Q3" ) ),
	Match case( 1 ),
	Dialog( Edit( Contains( Source Column( :Label ) ) ) )
) << Markers( 29 ) << Colors( "Black" ); 
dt << Clear Select;

//Set Median arker and color
dt << Row Selection(
	Select where( Contains( :Label, "Median" ) ),Match case( 1 ),
	Dialog( Edit( Contains( Source Column( :Label ) ) ) )
) << Markers( 0) << Colors( "Blue" ); 
dt << Clear Select;

// Plot chart
gb = Graph Builder(
	Size( 404, 412),
    Show Control Panel( 0 ),
	Variables( X( :partID ), Y( :Resistance ), Y( :Current ) ),
	Elements( Position( 1, 1 ), Points( X, Y, Legend( 37 ), Jitter( "None" ) ) ),
	Elements( Position( 1, 2 ), Points( X, Y, Legend( 35 ), Jitter( "None" ) ) ),
	Local Data Filter(
		Add Filter(
			columns( :Label ),
			Where( :Label == {"LSL", "Median", "Q1", "Q3", "USL"} )
		)
	),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				37,
				Properties( 0, {Line Color( 0 )}, Item ID( "Resistance", 1 ) )
			), Legend Model(
				35,
				Properties( 0, {Line Color( 0 )}, Item ID( "Current", 1 ) )
			)}
		)
	)
);

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Thu, 19 Oct 2023 12:11:04 GMT

This additional script added to above gives what is desired using V Line ().

Example only for PartID =1 (chart below). How to make this automatic in a loop?

gbr = gb << report;

// For FrameBox (1)
Q1_Part1_Para1 = 2.75;
Q3_Part1_Para1 = 3.1;

// For FrameBox (2)
Q1_Part2_Para1 = 250;
Q3_Part2_Para1 = 302; 

PartNo = 1;

Eval(EvalExpr(gbr [Framebox (1)]<< Add graphics Script (
					Pen color (black); V Line (PartNo-1, Q1_Part1_Para1, Q3_Part1_Para1);	
				)));
				
Eval(EvalExpr(gbr [Framebox (2)]<< Add graphics Script (
					Pen color (black); V Line (PartNo-1, Q1_Part2_Para1, Q3_Part2_Para1);	
				)));

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

jthi — Thu, 19 Oct 2023 12:32:04 GMT

You can use Summarize() to get unique partID values. Then you can use datatable subscripting with combination of Loc() to get rows for for specific partID while loopping. Then calculate/get your values and add your lines

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Thu, 19 Oct 2023 13:32:24 GMT

@jthi

>>You can use Summarize() to get unique partID values.

>>Then you can use datatable subscripting with combination of Loc() to get rows for for specific partID while looping.

Never used Loc (). Does this give me the X coordinate for each partID. An example with my example data would be vey useful.

>> Then calculate/get your values and add your lines.

Do you mean, calculate X coordinates for each part as other numbers Min, Max, Q1, Q3 and Median are already calculated?

Also, do I need to loop through each FrameBox or is there a more straightforward alternative?

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

jthi — Thu, 19 Oct 2023 13:27:39 GMT

Your partIDs are in same order in the graph as they are in the table (and Summarize) so you have already the x-coordinate. If you have all the values you need already calculated, you can just retrieve them from data table. Below is example using Summarize, Loc and datatable subscripting

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

Summarize(dt, uniq_vals = by(:age)); // Summarize returns characters

For Each({uniq_val}, uniq_vals,
	val_rows = Loc(dt[0, "age"], Num(uniq_val));
	show(val_rows);
	f_rows = val_rows[Loc(dt[val_rows, "sex"], "F")];
	show(f_rows);
	f_heights = dt[f_rows, "height"];
	show(f_heights);
);

You have only two frame boxes but multiple lines you wish to add inside those, so there should be no need to loop over FrameBoxes (loop over the partIds)

Edit:

Also instead of Loc you could use << Get Rows Where as it is usually easier to use

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Thu, 19 Oct 2023 13:38:25 GMT

@jthi . OK. Thanks. I will give this a shot (will come back if I get stuck).

In my actual data set, the number of measured parameters is >50 (could be more) so if I were to plot all 50 parameter trend plots on top of each other, there will be 50 FrameBoxes, hence my question on looping over FrameBoxes.

Also, for my PartID = 1, I ad to use the X= 0, for the X coordinate in V Line () in my script above. Is this how this is supposed to be (i.e. the x coordinate for V Line starts from 0 and not 1, even though it shows 1)?

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

jthi — Thu, 19 Oct 2023 13:40:55 GMT

If there are that many parameters having additional loop is a good idea.

And for the X = 0 thing, I would suggest try it. See what happens (this way you usually learn the most). You can also see from X-axis settings that the value is 0 and label 1

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Thu, 19 Oct 2023 14:45:55 GMT

@jthi OK. Thanks. One more thing is bothering me. I have switched off the jitter in my script, but the top (Q3) and bottom (Q1) markers are still appearing with an offset. You can run my script with the data table attached before to test this (I am on JMP 16.2).

Is there another Jitter setting I need to switch off.

The jitter/offset is more evident if I use the following to set markers for Q1 and Q3 (just trying to get the box shape before I draw the vertical line), but even with horizontal marker I see some offset. Am I missing something?

// Q1/Q3 marker and color
dt << Row Selection(Select where(Contains( :Label, "Q3" ) ),Match case( 1 ),Dialog( Edit( Contains( Source Column( :Label ) ) ) )
) << Markers( "Π" ) << Colors( "Black" ); 
dt << Clear Select;

dt << Row Selection(Select where( Contains( :Label, "Q1" ) ), Match case( 1 ),	Dialog( Edit( Contains( Source Column( :Label ) ) ) )
) << Markers( "Џ" ) << Colors( "Black" ); 
dt << Clear Select;

The offset could be due to JMPs rendering of the chart, depending on the Size () set under Graph Builder (). Stretching the chart horizontally is fixes some offset on some but not all points.

Re: How to create Box Plots when 5 summary parameters (Min, Q1, Median Q3, Max) and Limits (LSL, USL) are in a column corresponding to a given part_ID?

Neo — Thu, 19 Oct 2023 14:46:59 GMT

checking this way

frame = (gbr)[FrameBox( 1 )];
seg = (frame << FindSeg( Marker Seg( 1 ) ));
{method, axis, limit, spacing, seed} = seg << Get Jitter();

I do get a value of "seed" even after setting Jitter to none

{"None", "XY", 1, 0, 184430754}

Are my points jittered (they do appear so)?