topic How can I annotate the background with different colors across different Y-axes? in Discussions

How can I annotate the background with different colors across different Y-axes?

BabyDoragon — Fri, 20 Sep 2024 12:17:47 GMT

The following JSL can annotate the region of 100 to 120 on the X-axis with a different color, but it cannot span across different Y-axes. How can I modify it to annotate different variable on Y-axes with different background colors for different variables?

Names Default To Here(1);

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

gb = dt << Graph Builder(
	Variables(X(:weight), Y(:height),Y(:age)),
	Elements(Points(X, Y, Legend(3))),
	SendToReport(

		Dispatch(
			{},
			"weight",
			ScaleBox,
			{Add Ref Line(100, "Solid", "blue", "", 5),
			Add Ref Line(120, "Solid", "blue", "", 5)}
		)
	)
);

rep = gb << report;
framebox = rep[frame box(1)];
framebox << Add Graphics Script(
	Transparency(0.5);
	Fill Color("Gray");
	Rect(100, Y Origin() + Y Range(), 120, Y Origin() , 1)
);

Re: How can I annotate the background with different colors across different Y-axes?

jthi — Fri, 20 Sep 2024 12:26:21 GMT

You have multiple FrameBoxes when you have multiple axis (or groups or wraps or pages), so you can for example add separate graphic script to each of them. Simplified version below

Names Default To Here(1);

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

gb = dt << Graph Builder(
	Variables(X(:weight), Y(:height), Y(:age)),
	Elements(Points(X, Y, Legend(3)))
);

rep = gb << report;
fbs = rep << XPath("//FrameBox");

fbs[1] << Add Graphics Script(
	Transparency(0.5);
	Fill Color("Gray");
	Rect(100, Y Origin() + Y Range(), 120, Y Origin(), 1);
);

fbs[2] << Add Graphics Script(
	Transparency(0.5);
	Fill Color("Green");
	Rect(100, Y Origin() + Y Range(), 120, Y Origin(), 1);
);

Re: How can I annotate the background with different colors across different Y-axes?

BabyDoragon — Thu, 10 Oct 2024 11:38:05 GMT

Additional Question: How can I draw a color box if the X-axis is of data type "text"?

For example, I want to mark the range from TIM to JOE with a specific color.

Names Default To Here(1);

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

gb = dt << Graph Builder(
	Variables(X(:name), Y(:height), Y(:age)),
	Elements(Points(X, Y, Legend(3)))
);

rep = gb << report;
fbs = rep << XPath("//FrameBox");

fbs[1] << Add Graphics Script(
	Transparency(0.5);
	Fill Color("Gray");
	Rect("TIM", Y Origin() + Y Range(), "JOE", Y Origin(), 1);
);

fbs[2] << Add Graphics Script(
	Transparency(0.5);
	Fill Color("Green");
	Rect("TIM", Y Origin() + Y Range(), "JOE", Y Origin(), 1);
);

Re: How can I annotate the background with different colors across different Y-axes?

jthi — Thu, 10 Oct 2024 11:58:50 GMT

You have to figure out the correct x-axis values and then utilize those

Names Default To Here(1);

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

gb = dt << Graph Builder(
	Variables(X(:name), Y(:height), Y(:age)),
	Elements(Points(X, Y, Legend(3)))
);

rep = gb << report;
fbs = rep << XPath("//FrameBox");

fbs[1] << Add Graphics Script(
	Transparency(0.5);
	Fill Color("Gray");
	Rect(17, Y Origin() + Y Range(), 37, Y Origin(), 1);
);

fbs[2] << Add Graphics Script(
	Transparency(0.5);
	Fill Color("Green");
	Rect(17, Y Origin() + Y Range(), 37, Y Origin(), 1);
);

This can be easy or sometimes very difficult, but you can get the idea by checking X-axis settings and labels

Re: How can I annotate the background with different colors across different Y-axes?

BabyDoragon — Fri, 11 Oct 2024 06:19:20 GMT

How can I use JSL to read the mapping of LABEL and VALUE in the current X-axis? I can't find a method to read the LABEL and corresponding VALUE on the current X-axis.

I would like to use MATCH on the text label to obtain the VALUE, and then highlight the specific range of values with a colored box.

Re: How can I annotate the background with different colors across different Y-axes?

jthi — Tue, 15 Oct 2024 15:26:46 GMT

If I remember correctly... (currently) easiest method is to read it from the data table using Summary table or Summarize.

Re: How can I annotate the background with different colors across different Y-axes?

BabyDoragon — Wed, 16 Oct 2024 04:59:47 GMT

I would like to mark colors on the X-axis in accordance with the user-selected region. However, the X-axis on the chart changes due to the user's use of a local data filter. Since the text form of the X-axis is variable, I cannot specify a fixed value and label correspondence. I hope to directly access the labels and values on the X-axis of the chart or be able to determine the corresponding value and label on the X-axis based on the user's selection on the local data filter. As shown in the script below, I would like to allow the user to select the local data filter and additionally choose the X-axis to be marked with colors. If it is not possible to obtain the currently displayed items on the X-axis of the graph or the selected results on the local data filter, it will not be possible to obtain the corresponding values and labels smoothly. Is there any way to achieve this?"

Names Default To Here(1);

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

gb = dt << Graph Builder(
	Variables(X(:name), Y(:height), Y(:age)),
	Elements(Points(X, Y, Legend(3))),
	Local Data Filter(
		Add Filter(
			columns( :name ),
			Where(
				:name == {"ALFRED", "ALICE", "AMY", "BARBARA", "CAROL", "CHRIS",
				"CLAY"}
			),
			Display( :name, N Items( 15 ), Find( Set Text( "" ) ) )
		)
	),
);

rep = gb << report;
fbs = rep << XPath("//FrameBox");

fbs[1] << Add Graphics Script(
	Transparency(0.5);
	Fill Color("Gray");
	Rect(2, Y Origin() + Y Range(), 4, Y Origin(), 1);
);

fbs[2] << Add Graphics Script(
	Transparency(0.5);
	Fill Color("Green");
	Rect(2, Y Origin() + Y Range(), 4, Y Origin(), 1);
);

Re: How can I annotate the background with different colors across different Y-axes?

jthi — Wed, 16 Oct 2024 05:21:31 GMT

If you have local filter to manage it will most likely get more complicated. Which range do you wish to color? What happens when user filters that out or one end of it?

Re: How can I annotate the background with different colors across different Y-axes?

BabyDoragon — Wed, 16 Oct 2024 05:46:16 GMT

Yes, it does become more complex with the presence of Local data filter. Therefore, I would like to know if there are any techniques to obtain the current items on the X-axis of the Graph or to read the selected options of the Local data filter in order to calculate the mapping table for the current Value and Label.

Re: How can I annotate the background with different colors across different Y-axes?

jthi — Wed, 16 Oct 2024 06:12:46 GMT

You can get different types of values from local data filter and then you can parse/utilize those

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Car Poll.jmp");
dist = dt << Distribution(
	Nominal Distribution(Column(:country))
);

ldf = dist << Local Data Filter(
	Add Filter(columns(:sex), Where(:sex == "Female")),
	Mode(Show(1), Include(1))
);

Show(ldf << get script, ldf << Get where clause, ldf << Get Filtered Rows);

Remember to check for the special case where no rows are being filtered