nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dashboard Builder Application Question

Peter_Bartell

Hoping someone can shed some light on my question? I'd like to place two maps side by side using the 2x1 Dashboard Builder template. Each map comes from it's own distinct JMP data table. Everything seems to work well until I run the dashboard from the hot spot. Then I get one blank template square, and the other filled in with the desired map. Both maps populate just fine in Preview mode. Only when I run the dasboard do I get this anomolie. Any thoughts?

Accepted answers

Daniel_Valente

I suspect this will get it for you. Go into the data table view and change the current data table.

Screen Shot 2017-02-07 at 8.24.13 AM.png

I think this is the same type of thing you are trying to do, changing the current data table works for me. Make sure the current data table is that of the leftmost graph (SF Crime in my case, not 311 blocked driveways).

Screen Shot 2017-02-07 at 8.24.13 AM.png

Peter_Bartell

To all following this thread...I placed ALL the columns into one JMP data table via Tables -> Join by Row Number. Drew the maps via the embedded scripts from each original data table which tagged along, and everything works like a charm. Thanks to all for your comments and digging into this.

All comments

MikeD_Anderson

Are both the tables open when you run it from the hotspot?

Peter_Bartell

Yup...both tables open.

MikeD_Anderson

One of the scripters might need to chime in, but I’m betting that you need to have some kind of a hard reference to the second data table…

Best,

M

Peter_Bartell

Thanks Mike...it just seemed odd that the preview mode works fine...but Run Mode...not so. If I try to rebuild the missing map within the dashboard, it only calls the forward most JMP data table, which is the map populated to the other panel. I suspect you are right. I wonder if some sort of virtual join pathway could work? Just still seems odd to work in preview, but not in run, mode, which is why I thought I might be missing something obvious.

O_Lippincott

Do your data tables include source scripts? When they do, a dialog box pops up asking if you want to run it from the source script or reference a table. When you reference a table or the datasets don't have source scripts, I see the same issue you are facing. When you have it run the data tables from the source script each time, both appear in the final dashboard. You could create a source script on your data tables ad hoc by using the JMP Query Builder.

DonMcCormack

Are both the tables saved to disk? I suspect that the one not showing is in memory only. Created at runtime, maybe?

Don

Daniel_Valente

Can you post the script? I'd like to investigate what's going on.

Peter_Bartell

Don: Both data tables are saved to disk at time of starting the workflow.

Peter_Bartell

Thanks Dan...I'm also going to put all the columns needed for both maps into one JMP data table and see if that resolves the issue. There's no reason I can't do this out of one data table for this particular project I'm working on...I just arbitrarily chose two distinct data tables.

