Variability Plot Loop for all selected columns with user specified setting

Question

Hello guys,

I am fairly new to JMP Scripting. I need a small support. I am now designing a application which does the following

Step 1: when user clicks a button. Variability chart window opens where we specify all columns for plotting, x axis grouping and all setting from current active data table

obj = dt << Variability Chart();

Step 2:  I want to get the user specified items in seperate variables like

col_list = list of all columns selected in obj

x_grouping = all x variables specified

.. for all arguments for Variability Chart()

Step 3: after extracting all info.. Now i will run a loop for each column variable but

for i==1 (first column) i will plot the chart in report ... user will do some changes (eg add legend specify background color etc)

now i will apply this template(all settings in this plot) to all column and create a report in new window for each column.

I am facing problem in following : step 2 and step 3 how to extract the arguments for Variability Chart() and perform the action

P.S: i am also planning to parallely implement this for other chart types \

Please guide

txnelson · Accepted Answer

Step 1

obj = dt << Variability Chart();

will open the Variability Chart dialog box, and when the user clicks on OK, all of the charts will be run at that time.

However, once the Variability Chart has been run, you can query the script returned from the Variability Chart Platform and get the X's and Y's

obj = Variability Chart( Y( :NPN1, :PNP1 ), Model( "Main Effect" ), X( :SITE ) );

theScript = char(obj << get script);
theYsList = words(word(1,substr(theScript,contains(theScript,"Y(")+2),")"),",");
theXsList = words(word(1,substr(theScript,contains(theScript,"X(")+2),")"),",");

For step 2, you can query the Displayed Plot directly and get the various settings.  Take a look in the Scripting Index for how to get the framesize, min and max and increment for the various axes etc, that you will need to apply to the additional applications of the Variability Chart.

I think that your suggested approach is going to be more trouble than benefit.  I suggest that rather than using the Variability Chart dialog box, but you rather create your own dialog box, resembling the  Variability Chart dialog box, which will then set you get all of the information you need up front, and then steps 2 and 3 will become much easier to implement.

See the Scripting Guide for information on how to create your own new window.dialog box

txnelson · Accepted Answer

Here is an example of one way to handle what I believe you want to do.  The script is very incomplete, and needs a lot of exception handing added to it, but it should give you a starting point.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
nw = New Window( "Col List Box Example",
	modal,
	H List Box(
		Col List Box( all, width( 250 ) ),
		V List Box(
			Lineup Box( N Col( 2 ),
				ybb = Button Box( "Y Col" ),
				Y = Col List Box( Show( "run" ) ),
				xbb = Button Box( "X Col" ),
				x = Col List Box(),
				Button Box( "Cancel",
					nw << close window;
					Throw();
				),
				Button Box( "OK",
					ycols = y << get items;
					xcols = x << get items;
				)
			)
		)
	)
);

// ycols and xcols now have been populated and you can then bring up one graph and
// let the user make the changes
nw = New Window( "Graphical Settings",
	modal,
	vc = dt << Variability Chart( Y( ycols[1] ), Model( "Main Effect" ), X( xcols[1] ) );
	vc << on close( 
		// In the closing of the Variability Chart capture the script
		theScript = Char( vc << get script );
	);
);

// Run all of the graphs
For Each( {theCol, index},ycols, Eval( Parse( Substitute( theScript, ycols[1], theCol ) ) ) );