Re: DashboardDo you have JMP 17? If so, you might consider using the Workflow Builder to create your dashboard, as it will remember column names/assignments.
Re: DashboardDid you check the Database settings - Perhaps "Location" is set to Prompt?

Re: DashboardNot all "Location" options work, I still have the same problem.
Re: Dashboard@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.
Re: DashboardI 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"
Re: DashboardYes 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.
Re: DashboardHow 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
DashboardHello 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
Mass CustomizationQuality and Process Engineering