topic How do I use a variable inside the graph builder script with a loop? in Discussions

How do I use a variable inside the graph builder script with a loop?

rleeper — Fri, 15 Sep 2017 18:12:00 GMT

Hi all. I am using a variable CD to keep track of several different products. I would like to use a for loop to run the graph builder and under the Variables function of the graph substitute my variable for the Y axis name.

I have this under graph builder script:

Graph Builder(

Variables( X( :DateTime ), Y( :BLU14031717111005_100_200 ) ),

Elements( Points( X, Y, Legend( 11 ), Jitter( 1 ), Error Bars( "Range" ) ) ),

{},

"BLU14031717111005_100_200",

ScaleBox,

{Add Ref Line( 2120, Solid, "Medium Light Red", "LCL", 2 ),

Add Ref Line( 2340, Solid, "Medium Light Red", "HCL", 2 )}

Dispatch( {}, "400", LegendBox, {Position( {0} )} )

I want to change the :blu14031717........ to a variable that will change depending on the for loop iteration. I would also like the graph title to change with each iteration. Any help would be most appreciated.

Re: How do I use a variable inside the graph builder script?

David_Burnham — Tue, 11 Sep 2018 16:54:28 GMT

Here is an example - it uses the Eval function to evaluate the variable that contains the column reference:

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
For( i = 1, i <= N Cols( dt ), i++,
	yCol = Column( dt, i );
	strTitle = "Graph #" || Char( i );
	Graph Builder(
		Show Control Panel( 0 ),
		Variables( X( :weight ), Y( Eval( i ) ) ),
		Elements( Points( X, Y, Legend( 1 ) ) ),
		SendToReport( Dispatch( {}, "graph title", TextEditBox, {Set Text( strTitle )} ) )
	);
);

Unfortunately I still have no idea how to cut and paste JSL whilst maintaining its formatting - this is what it looks like:

David Burnham

Re: How do I use a variable inside the graph builder script?

rleeper — Tue, 11 Sep 2018 16:55:34 GMT

David,

Thank you!

I just changed one line and now the name of the graph is the column name, you rock!

strTitle = Char( yCol )

Re: How do I use a variable inside the graph builder script?

pmroz — Tue, 17 Jun 2014 12:47:14 GMT

Dave - if you copy/paste the code from JMP to MS-Word, and then re-copy/paste from MS-Word to this forum, it will retain the formatting. Clunky but it works.

Re: How do I use a variable inside the graph builder script?

David_Burnham — Wed, 18 Jun 2014 01:44:33 GMT

Thanks Peter

Re: How do I use a variable inside the graph builder script?

ankursaxena — Thu, 07 Apr 2016 00:44:01 GMT

@Hi,

I have a quick question on this. (If someone sees this message, this comes roughly two years after the last reply).

The above code works perfectly fine for me, but I am not understanding why Eval(i) is used for Y variable in the Graph builder code in the line below. Shouldn't it be Eval(yCol(i)) ? Eval(i) will just give 1,2,3 ... etc ,then how does it work fine?

Variables( X( :weight ), Y( Eval(i) ) ),

Thanks,

-Ankur

Re: How do I use a variable inside the graph builder script?

David_Burnham — Thu, 07 Apr 2016 21:42:52 GMT

You are correct - I think it was a typo - it should be Eval( yCol )