How can i plot multiple reference lines with different values ?

mati — Fri, 09 Jun 2023 18:02:22 GMT

With graph builder I'm trying to put multiple reference lines with different values on a same plot but divided in to different groups. I'm displaying different plots on these groups and want to set limits with different reference lines.
I'm able to put ref lines on both X and Y axis but getting same line on all group of plots.
Need help here

Graph Builder(
	Size( 865, 686 ),
	Variables(
		X( :total_attenuation_db ),
		Y(
			Transform Column(
				"Transform[rate_kbits_sec]",
				Continuous,
				Formula( Num( :rate_kbits_sec ) )
			)
		),
		Group X( :iperf_protocol ),
		Group Y( :bw_mhz ),
		Overlay( :run_tag )
	),
	Elements(
		Line( X, Y, Legend( 6 ) ),
		Points( X, Y, Legend( 7 ) ),
		Caption Box( X, Y, Legend( 8 ), Summary Statistic( "Max" ) )
	),
	SendToReport(
		Dispatch(
			{},
			"total_attenuation_db",
			ScaleBox,
			{Add Ref Line( 94, "Dashed", "Medium Dark Red", "Limit", 2 )}
		),
		Dispatch(
			{},
			"Transform[rate_kbits_sec]",
			ScaleBox,
			{Min( 0 ), Max( 22821.89167292 ), Inc( 1000 ), Minor Ticks( 1 ),
			Add Ref Line( 10000, "Dashed", "Medium Dark Red", "Min Limit ", 2 )}
		)
	)
);

Thanks

Re: How can i plot multiple reference lines with different values ?

txnelson — Wed, 13 Oct 2021 14:41:07 GMT

Any form of grouping within Graph Builder will result in reference line being shared between groups. That is, if there is X grouping, reference lines on the Y axis will flow across all X groups.

The only way that I know of to avoid this, is to generate separate Graph Builder instances, and then have JMP group the resulting instances of Graph Builder. You can accomplish this by subsetting the data table into the rows you need for each graph. Then run Graph Builder on each of the subsets, and place them into a New Window() for the display. You can also use Where Clause processing within a Single Graph Builder instance, and get similar results. Below is an example of that using the Big Class data table.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );
New Window( "graphs",
	Lineup Box( N Col( 6 ), 

		Graph Builder(
			SendToByGroup( {:sex == "F", :age == 12} ),
			Size( 289, 238 ),
			Show Control Panel( 0 ),
			Variables( X( :weight ), Y( :height ) ),
			Elements( Points( X, Y, Legend( 1 ) ) ),
			By(  :sex,:age ),
			SendToByGroup(
				{:sex == "F", :age == 12},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=F, age=12"},
						"weight",
						ScaleBox,
						{Add Ref Line( 105, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=F, age=12"},
						"height",
						ScaleBox,
						{Add Ref Line( 59, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "F", :age == 13},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=F, age=13"},
						"weight",
						ScaleBox,
						{Add Ref Line( 90, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=F, age=13"},
						"height",
						ScaleBox,
						{Add Ref Line( 55, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "F", :age == 14},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=F, age=14"},
						"weight",
						ScaleBox,
						{Add Ref Line( 111.5, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=F, age=14"},
						"height",
						ScaleBox,
						{Add Ref Line( 63, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "F", :age == 15},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=F, age=15"},
						"weight",
						ScaleBox,
						{Add Ref Line( 102, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=F, age=15"},
						"height",
						ScaleBox,
						{Min( 55.0888655110677 ), Max( 64.901549594752 ), Inc( 2 ),
						Minor Ticks( 1 ), Add Ref Line( 57, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "F", :age == 16},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=F, age=16"},
						"weight",
						ScaleBox,
						{Add Ref Line( 113.5, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=F, age=16"},
						"height",
						ScaleBox,
						{Add Ref Line( 62.5, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "F", :age == 17},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=F, age=17"},
						"weight",
						ScaleBox,
						{Add Ref Line( 116, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=F, age=17"},
						"height",
						ScaleBox,
						{Add Ref Line( 62, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "M", :age == 12},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=M, age=12"},
						"weight",
						ScaleBox,
						{Add Ref Line( 103.52, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=M, age=12"},
						"height",
						ScaleBox,
						{Add Ref Line( 56, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "M", :age == 13},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=M, age=13"},
						"weight",
						ScaleBox,
						{Add Ref Line( 92, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=M, age=13"},
						"height",
						ScaleBox,
						{Add Ref Line( 61.5, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "M", :age == 14},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=M, age=14"},
						"weight",
						ScaleBox,
						{Add Ref Line( 105.04, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=M, age=14"},
						"height",
						ScaleBox,
						{Add Ref Line( 66, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "M", :age == 15},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=M, age=15"},
						"weight",
						ScaleBox,
						{Add Ref Line( 116.52, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=M, age=15"},
						"height",
						ScaleBox,
						{Add Ref Line( 64.5, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "M", :age == 16},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=M, age=16"},
						"weight",
						ScaleBox,
						{Add Ref Line( 128, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=M, age=16"},
						"height",
						ScaleBox,
						{Add Ref Line( 68, "Solid", "Black", "", 1 )}
					)
				)
			),
			SendToByGroup(
				{:sex == "M", :age == 17},
				SendToReport(
					Dispatch(
						{"Graph Builder sex=M, age=17"},
						"weight",
						ScaleBox,
						{Add Ref Line( 153.74, "Solid", "Black", "", 1 )}
					),
					Dispatch(
						{"Graph Builder sex=M, age=17"},
						"height",
						ScaleBox,
						{Add Ref Line( 69, "Solid", "Black", "", 1 )}
					)
				)
			)
		)
	)
);

Re: How can i plot multiple reference lines with different values ?

mati — Thu, 14 Oct 2021 06:16:34 GMT

Thanks, i'll give it a try

topic How can i plot multiple reference lines with different values ? in Discussions

How can i plot multiple reference lines with different values ?

Re: How can i plot multiple reference lines with different values ?

Re: How can i plot multiple reference lines with different values ?