Dashboard

[#1]

Hello everyone,

I created a Dashboard on JMP, this Dashboard uses different Excel databases.

The Dashboard runs through a JMP script.

However, I wish I could make this script even better.

The problem is that when running the script I have 2 problems:

1 - Having to manually assign the corresponding tables each time

In my Dashboard script, each Excel file is well populated (path + corresponding sheets)

2 - When I run the script and I do the correspondence between the tables, a "Dashboard preview" interface occurs. In the best case, how could I remove/skip this step to have direct access to the final Dashboard?

Thanks for your help !

Cordially

[#2]

Do you have JMP 17? If so, you might consider using the Workflow Builder to create your dashboard, as it will remember column names/assignments.

[#3]

Yes I use JMP 17, the script for my Dashboard works correctly. However, I just wish I could improve it without having to start all over again.

[#4]

Did you check the Database settings - Perhaps "Location" is set to Prompt?

[#5]

Not all "Location" options work, I still have the same problem.

[#6]

@hcarr01 - Can you clarify which options do not work as expected?  Some will require additional steps - for example if the Location is set to `Script`, the table will need to be opened / created in the JSL defined in the Application.  To edit scripts in a Dashboard you will need to turn off Dashboard Mode.

If you want the tables to simply open from the location defined in the Path property, you can use the `Full Path` option.  This is the behavior when opening a .jmpapp file for editing.  The Location field is used when running a JMP App/Dashboard to allow for the app to run on different tables.

[#7]

I tried the different options, including "Full Path" as you indicate:

By using this option, my script no longer finds the "tank 1" table in my data tables, as you can see below:

I have this problem for all the different options except for "Embedded Script"

[#8]

How I make my dashboard work with no prompts is to have the files open already then use this type of code in the dashboard script:

	Tables(
		DataTable1 = GuiTable(
			Set Path( "1st FPI summary data.jmp" ),
			Set Label( "1st FPI summary data" ),
			Location( "Name" ),
			Invisible( 0 )
		),

for item # 2, make sure the dashboard script ends with << Run; not << Edit.

Hope this helps!

Steve