JMP App(
	Set Name( "Dashboard" ),
	Set Description( "Two reports arranged horizontally" ),
	Auto Launch( 1 ),
	Snap To Grid( 1 ),
	Show Grid( 1 ),
	Show Properties( 0 ),
	Show Sources( 1 ),
	Group By Category( 0 ),
	Dashboard Mode( 1 ),
	Parameters,
	Tables(
		DataTable1 = GuiTable(
			Set Path(
				"/C:/Users/pebart/Documents/Data/Work Videos & Articles/MidAtlanticCurrentMap.jmp"
			),
			Set Label( "MidAtlanticCurrentMap" ),
			Set Location( "Current Data Table" ),
			Set Invisible( 0 )
		),
		DataTable2 = GuiTable(
			Set Path(
				"/C:/Users/pebart/Documents/Data/Work Videos & Articles/MidAtlanticOpportunityMap.jmp"
			),
			Set Label( "MidAtlanticOpportunityMap" ),
			Set Location( "Name" ),
			Set Invisible( 0 )
		)
	),
	Thumbnail(
		New Image(
			Char To Blob(
				"52434eJy9lvdT010Wh78JCUoLRalSQpEiiAUEJPRICAq80gkgINWlS5MiJAIhICgIKCrEpYkKAeng0gJRgtSX3o0YNYsEE6RId+M7s7v/wM7+cO45n3vOmblzZ557T8ZVGwsBXileAAAELNGX7Dge99uOcnNWitH1AY6DBJhamwJAXTbf/nUoR/OEozGRAADr/m2g1gdBq5w9JctLpg6xHqvEVXuHaRkqK2quq3g102qvQjCvuXlZO8RjYuo+UWJIz9reB3WsOgN04RS6bO3OkWlu0crkbZyC+h889UaQzMlLwqZvCQoCGMgEoP5dsY25fm0Gb576ZT5Ss7DZB8SlMMDcSfTvbChKGO5Y6GBEjhRFFlx/fucOqEljoEmnsLq5oSFP4ao0zKL6c0xbYXxCwuj4ONfhZWGVxMTEnG3iCBb+9tInJKjljtAxEZNwNNAt6YirqdF8bKUcFRV1tVSbxLIQJ9/Q/vR9se2sBP+fK5v5qnys6XPQWheNy4rNTqmLoS/2w6RtYv3kbhvJ+c5yUdEhPTdb3cPfFJU9op4g5LFYUnWhBksH/SNYK1CrWvs5XbwIrAtHFNOemCz+5H3xEEPj9izgbxvawoaswhAatyEhuiV5B/s3dka3svlYmbA80M9N5vfEnqQlaq7fE4hEWJGs5NeKy8EuW1K5di0+73In+wyxxzpNhBK74WAjwRVplf0OU354+pzPu76BzqykGOuEPV/3M4dhs6zobv8GCkMQ3re1+Q9pK35xcDDNq/iKJMYgWPMr63vy/KrpL6Hwrgp+i4jsMgqD4JO6vlcpD1KWeEHlu7YK/cw8k0q4pmJBx5BmH+GfBjn2ISpRy03Kscz4ouERlOksxqGgCNW792TGOSclPk90zl6lLoHiwXQMKGP2XtvYJb7Ux+CyBq0mkkZBL0p4ni64f35Wkzwbijx4IR7OnMBo616A/7qhM9aMxUlvqrlY4vpS+cJf10gf0YooXoeskV9Q7gyaOXjuHvnkI+bT/cNadW/PVmN73dW9Mgy1+MrgrcZiMklDVESwqDsgIFOoTVs4zvzJTKslnk7Nlj+pxkXN3LoeEKgZhYppz296rPXzQr6Tszej1MU3qD88J7r9lP29RTdd75UPeeExeYDw+zJF3FIF96t5x5k8N9zBtzIXuTYhv+mntgd1Uph3eL2Hkfx4Qg2ZHti7NATVw9anv7fv3uI3a/DET1bK9L0hBfgZ/zjvsF24i2SqTcDXO6B9uy8lvt0zP+vG8qJMOWjvAm5DPOUs9bTqTEg6eluaXD4IElPAD4GcQueynu7qM3dWElxez90vT32oF7mjv8WayfpSOM4ucU3JVZw8K/kLutks4oC1y4rOpL3rzYcwEbHcLTVJd7dFb6IvZ1FLKH56a7bc3lNhlObWlpuNGxBeHfFS/JDAcECAV3SPMgmzrmknmD92VKiudqWEBA794Ug2vz3lnUyjCVy5cqzyVNXozBzvQQei1cU2I+3rXq3bUPBUmH+eYYxhdLzLoFOjTuDNV5W8P0ma24mh2pOeFtAgLO17WrDWR+6qNlssH6qKZ1fHUJ+p2YrYbI14A3ZeKfQ6V0c3vN5l4AQ0PCHq8ZyNYMJi2ykjoPZQFf2QYN/wOBdMGnU1La96Mo5IXbWbmrdhsBuOq7j9Wq+fp8zVZ7K8r5i6qRQuJ/g977DHnNKXb6DHdsg6+e/V0+dnWQ7NA0Z9txGID+mMC/fZ65LrF3H3qoPCaJ0CRBtCc7PO5Xz8T3XsHKISQCKR/XP507alWu1YC1GcoLCnq1nGMFswFSWKw4pIHIX0nFRwlYwU+efPPQonkgdBCBAhaRE4mG3czQhiX1U9/kHkorISgE2OWpk6faPJtV+PHqV/kzEsk19QUNbV5amWPRFaeV4eZGdnl5Ofn7qxEdWvV+9DhSkpKaliA50xmIwjgrJwIyOPWSO7vVd9qRC0lZWDrJIQnUAz2B+uqqw0u3WrJeK04ntOxsbG6ZnKMTp9iUK4CwgICNwF9ncjQNtbaFOwlbwS7mMOkIwEH4XxwPX+l+KsJX9amldtDDKAbRaQS/DZKHVkydq08YlV6S7E75qArURW/SVHBo3vMZzd3434BLIXEM7swtTCx4Wkd5luRtQi67/TNyf0J3TY2B6DRDhImYdQxnflEUPRP+Sct5Mc5Vu0+TZyAUo6LWPyCaoah6Bln6wzJ22mLBErQErk8p6uyBQsXe0PIVaA+1sSMVRjGgh7CKxrtdXGYpJak+JNwAYX0mqTbkGTcjXoXxTJBo88k4TIpS28GBmes2K2CmT4YQ9k2z85ixHDZTwPNWiQx+EH0DiqsCGYWUme/vBgbdVXdae3HzhszIfEStuexDWie6enTTM2UMDrTkuwwX1VYbi2Blkdhj6XkuON8Vj7lB12vFZfxEuj9BLgdWXqJDpybpZ4Bhk/zrdsrujhmUsNTEs7YcWFxllWLI7h98fEbmh+Y0csXJxats7x6NAtounSd+LiSDVQKMkaWaXe7vyZcymSDZN4ya5FwWWEFLohCD5Uhdcu+PKcvcJUz+nEStGePgCF5Mn/VfoMrBkj2/C1Sn5o+/Hipjj84PsxMR2pQSPBZfEAdpmnHCphoCN8pc8MbHCyyOmE/7AhsHzkTY5//aiXP0+5nPjHWfHzozHO4qGicWjci/QBfwqpoB6emJ3BZsrvs53b/oxPiF/Y8eS0+7XDEB6PO8RpB3+TivJsJLTYyKFxauRwWtb8vZClsY3k3yT89Un+G4v/nyhFAYfKvhhYQfpasd2r4snAX4pA1xMFDiXpmZnIuLg3P1CqnobR0dEuTYGiUidO2HJAe/ZM9m1v76l5i0Bj0Sc5AGOYiHR1lRobH1ejZ6HKTN3cCs+D+fn5i8vLfd/G2D/k4TExkDw4ODjKnSIhdXe/APNfOsp4vbSlRhcXZTSFR/tfgvWkYVmNxHRNzpshxPWfk1rUzwY3JSaOM/aiM16ZR7xx1612UtcQ49PX11cF4+8d5piV5DwqJBs/lpCWLj+af1U1FcvVqPV+d9OxE8QZogBLc5tLNWZeyf8CXtFN7Q==",
				"base64compressed"
			),
			"png"
		)
	),
	Script(JSL Quote(// This script is executed when the application is run.
// Named objects have been created for the application modules
// (for example, "Module1") and the pre-defined object
// "thisApplication" refers to the application object itself.
// Variables and functions declared here are scoped to the
// Application namespace.

)	),
	Allocate(
		Module1 = Plan(
			PreAllocate,
			Script(JSL Quote(				thisModuleInstance << Create Objects;				MainTabPage << Set Scriptable Object(thisApplication);			
)			),
			Allocate(
				MainTabPage = Tab Page Box();
				Splitter1 = H Splitter Box();
				TabPage1 = Tab Page Box();
				Report1 = Platform(
					DataTable1,
					Graph Builder(
						Size( 457, 457 ),
						Variables,
						Elements( Points( Legend( 1 ) ) )
					)
				);
				TabPage2 = Tab Page Box();
				Report2 = Platform(
					DataTable2,
					Graph Builder(
						Size( 427, 457 ),
						Variables(
							Color( :Name( "Opportunity Value ($)" ) ),
							Shape( :County )
						),
						Elements(
							Map Shapes( Legend( 7 ), Summary Statistic( "Sum" ) )
						),
						SendToReport(
							Dispatch(
								{},
								"Graph Builder",
								FrameBox,
								{Background Map(
									Images( "Street Map Service" ),
									Boundaries( "US Counties" )
								), Grid Line Order( 3 ), Reference Line Order( 4 )}
							)
						)
					)
				);
			),
			Organize(
				Reparent( TabPage2( Report2 ) );
				Reparent( Splitter1( TabPage2 ) );
				Reparent( TabPage1( Report1 ) );
				Reparent( Splitter1( TabPage1 ) );
				Reparent( MainTabPage( Splitter1 ) );
				Relocate( MainTabPage( 0, 0 ) );
			),
			Initialize(
				MainTabPage << Background Color( 2147483647 );
				MainTabPage << Border(
					{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
				);
				MainTabPage << Enabled( 1 );
				MainTabPage << Horizontal Alignment( "Default" );
				MainTabPage << Margin(
					{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
				);
				MainTabPage << Padding(
					{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
				);
				MainTabPage << Text Color( 2147483647 );
				MainTabPage << Vertical Alignment( "Default" );
				MainTabPage << Visibility( "Visible" );
				MainTabPage << Title( "Dashboard" );
				MainTabPage << Tip( "" );
				MainTabPage << Icon( "" );
				MainTabPage << Closeable( 0 );
				MainTabPage << Moveable( 0 );
				Splitter1 << Background Color( 2147483647 );
				Splitter1 << Border(
					{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
				);
				Splitter1 << Enabled( 1 );
				Splitter1 << Horizontal Alignment( "Default" );
				Splitter1 << Margin(
					{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
				);
				Splitter1 << Padding(
					{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
				);
				Splitter1 << Text Color( 2147483647 );
				Splitter1 << Vertical Alignment( "Default" );
				Splitter1 << Visibility( "Visible" );
				Splitter1 << Dockable( 1 );
				Splitter1 << Set Width( 1924 );
				Splitter1 << Set Height( 554 );
				Splitter1 << Set Sizes( {0.489328474752733, 0.510671525247267} );
				Splitter1 << set horizontal( 1 );
				Splitter1 << Set Min Size( 1634, 441 );
				Splitter1 << Set Max Size( 60003, 30000 );
				Splitter1 << Set Auto Stretching( 1, 1 );
				TabPage1 << Background Color( 2147483647 );
				TabPage1 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} );
				TabPage1 << Enabled( 1 );
				TabPage1 << Horizontal Alignment( "Default" );
				TabPage1 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} );
				TabPage1 << Padding(
					{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
				);
				TabPage1 << Text Color( 2147483647 );
				TabPage1 << Vertical Alignment( "Default" );
				TabPage1 << Visibility( "Visible" );
				TabPage1 << Title( "Graph Builder" );
				TabPage1 << Tip( "" );
				TabPage1 << Icon( "Trellis" );
				TabPage1 << Closeable( 1 );
				TabPage1 << Moveable( 1 );
				TabPage2 << Background Color( 2147483647 );
				TabPage2 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} );
				TabPage2 << Enabled( 1 );
				TabPage2 << Horizontal Alignment( "Default" );
				TabPage2 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} );
				TabPage2 << Padding(
					{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
				);
				TabPage2 << Text Color( 2147483647 );
				TabPage2 << Vertical Alignment( "Default" );
				TabPage2 << Visibility( "Visible" );
				TabPage2 << Title( "Graph Builder" );
				TabPage2 << Tip( "" );
				TabPage2 << Icon( "Trellis" );
				TabPage2 << Closeable( 1 );
				TabPage2 << Moveable( 1 );
			)
		)
	),
	Initialize(
		Module1 << Auto Launch( 1 );
		Module1 << Set Module Type( "Report" );
		Module1 << Set Window Title( "^TABLENAME - ^APPNAME" );
		Module1 << Set Min Size( 0, 0 );
		Module1 << Set Max Size( 30000, 30000 );
		Module1 << Set Auto Stretching( ., . );
	)
) << Run

DonMcCormack

Can you share the tables, too? Do you get the same results if you run it from the script or just the hotspot?

Peter_Bartell

MidAtlanticCurrentMap.jmp

Peter_Bartell

MidAtlanticOpportunityMap.jmp

Peter_Bartell

Don: I didn't try running from the script just yet...only the hot spot.

Daniel_Valente

I suspect this will get it for you. Go into the data table view and change the current data table.

Screen Shot 2017-02-07 at 8.24.13 AM.png

Peter_Bartell

Dan: Worked like a charm. And placing all columns into one data table worked as well. Once again proving there's almost always more than one way to accomplish a task within JMP...but the data table switcher type idea you suggest is a nice tip/trick for this sort of thing.

Daniel_Valente

Thanks folks, good discussion here. We opened up a defect to make this more straightforward in JMP 14: http://sww.sas.com/cgi-bin/quick_browse?defectid=S1321708

Peter_Bartell

Good news then. From my seat as an SE, dashboard builder is one of our 'killer' apps in version 13. Pretty much every time I show it, people get excited. Especially the people that used Application Builder to slay the same data visualization sharing dragon...far more efficient construction of simple dashboards without lots of bells and whistles that retain alot of the core data/visualization interactivity that is JMP's hallmark.