topic Re: Instructions or resources for how to take multiple outputs (data tables and reports) from a script and combine them into a dashboard at the end of the script? in Discussions

Instructions or resources for how to take multiple outputs (data tables and reports) from a script and combine them into a dashboard at the end of the script?

Abby_Collins14 — Thu, 03 Oct 2024 21:10:06 GMT

Hi all,

I am fairly new to scripting in JSL. However, I have managed to create a script that creates some summary data tables and analysis output (reports I think) for the given data table I am running the script on. My issue is that all of the results are produced in their own window/data table/report. Is there a way to combine them into one nice dashboard or window at the end of my script so that it is the final and only thing produced? Eventually I would like to turn this into an add-in but have not made one before.

Thanks for any resources or suggestions on how to get started with this!

Re: Instructions or resources for how to take multiple outputs (data tables and reports) from a script and combine them into a dashboard at the end of the script?

txnelson — Thu, 03 Oct 2024 21:50:23 GMT

Here are 3 ways to do this

Names Default To Here( 1 );
dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );

nw = New Window( "The Output",
	dis = dt << Distribution(
		Stack( 1 ),
		Continuous Distribution(
			Column( :height ),
			Horizontal Layout( 1 ),
			Vertical( 0 ),
			Process Capability( 0 )
		),
		Continuous Distribution(
			Column( :weight ),
			Horizontal Layout( 1 ),
			Vertical( 0 ),
			Process Capability( 0 )
		)
	);
	biv = dt << Bivariate( Y( :weight ), X( :height ), Fit Line( {Line Color( {212, 73, 88} )} ) );
);

Names Default To Here( 1 );
dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );


dis = dt << Distribution(
	Stack( 1 ),
	Continuous Distribution(
		Column( :height ),
		Horizontal Layout( 1 ),
		Vertical( 0 ),
		Process Capability( 0 )
	),
	Continuous Distribution(
		Column( :weight ),
		Horizontal Layout( 1 ),
		Vertical( 0 ),
		Process Capability( 0 )
	)
);
biv = dt << Bivariate( Y( :weight ), X( :height ), Fit Line( {Line Color( {212, 73, 88} )} ) );

nw = New Window( "The Output" );

Names Default To Here( 1 );
dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );


dis = dt << Distribution(
	Stack( 1 ),
	Continuous Distribution(
		Column( :height ),
		Horizontal Layout( 1 ),
		Vertical( 0 ),
		Process Capability( 0 )
	),
	Continuous Distribution(
		Column( :weight ),
		Horizontal Layout( 1 ),
		Vertical( 0 ),
		Process Capability( 0 )
	)
);
biv = dt << Bivariate( Y( :weight ), X( :height ), Fit Line( {Line Color( {212, 73, 88} )} ) );

report(dis) << journal;
report(biv) << journal;

Re: Instructions or resources for how to take multiple outputs (data tables and reports) from a script and combine them into a dashboard at the end of the script?

jthi — Fri, 04 Oct 2024 04:12:20 GMT

Scripting Guide does have ok documentation for beginner scripters. If you have time it is worth reading through it, if not just trying to find interesting topics should also work. For example adding different report windows to single new window Construct Display Boxes That Contain Platforms (jmp.com)

Re: Instructions or resources for how to take multiple outputs (data tables and reports) from a script and combine them into a dashboard at the end of the script?

hogi — Fri, 04 Oct 2024 09:05:58 GMT

And the easiest solution:
Use application builder.

Create a new Dashboard and
Just drag the reports to the location you want them to be. Then save the dashboard as a jmpapp.

The script can be shortened, just the data curating steps. As a last step in the code, open the saved jmpapp.

The huge benefit: you can optimize the dashboard via the GUI - independent of the script.