cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Abby_Collins14
Level III

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?

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!

3 ACCEPTED SOLUTIONS

Accepted Solutions
txnelson
Super User

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?

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;
Jim

View solution in original post

jthi
Super User

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?

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) 

-Jarmo

View solution in original post

hogi
Level XII

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?

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.

View solution in original post

3 REPLIES 3
txnelson
Super User

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?

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;
Jim
jthi
Super User

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?

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) 

-Jarmo
hogi
Level XII

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?

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.