Dashboard not updating as expected.

kom

Hi all. I'm running 3 simple & identical scripts to create SPC charts for Operators. The idea is that they'll enter basic test results, click one button and then observe for shifts/trends/outliers.

 

Rather than displaying all of the data on the charts, the scripts are setup to show just the last 30 datapoints on the SPC charts. When I add (say) 10 more rows of data, the scripts move on as planned, and life is good. I've created a simple dashboard (my first) to display all 3 SPC charts side by side. Each time I run the script for the 1st time, it looks exactly like I want it to look, i.e. each of the 3 charts display the last 30 datapoints.

 

However, when I add (say) 10 rows of data to my data table & run the script again, the 3 charts in the dashboard don't move on automatically as they do when I run the scripts individually (outside of the dashboard). The data has been added to the charts in the dashboard, but I can only see the data by manually sliding the X-axis. Am I missing something obvious here?

3 Scripts - Fat Moisture Salt.jmp

danschikore

Your script dynamically sets the Min/Max of the x axis based on nrows():

 

	Dispatch(
		{},
		"label",
		ScaleBox,
		{Min( nrows()-30 ), Max( nrows()+3 ), Inc( 1 ), Minor Ticks( 0 )}
	),

When a report is added to Dashboard Builder (or Combine Windows), the script that it captures is the same as you would see with <<Save Script to Script Window, which has hardcoded parameters:

 

	Dispatch(
		{},
		"label",
		ScaleBox,
		{Min( 24 ), Max( 57 ), Inc( 1 ), Minor Ticks( 0 )}
	),

It is possible to edit Platform scripts in Dashboard Builder, but that will not help in this case because every time the script is saved it will recapture the script again.  This is necessary in order to incorporate changes like open/close of outlines, or other changes that have been made while in preview mode.

 

In this case, the easiest solution might be to edit the dashboard script directly.  If you are saving a .jmpapp / .jmpappsource file, you can just edit this file with any text editor.  If you are saving to a table script, it maybe best to use Save Script to Script Window for the Dashboard, edit the script, and then copy/paste into a table script.  Note that if you use Save Script to Script Window, the syntax of the script will be JMPApp(...) << Edit.  Change this to JMPApp(...) << Run to create a dashboard that will run the analysis rather than opening the Dashboard Builder.