topic Re: How to add reference line if you don't know what column you will use in Discussions

How to add reference line if you don't know what column you will use

miguello — Fri, 09 Jun 2023 15:59:13 GMT

I'm stuck at a seemingly simple task.

I plot a Graph Builder where my Y axis isn't known yet, it's provided as a variable.

So what do I put in here instead of MyYVariable to draw a reference line regardless of what's on Y axis?

			Dispatch(
			{},
			"MyYVariable",
			ScaleBox,
			{Add Ref Line(
				0.1,
				"Dotted",
				"Medium Dark Green",
				"0.1",
				3,
				1,
				Label Settings( {Label Color( "Green" )} )
			), Label Row(
				{Label Orientation( "Vertical" ), Set Font( "OCR A Extended" )}
			)}
		)

Clarification:

Right now I'm doing that like this:

gbr = gb<<Report;
gbr[axis box( 2 )] << Add Ref Line(
				0.1,
				"Dotted",
				"Medium Dark Green",
				"0.1",
				3,
				1,
				Label Settings( {Label Color( "Green" )} )
			);

but I was wondering if I could do it in the same expression as the GraphBuilder, as I asked.

Re: How to add reference line if you don't know what column you will use

jthi — Wed, 28 Sep 2022 21:25:42 GMT

Is the something wrong with your option2? If you are building graph builder, you should know column names and then you could most likely use or similar method to add the "name" there.

Names Default To Here(1);

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

y_var = Column(dt, "height");

gb_expr = EvalExpr(gb = dt << Graph Builder(
	Variables(Y(Expr(y_var))),
	Elements(Points(Y, Legend(4))),
	SendToReport(
		Dispatch(
			{},
			Expr(y_var << get name),
			ScaleBox,
			{Add Ref Line(63.858764556962, "Solid", "Black", "", 1)}
		)
	)
));

show(gb_expr);

eval(gb_expr);

Re: How to add reference line if you don't know what column you will use

miguello — Wed, 28 Sep 2022 22:38:30 GMT

Nothing wrong with neither mine or yours, I was just hoping that there is a generic way of doing that. Use case: I model GB using graph builder first, where I set up all the reference lines, and ideally just would copy the script. But now I need to delete that part and write it separately as my solution, or tweak it as in your solution.

Anyways, thanks for the input!