cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
alavy
Level II

Selecting multiple tables to insert into a dashboard, without GUI.

 

Hi everyone,

I would like to create a dashboard that displays two tables, one of which is also used for some plots.

When I read the code generated by the dashboard Wizard, I see that DataTable1 and DataTable 2 are assigned with data tables using GuiTable (see code below). However I would like to fully automate the process so the user will not be prompted at all.

JMP App(
	Set Name( "Dashboard" ),
	Set Description( "Selection in one report filters the second" ),
	Auto Launch( 1 ),
	Snap To Grid( 1 ),
	Show Grid( 1 ),
	Show Properties( 0 ),
	Show Sources( 0 ),
	Group By Category( 0 ),
	Dashboard Mode( 1 ),
	Parameters,
	Tables(
		DataTable1 = GuiTable(
			Set Path( "" ),
			Set Label( "This Table" ),
			Set Location( "Name" ),
			Set Invisible( 0 )
		),
		DataTable2 = GuiTable(
			Set Path( "" ),
			Set Label( "That Table" ),
			Set Location( "Name" ),
			Set Invisible( 0 )
		)
	),

I tried replacing the relevant section with: 

Tables(
		DataTable1 = Data Table ("This Table"),
		DataTable2 = Data Table ("That Table")
		)

But the result is that only one table shows up, and the plots are generated based on that one plot.

 

How do I get the specific tables into the dashboard without asking the user for input?

 

A somewhat unrelated question, could anyone please refer me to a page that shows how to create multiple tabs in a dashboard using the Dashboard wizard?

 

Thank you all!

 

1 ACCEPTED SOLUTION

Accepted Solutions
alavy
Level II

Re: Selecting multiple tables to insert into a dashboard, without GUI.

The solution was to remove the DataTable objects that the Dashboard wizard created, and replace them with the data table objects that I had, not to use tables names at all. So using this code, and replacing any reference to DataTable1 and DataTable2:

Tables(	thisTable, thatTable )

 

Rather than using the structure that was suggested by the wizard:

Tables(
		DataTable1 = Data Table ("This Table"),
		DataTable2 = Data Table ("That Table")
		)

 

 

View solution in original post

2 REPLIES 2
alavy
Level II

Re: Selecting multiple tables to insert into a dashboard, without GUI.

The solution was to remove the DataTable objects that the Dashboard wizard created, and replace them with the data table objects that I had, not to use tables names at all. So using this code, and replacing any reference to DataTable1 and DataTable2:

Tables(	thisTable, thatTable )

 

Rather than using the structure that was suggested by the wizard:

Tables(
		DataTable1 = Data Table ("This Table"),
		DataTable2 = Data Table ("That Table")
		)

 

 

twalk
Level II

Re: Selecting multiple tables to insert into a dashboard, without GUI.

I am having trouble with referencing tables in the app builder in JMP 15. It looks like this might help, but I'm not understanding all of the objects. Your table names seem to be "This Table" and "That Table". What are "thisTable" and "thatTable"? Are they table objects or references to table names? Where did you initialize them?