- JMP User Community
- :
- Discussions
- :
- Combined Dashboard Removing One Graph
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Level I
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Combined Dashboard Removing One Graph
Created:
Mar 31, 2023 09:10 AM
| Last Modified: Jun 9, 2023 9:06 AM
(459 views)
Hello,
I am trying to create a combined dashboard of 3 separate dashboards. Each dashboard has a local data filter applied within the dashboard builder itself, selecting one subset of data (VTF/V/001). Within one of these 3 dashboards I have included a presummarise control chart, already filtered to only include this subset of data. When I run the individual dashboards, each one works perfectly. However, when I run the combined dashboard, it removes my control chart. I believe this may be something to do with local data filters but I am at a loss as to how to solve this problem. I will attach my code below:
One of the individual dashboards containing the control chart (works on its own but not when combined):
JMP App(
Set Name( "ND50" ),
Set Description( "Four reports arranged in a grid" ),
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(
"//phe.gov.uk/porton/SharedData/Wuhan-CoV/IN VITRO testing/MNA testing/Trending MNA/JMP for trending/Control Chart Trials/Control_Charts_Dashboard.jmp"
),
Set Label( "Control_Charts_Dashboard" ),
Location( "Current Data Table" ),
Invisible( 0 )
)
),
Thumbnail(
New Image(
Char To Blob(
"52711eJyllmdQ08saxv8JAVIMEENRILSggEg5eCihHCCgARQEDghy6UWKNAlCAMEISkeRLlKlCF4RQpMmhCYivXiUogmC9BKaBGkHnTv3670zZ2bf/T27z+yHnX2fmY0xNiIg4fxwAACQ+nq6psck/ywo2/Hc/odDzzEgrtqG2gBAeYTYd2A9XsN89a4TAYCj9WeB6h7fXAEAOE5fV9uMZLuSHeJrZoHpkrugmj1EufDhseq2sFqaqseS21FirWpB7fg11vMRcJfYAgV5DmOtmy4l9jKDVhAPtHxCkI6tZ5o6VF9JdI39eOgrXVcqNwxQHjMM0AH3RUCac4g7tg0CSogC5c9ZfWvt+7NfiAP1y4eru8sac6viuGEmk7kkm37Zp2pMMs3Esuzawehoiq0jK0u0C4JPq3wZ3RM/NjbWyFp3e4l3dnZWEi/vTWsu21KYOWiE0LNpExPSBDu73MEhHwrVcaGl8dXRtNOB7R6CoPnjQIhPevQP8zMMaeD1feXqiRV81yBDnu186PxClb2/P7eOjk6gY8aH9cQdTE6ZTdnru5NGyHqNiR8hmKFwBFVzJouVlZ6wn33e4ARSjX5qWXu5e5q05qYCf/E0A4KthGILAqzfy+C9ylA6B2dnluLsb9fT+W9XNnaSz0MahV5i0t9ySEwopfA9q2wAYbHYMLurhfTAJhdRKnkB3u/Kb/96W+TsWY6uw11Zx+QkFPEsx5P1bpWKI6hClSx9dAodrYJ51Bt/XjfnB1eqeTqjdb09Wo3IK/UYppKdGYuNeijSWMHv5J1O+4iWSksAanM4Oi7qimAlWKZQDszpHIxKwLJkG/YqheMhobUeLJ4bjR/tPjWf9OwW441v4YI/lBPRnkv7FMHis0wwigVRpLqjVXZ9CufMv45/Ujhpf6giaVbx2wTOk3DLW3XYD+GgFCgqJy2wjVSUn+F79qoZo1HsnWGVICn97qLDRWRwvEXeiGteWRkycnOspLRMpzyIywuZ7qukgSj2RmQZRR19REuuSgHlM2BGJG8Qr4zHCepvCrEmf7lf+zey4JVJkILyV/9KhEPEhxsP+rwj2nFgdjXvmrExdfsUTFXPtKaPmhvGObndYbcudSUk51wH8stzdVIXcR9ONXHtW/R8IvZ7+E5pnCHJ/HiHk0Fx9PNLEoM4BQdbLSywQuqCNovvsIvgc49fc6DxC+NSPv8iab5cljt853nm9J3Vy8DrCRlOmJFSELxzfn5ey8mpIKuqJXiofYqhXs9MpjdD6HtNJiWOv1cSWisVirgzfVGjBE2f43N/CGc8eWJikE9wdZU4Jy2daupWKQlmyMXrxu+eFwdaVA77+URnC0qB/aeVJSWS8/6qolgNDZvujghN0OLiIpeAwNLOfpGQlJRUne9UeFIMuyHru4GB9DNcqR0durhbPHfBzi4urZ5K0mcoGZmZeFPTJNONvFKgs7Nzo/e6Lqlt/08/OZAfkTg0MlKQ0hGOSExLK05RTwTg4mQ5cSACIgLSA06Sj9H0S2k9gHAhTooA/5cLrQTOINujNWhx9/dBhakcYiuOwrGLbLeeHoxk2sPs6zx1rANyswqaU75dH4zauDEh5iyZB6wR7NreYlQ9J0u7EOzjDI9JlbDvaSgXnhUDxAo0DYhqf1/hbsEfVjMtaOtc7+WAe4UjsSK3zxY9CICqQBj9GZ29dSw3OW/bh4pVBNOASgW5kBeK4pbgElwD5loTMxCtJM5ytSWM58yDhBwPJCqAQx439Xax5dR6aiBZzhOjFRCQbVqAaUVTWY7MtyWOnNsKjgChw+zTPEV9BgkBUGnq1m0+IZpDR6wNeWvDXg9OFzr9FjtxxZIiYLke522WBHyZpL4o60tUoihvsWDfxwmkTI+jPEHyypFyb8bh7puChcK1eWXae8LlfKbkpJ7QT6F1YM6y8sgt4gV0HttSIC+ddAd7Y241bPpIupVb5PloPMYnfbpqSVbHaqTPr+m+YYjcVzMDRIimARbJZQrEdd7zKdeP3Orz19NU0Ao+yzf8EZ2Y9qFwoRNWDNhYeJGW6y8k5vRuzTA/W99ZjCHN8HmE8HEFQJlu+/xhlb9xDKe3M+ho4bzqrdif1+YmT/vF0xcUTRKFYO3vn7cNWdKKRt2iqETgUFz+HrJcF/taa68bJfEJ7HspW/blnov4ixdqqdhxsWpAqFpgc66KG8KoIOEiyUBc1zDKfl0EBNYCM/Fg+f+0yTGoiF/KTA+g/BPX0h8ka9sU/Up25W7+VLKYouJ2DtjZ1bUnTiYOuuaWU6CcCTe2s3v07p3emAIqovz0TIIm6H1PDwqDWfmZl6bNXZt+gT4I/XKSoqJifkMDv7m5eRvr2vzs7A2ce+oumGG9a/BMbO7T+PjiyFQmjHqV3vNuI0jLxORx4tCXL0K+UDqfh6+v8bzgHOdQJgfozhPzsKelpaUoBUdHRzCc2t3To3PpUiRtMz3YzMxMRFRU+zixxWDf9uCQkNQk0vz2jxB4YnIylrag+2BuPqEYPOhEH45sZocCMDoCRv1vrvQAuV/KWBTUEQ75325PEoq8w76WhPt+w9vIsKot6zneKVyKmi04tp1KtC7UPCWTBURhl9aHvwu+/PxndJnE+LrV/dN7z8YdBPykZaqxluDlkBZ+zQMdob9WZdpq795+hxOK94oiOlu752PaYIOTw1FN+2zON8ymvgWqUmTQzHXaj8Qn5gXVgw/tYca0QaSONrZ/8VzFqs2FWleKIG0Zr++QPIxX68hm6f1M3WRPIM2KM2o+59d7ThI+fiYFtMBocUAzZSR+46SV4jJHMlr2zs1yVO4Ep3oF7vf0BCIuav2DjcU63e7eQNOw4RJbMDEk+MQjL5+oap5E20WCrfebn23LS/+hKCF06CVR6KVOQMta1J5THBctBFZjTqtEYkj+l2UKtz+KhLagVEMVBVelJjcWXx6l28Pp/Ln3Oh3b39t91B6X7/d7qQ16uqfylom+FwCVIucXoqVzDe9vWeMK+TIgAxZTI1eLHOb+xdbb/yASaFjmVa9WjflmudD92EuY2X+9KehlxhvhosdsUFXIJN4Zr1jYdcTiXvPQa5ryfSf4Srz7Xgb3FRAzUIBwNVXbiudb9y1zQaWWtJgFAeUUtnGRZUEyUTUmVLWZBF0KSyaP6XvJnZAoAUveD7WELGz6OPX0m82+qX199+Eg2PdEJFu83VNjg/FKbgh9xrqkvXe00HSYd4rV8kpaLBAHg3Ed54TvJFkbnAiIAzCtY9j+Unl4cDTrP3A7JcTIY57XDL7e0pSOZJxxYjZoi7UR1QJXs0w3fDXBM1JdzkxtnmbTDOWampqNRTPrk0PhdtAwdkbkt4dpabxFM/nV1Wa2QgO0I8poRJyaHXCYb3uK3hIu6HJJwsfW6PhnCehfNNJ9hbcP/xsAGrlQ",
"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; Try(MainTabPage << Set Scriptable Object(thisApplication));
) ),
Allocate(
DataFilterContext1 = Data Filter Context Box();
Splitter4 = H Splitter Box();
TabPage5 = Tab Page Box();
Scroll5 = Scroll Box();
DataFilter1 = DataTable1 <<
Data Filter(
Local,
Add Filter(
columns(
:
"Critical Reagent/equipment Tracking-Viral working stock"n
),
Where(
:
"Critical Reagent/equipment Tracking-Viral working stock"n
== "VTF/V/001"
),
Display(
:
"Critical Reagent/equipment Tracking-Viral working stock"n,
N Items( 11 )
)
)
);
MainTabPage = Tab Page Box();
Splitter1 = H Splitter Box();
Splitter2 = V Splitter Box();
TabPage1 = Tab Page Box();
Scroll1 = Scroll Box();
Report1 = Platform(
DataTable1,
Graph Builder(
Size( 712, 359 ),
Show Control Panel( 0 ),
Fit to Window,
Variables(
X(
Transform Column(
"Month Year[Assay Date]",
Ordinal,
Format( "m/y", 12 ),
Formula(
Date DMY(
1,
Month( :Assay Date ),
Year( :Assay Date )
)
)
)
),
Y( :Plates passed system suitability ? )
),
Elements( Mosaic( X, Y, Legend( 9 ) ) ),
SendToReport(
Dispatch(
{},
"400",
ScaleBox,
{Legend Model(
9,
Properties(
1,
{Fill Color( 3 )},
Item ID( "Fail", 1 )
),
Properties(
-1,
{Fill Color( 69 )},
Item ID( "NA", 1 )
)
)}
),
Dispatch(
{},
"400",
LegendBox,
{Set Title( "System Suitability (P/F)" )}
)
)
)
);
TabPage2 = Tab Page Box();
Scroll2 = Scroll Box();
Report2 = Platform(
DataTable1,
Graph Builder(
Size( 684, 342 ),
Show Control Panel( 0 ),
Fit to Window,
Variables(
X( :Vero Cell lot # ),
X( :FBS lot# ),
Y( :Log10 Reference ND50 ),
Color(
:
"Critical Reagent/equipment Tracking-Viral working stock"n
)
),
Elements( Position( 1, 1 ), Box Plot( X, Y, Legend( 13 ) ) ),
Elements( Position( 2, 1 ), Box Plot( X, Y, Legend( 14 ) ) ),
SendToReport(
Dispatch(
{},
"Log10 Reference ND50",
ScaleBox,
{Add Ref Line(
2.84757265914, "Solid", "Green", "LCL", 2
), Add Ref Line(
3.30984300472, "Solid", "Orange", "Target", 2
), Add Ref Line(
3.77202816532, "Solid", "Red", "UCL", 2
)}
),
Dispatch(
{},
"400",
ScaleBox,
{Legend Model(
14,
Properties(
1,
{Fill Color( 3 )},
Item ID( "VTF/V/001", 1 )
)
)}
)
)
)
);
Splitter3 = V Splitter Box();
TabPage3 = Tab Page Box();
Scroll3 = Scroll Box();
Report3 = Platform(
DataTable1,
Control Chart(
Sample Label( :Assay Date ),
KSigma( 3 ),
Chart Col(
:Log10 Reference ND50,
Individual on Group Means(
Show Zones( 1 ),
Shade Zones( 1 ),
Test 1( 1 ),
Test 2( 1 ),
Test 3( 1 ),
Test 4( 1 ),
Test 5( 1 ),
Test 6( 1 ),
Test 7( 1 ),
Test 8( 1 )
),
Moving Range on Group Means
),
Where(
:
"Critical Reagent/equipment Tracking-Viral working stock"n
== "VTF/V/001"
),
SendToReport(
Dispatch(
{"Individual on Group Means of Log10 Reference ND50"
},
"Presummarize Control Chart of IM",
FrameBox,
{Frame Size( 945, 303 )}
),
Dispatch(
{"Individual on Group Means of Log10 Reference ND50"
},
"Control Chart Limits frame",
FrameBox,
{Frame Size( 64, 303 )}
),
Dispatch(
{},
"Moving Range on Group Means of Log10 Reference ND50",
OutlineBox,
{Close( 1 )}
),
Dispatch(
{
"Moving Range on Group Means of Log10 Reference ND50"
},
"Presummarize Control Chart of MRM",
FrameBox,
{Frame Size( 945, 303 )}
),
Dispatch(
{
"Moving Range on Group Means of Log10 Reference ND50"
},
"Control Chart Limits frame",
FrameBox,
{Frame Size( 64, 303 )}
)
)
)
);
TabPage4 = Tab Page Box();
Scroll4 = Scroll Box();
Report4 = Platform(
DataTable1,
Graph Builder(
Size( 717, 397 ),
Show Control Panel( 0 ),
Fit to Window,
Variables(
X( :Assay Date ),
Y( :Log10 Reference ND50 ),
Color(
:
"Critical Reagent/equipment Tracking-Viral working stock"n
)
),
Elements( Points( X, Y, Legend( 3 ) ) ),
SendToReport(
Dispatch(
{},
"Log10 Reference ND50",
ScaleBox,
{Add Ref Line(
3.77202816532, "Solid", "Red", "UCL", 2
), Add Ref Line(
3.30984300472, "Solid", "Orange", "Target", 2
), Add Ref Line(
2.84757265914, "Solid", "Green", "LCL", 2
)}
),
Dispatch(
{},
"400",
LegendBox,
{Set Title( "Viral Stock" )}
)
)
)
);
),
Organize(
Reparent( Scroll4( Report4 ) );
Reparent( TabPage4( Scroll4 ) );
Reparent( Splitter3( TabPage4 ) );
Reparent( Scroll3( Report3 ) );
Reparent( TabPage3( Scroll3 ) );
Reparent( Splitter3( TabPage3 ) );
Reparent( Splitter1( Splitter3 ) );
Reparent( Scroll2( Report2 ) );
Reparent( TabPage2( Scroll2 ) );
Reparent( Splitter2( TabPage2 ) );
Reparent( Scroll1( Report1 ) );
Reparent( TabPage1( Scroll1 ) );
Reparent( Splitter2( TabPage1 ) );
Reparent( Splitter1( Splitter2 ) );
Reparent( MainTabPage( Splitter1 ) );
Reparent( Splitter4( MainTabPage ) );
Reparent( Scroll5( DataFilter1 ) );
Reparent( TabPage5( Scroll5 ) );
Reparent( Splitter4( TabPage5 ) );
Reparent( DataFilterContext1( Splitter4 ) );
Relocate( DataFilterContext1( 0, 0 ) );
),
Initialize(
DataFilterContext1 << Background Color( 2147483647 ),
DataFilterContext1 << Border(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), DataFilterContext1 << Enabled( 1 ),
DataFilterContext1 << Horizontal Alignment( "Default" ),
DataFilterContext1 << Margin(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
),
DataFilterContext1 << Padding(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), DataFilterContext1 << Text Color( 2147483647 ),
DataFilterContext1 << UI Only( 0 ),
DataFilterContext1 << Vertical Alignment( "Default" ),
DataFilterContext1 << Visibility( "Visible" ),
DataFilterContext1 << Set Min Size( 551, 311 ),
DataFilterContext1 << Set Max Size( 60003, 30000 ),
DataFilterContext1 << Set Stretch( {"Neutral", "Neutral"} ),
Splitter4 << Background Color( 2147483647 ),
Splitter4 << Border(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), Splitter4 << Enabled( 1 ),
Splitter4 << Horizontal Alignment( "Default" ),
Splitter4 << Margin(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
),
Splitter4 << Padding(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), Splitter4 << Text Color( 2147483647 ), Splitter4 << UI Only( 0 ),
Splitter4 << Vertical Alignment( "Default" ),
Splitter4 << Visibility( "Visible" ), Splitter4 << Dockable( 1 ),
Splitter4 << Set Width( 1908 ), Splitter4 << Set Height( 910 ),
Splitter4 << Set Sizes( {0.1, 0.9} ),
Splitter4 << Set Min Size( 551, 311 ),
Splitter4 << Set Max Size( 60003, 30000 ),
Splitter4 << Set Stretch( {"Window", "Window"} ),
Splitter4 << set horizontal( 1 ),
TabPage5 << Background Color( 2147483647 ),
TabPage5 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
TabPage5 << Enabled( 1 ),
TabPage5 << Horizontal Alignment( "Default" ),
TabPage5 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
TabPage5 << Padding(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), TabPage5 << Text Color( 2147483647 ), TabPage5 << UI Only( 0 ),
TabPage5 << Vertical Alignment( "Default" ),
TabPage5 << Visibility( "Visible" ),
TabPage5 << Set Min Size( 72, 62 ),
TabPage5 << Set Max Size( 30000, 30000 ),
TabPage5 << Set Stretch( {"Neutral", "Neutral"} ),
TabPage5 << Title( "Local Data Filter" ), TabPage5 << Tip( "" ),
TabPage5 << Icon( "Filter" ), TabPage5 << Closeable( 1 ),
TabPage5 << Moveable( 1 ), TabPage5 << Set Base Font( "Text" ),
TabPage5 << Set Font Scale( 1 ),
Scroll5 << Background Color( 2147483647 ),
Scroll5 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll5 << Enabled( 1 ),
Scroll5 << Horizontal Alignment( "Default" ),
Scroll5 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll5 << Padding( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll5 << Text Color( 2147483647 ), Scroll5 << UI Only( 0 ),
Scroll5 << User Resizable( {1, 1} ),
Scroll5 << Vertical Alignment( "Default" ),
Scroll5 << Visibility( "Visible" ),
Scroll5 << Set Min Size( 72, 36 ),
Scroll5 << Set Max Size( 30000, 30000 ),
Scroll5 << Set Stretch( {"Window", "Window"} ),
Scroll5 << Width( 191 ), Scroll5 << Height( 884 ),
Scroll5 << Set Auto Scrollable( 1 ),
Scroll5 << Set Scrollers( 1, 1 ), Scroll5 << Set Show Empty( 0 ),
Scroll5 << Set Clip Printing( 0 ),
DataFilter1 << Background Color( 2147483647 ),
DataFilter1 << Border(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), DataFilter1 << Enabled( 1 ),
DataFilter1 << Horizontal Alignment( "Default" ),
DataFilter1 << Margin(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
),
DataFilter1 << Padding(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), DataFilter1 << Text Color( 2147483647 ),
DataFilter1 << UI Only( 0 ),
DataFilter1 << Vertical Alignment( "Default" ),
DataFilter1 << Visibility( "Visible" ),
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 << UI Only( 0 ),
MainTabPage << Vertical Alignment( "Default" ),
MainTabPage << Visibility( "Visible" ),
MainTabPage << Set Min Size( 476, 311 ),
MainTabPage << Set Max Size( 30000, 30000 ),
MainTabPage << Set Stretch( {"Neutral", "Neutral"} ),
MainTabPage << Title( "Dashboard" ), MainTabPage << Tip( "" ),
MainTabPage << Icon( "" ), MainTabPage << Closeable( 0 ),
MainTabPage << Moveable( 0 ), MainTabPage << Set Base Font( "Text" ),
MainTabPage << Set Font Scale( 1 ),
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 << UI Only( 0 ),
Splitter1 << Vertical Alignment( "Default" ),
Splitter1 << Visibility( "Visible" ), Splitter1 << Dockable( 1 ),
Splitter1 << Set Width( 1714 ), Splitter1 << Set Height( 884 ),
Splitter1 << Set Sizes( {0.5, 0.5} ),
Splitter1 << Set Min Size( 476, 285 ),
Splitter1 << Set Max Size( 60003, 60003 ),
Splitter1 << Set Stretch( {"Window", "Window"} ),
Splitter1 << set horizontal( 1 ),
Splitter2 << Background Color( 2147483647 ),
Splitter2 << Border(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), Splitter2 << Enabled( 1 ),
Splitter2 << Horizontal Alignment( "Default" ),
Splitter2 << Margin(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
),
Splitter2 << Padding(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), Splitter2 << Text Color( 2147483647 ), Splitter2 << UI Only( 0 ),
Splitter2 << Vertical Alignment( "Default" ),
Splitter2 << Visibility( "Visible" ), Splitter2 << Dockable( 1 ),
Splitter2 << Set Width( 856 ), Splitter2 << Set Height( 884 ),
Splitter2 << Set Sizes( {0.5, 0.5} ),
Splitter2 << Set Min Size( 272, 285 ),
Splitter2 << Set Max Size( 30000, 60003 ),
Splitter2 << Set Stretch( {"Window", "Window"} ),
Splitter2 << set horizontal( 0 ),
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 << UI Only( 0 ),
TabPage1 << Vertical Alignment( "Default" ),
TabPage1 << Visibility( "Visible" ),
TabPage1 << Set Min Size( 244, 153 ),
TabPage1 << Set Max Size( 30000, 30000 ),
TabPage1 << Set Stretch( {"Neutral", "Neutral"} ),
TabPage1 << Title( "Graph Builder" ), TabPage1 << Tip( "" ),
TabPage1 << Icon( "Trellis" ), TabPage1 << Closeable( 1 ),
TabPage1 << Moveable( 1 ), TabPage1 << Set Base Font( "Text" ),
TabPage1 << Set Font Scale( 1 ),
Scroll1 << Background Color( 2147483647 ),
Scroll1 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll1 << Enabled( 1 ),
Scroll1 << Horizontal Alignment( "Default" ),
Scroll1 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll1 << Padding( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll1 << Text Color( 2147483647 ), Scroll1 << UI Only( 0 ),
Scroll1 << User Resizable( {1, 1} ),
Scroll1 << Vertical Alignment( "Default" ),
Scroll1 << Visibility( "Visible" ),
Scroll1 << Set Min Size( 244, 127 ),
Scroll1 << Set Max Size( 30144, 30017 ),
Scroll1 << Set Stretch( {"Window", "Window"} ),
Scroll1 << Width( 856 ), Scroll1 << Height( 415 ),
Scroll1 << Set Auto Scrollable( 1 ),
Scroll1 << Set Scrollers( 0, 0 ), Scroll1 << Set Show Empty( 0 ),
Scroll1 << Set Clip Printing( 0 ),
Report1 << Background Color( 2147483647 ),
Report1 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report1 << Enabled( 1 ),
Report1 << Horizontal Alignment( "Default" ),
Report1 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report1 << Padding( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report1 << Text Color( 2147483647 ), Report1 << UI Only( 0 ),
Report1 << Vertical Alignment( "Default" ),
Report1 << Visibility( "Visible" ),
Report1 << Set Min Size( 244, 127 ),
Report1 << Set Max Size( 30144, 30017 ),
Report1 << Set Stretch( {"Neutral", "Neutral"} ),
Report1 << set horizontal( 0 ),
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 << UI Only( 0 ),
TabPage2 << Vertical Alignment( "Default" ),
TabPage2 << Visibility( "Visible" ),
TabPage2 << Set Min Size( 272, 129 ),
TabPage2 << Set Max Size( 30000, 30000 ),
TabPage2 << Set Stretch( {"Neutral", "Neutral"} ),
TabPage2 << Title( "Graph Builder" ), TabPage2 << Tip( "" ),
TabPage2 << Icon( "Trellis" ), TabPage2 << Closeable( 1 ),
TabPage2 << Moveable( 1 ), TabPage2 << Set Base Font( "Text" ),
TabPage2 << Set Font Scale( 1 ),
Scroll2 << Background Color( 2147483647 ),
Scroll2 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll2 << Enabled( 1 ),
Scroll2 << Horizontal Alignment( "Default" ),
Scroll2 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll2 << Padding( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll2 << Text Color( 2147483647 ), Scroll2 << UI Only( 0 ),
Scroll2 << User Resizable( {1, 1} ),
Scroll2 << Vertical Alignment( "Default" ),
Scroll2 << Visibility( "Visible" ),
Scroll2 << Set Min Size( 272, 103 ),
Scroll2 << Set Max Size( 30172, 30017 ),
Scroll2 << Set Stretch( {"Window", "Window"} ),
Scroll2 << Width( 856 ), Scroll2 << Height( 414 ),
Scroll2 << Set Auto Scrollable( 1 ),
Scroll2 << Set Scrollers( 0, 0 ), Scroll2 << Set Show Empty( 0 ),
Scroll2 << Set Clip Printing( 0 ),
Report2 << Background Color( 2147483647 ),
Report2 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report2 << Enabled( 1 ),
Report2 << Horizontal Alignment( "Default" ),
Report2 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report2 << Padding( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report2 << Text Color( 2147483647 ), Report2 << UI Only( 0 ),
Report2 << Vertical Alignment( "Default" ),
Report2 << Visibility( "Visible" ),
Report2 << Set Min Size( 272, 103 ),
Report2 << Set Max Size( 30172, 30017 ),
Report2 << Set Stretch( {"Neutral", "Neutral"} ),
Report2 << set horizontal( 0 ),
Splitter3 << Background Color( 2147483647 ),
Splitter3 << Border(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), Splitter3 << Enabled( 1 ),
Splitter3 << Horizontal Alignment( "Default" ),
Splitter3 << Margin(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
),
Splitter3 << Padding(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), Splitter3 << Text Color( 2147483647 ), Splitter3 << UI Only( 0 ),
Splitter3 << Vertical Alignment( "Default" ),
Splitter3 << Visibility( "Visible" ), Splitter3 << Dockable( 1 ),
Splitter3 << Set Width( 855 ), Splitter3 << Set Height( 884 ),
Splitter3 << Set Sizes( {0.5, 0.5} ),
Splitter3 << Set Min Size( 201, 183 ),
Splitter3 << Set Max Size( 30000, 60003 ),
Splitter3 << Set Stretch( {"Window", "Window"} ),
Splitter3 << set horizontal( 0 ),
TabPage3 << Background Color( 2147483647 ),
TabPage3 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
TabPage3 << Enabled( 1 ),
TabPage3 << Horizontal Alignment( "Default" ),
TabPage3 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
TabPage3 << Padding(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), TabPage3 << Text Color( 2147483647 ), TabPage3 << UI Only( 0 ),
TabPage3 << Vertical Alignment( "Default" ),
TabPage3 << Visibility( "Visible" ),
TabPage3 << Set Min Size( 72, 62 ),
TabPage3 << Set Max Size( 30000, 30000 ),
TabPage3 << Set Stretch( {"Neutral", "Neutral"} ),
TabPage3 << Title( "TabPage3" ), TabPage3 << Tip( "" ),
TabPage3 << Icon( "ControlC" ), TabPage3 << Closeable( 1 ),
TabPage3 << Moveable( 1 ), TabPage3 << Set Base Font( "Text" ),
TabPage3 << Set Font Scale( 1 ),
Scroll3 << Background Color( 2147483647 ),
Scroll3 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll3 << Enabled( 1 ),
Scroll3 << Horizontal Alignment( "Default" ),
Scroll3 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll3 << Padding( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll3 << Text Color( 2147483647 ), Scroll3 << UI Only( 0 ),
Scroll3 << User Resizable( {1, 1} ),
Scroll3 << Vertical Alignment( "Default" ),
Scroll3 << Visibility( "Visible" ),
Scroll3 << Set Min Size( 72, 36 ),
Scroll3 << Set Max Size( 30000, 30000 ),
Scroll3 << Set Stretch( {"Window", "Window"} ),
Scroll3 << Width( 855 ), Scroll3 << Height( 415 ),
Scroll3 << Set Auto Scrollable( 1 ),
Scroll3 << Set Scrollers( 1, 1 ), Scroll3 << Set Show Empty( 0 ),
Scroll3 << Set Clip Printing( 0 ),
Report3 << Background Color( 2147483647 ),
Report3 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report3 << Enabled( 1 ),
Report3 << Horizontal Alignment( "Default" ),
Report3 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report3 << Padding( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report3 << Text Color( 2147483647 ), Report3 << UI Only( 0 ),
Report3 << Vertical Alignment( "Default" ),
Report3 << Visibility( "Visible" ),
Report3 << Set Min Size( 1113, 546 ),
Report3 << Set Max Size( 1113, 546 ),
Report3 << Set Stretch( {"Neutral", "Neutral"} ),
Report3 << set horizontal( 0 ),
TabPage4 << Background Color( 2147483647 ),
TabPage4 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
TabPage4 << Enabled( 1 ),
TabPage4 << Horizontal Alignment( "Default" ),
TabPage4 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
TabPage4 << Padding(
{Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )}
), TabPage4 << Text Color( 2147483647 ), TabPage4 << UI Only( 0 ),
TabPage4 << Vertical Alignment( "Default" ),
TabPage4 << Visibility( "Visible" ),
TabPage4 << Set Min Size( 201, 118 ),
TabPage4 << Set Max Size( 30000, 30000 ),
TabPage4 << Set Stretch( {"Neutral", "Neutral"} ),
TabPage4 << Title( "Graph Builder" ), TabPage4 << Tip( "" ),
TabPage4 << Icon( "Trellis" ), TabPage4 << Closeable( 1 ),
TabPage4 << Moveable( 1 ), TabPage4 << Set Base Font( "Text" ),
TabPage4 << Set Font Scale( 1 ),
Scroll4 << Background Color( 2147483647 ),
Scroll4 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll4 << Enabled( 1 ),
Scroll4 << Horizontal Alignment( "Default" ),
Scroll4 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll4 << Padding( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Scroll4 << Text Color( 2147483647 ), Scroll4 << UI Only( 0 ),
Scroll4 << User Resizable( {1, 1} ),
Scroll4 << Vertical Alignment( "Default" ),
Scroll4 << Visibility( "Visible" ),
Scroll4 << Set Min Size( 201, 92 ),
Scroll4 << Set Max Size( 30101, 30017 ),
Scroll4 << Set Stretch( {"Window", "Window"} ),
Scroll4 << Width( 855 ), Scroll4 << Height( 414 ),
Scroll4 << Set Auto Scrollable( 1 ),
Scroll4 << Set Scrollers( 0, 0 ), Scroll4 << Set Show Empty( 0 ),
Scroll4 << Set Clip Printing( 0 ),
Report4 << Background Color( 2147483647 ),
Report4 << Border( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report4 << Enabled( 1 ),
Report4 << Horizontal Alignment( "Default" ),
Report4 << Margin( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report4 << Padding( {Left( 0 ), Top( 0 ), Right( 0 ), Bottom( 0 )} ),
Report4 << Text Color( 2147483647 ), Report4 << UI Only( 0 ),
Report4 << Vertical Alignment( "Default" ),
Report4 << Visibility( "Visible" ),
Report4 << Set Min Size( 201, 92 ),
Report4 << Set Max Size( 30101, 30017 ),
Report4 << Set Stretch( {"Neutral", "Neutral"} ),
Report4 << set horizontal( 0 )
)
)
),
Initialize(
Module1 << Auto Launch( 1 );
Module1 << Set Module Type( "Report" );
Module1 << Set Window Title( "^TABLENAME - ^APPNAME" );
)
) << Run;The code used at the end of my 3 dashboard script which puts them into one combined dashboard:
dashes = Find All(Reports);
tb = Expr(Tab Box());
For(i = 1, i<= N Items(dashes), i ++,
tabPage = Expr(Tab Page Box());
dfcb = Expr(Data Filter Context Box());
lub = Expr(Line Up Box(N Col(2)));
hlb = Expr(H List Box());
//Get Data table name to use with the data filter
wintitle = dashes[i] << Get Window Title;
wordone = Word(1, wintitle, "-");
wordtwo = Word(2, wintitle, "-");
dtname = Substr(wordone, 1, Length(wordone)-1 );
dt = Eval Expr(Data Table(Expr(dtName)));
//Get dashboard name
dashName = Substr(wordtwo, 2);
failed = 0;
j = 1;
//Loop through the tab page boxes in the dashboard, and extract the scripts
While(failed ==0,
Try(tpb = dashes[i] << Find(TabPageBox(j)),
failed = 1; Continue();
);
//Try to get the script from the display box if it exisits
Try(obj = tpb << Get Scriptable Object;
script = obj << Get Script,
j ++; Continue();
);
//If the script is for the local data filter add the script to the H List Box
If(Char(Head(Name Expr(script))) == "Data Filter",
FilterExprStr = char(NameExpr(dt)) || " << " || char(Name Expr(script));
FilterExpr = Parse(FilterExprStr);
Insert Into(hlb,NameExpr(FilterExpr));
,
//Else add it to the lineup box
If( Char(Name Expr(script)) != "Scriptable[]",
reportExprStr = char(NameExpr(dt)) || " << " || char(Name Expr(script));
reportExpr = Parse(reportExprStr);
scrollbox = Expr(Scroll Box());
Insert Into(scrollbox, Name Expr(reportExpr));
Insert Into(lub,Name Expr(scrollbox));
);
);
j ++;
);
//Build up the display boxes
Insert Into(hlb, Name Expr(lub));
Insert Into(dfcb, Name Expr(hlb));
Insert Into(tabPage, Eval Expr(Title(Expr(dashName))), 1);
Insert Into(tabPage, Name Expr(dfcb), 2);
Insert Into(tb, Name Expr(tabPage));
);
//Create combined dashboard window
New Window("Combined Dashboard", tb);
//Close all the individual dash reports
For( w = 1, w <= N Items(dashes), w ++,
dashes[w] << Close Window;
);Thank you for the help
1 REPLY 1
Staff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Combined Dashboard Removing One Graph
Hello,
It seems that regacy control chart does not support local data filter. I think that is why control chart is missing in your combined report.
I suggest you replace it with three-way control chart. See the following page for three-way control chart.
https://community.jmp.com/t5/Learning-Center/Creating-3-Way-Control-Charts/ta-p/271885
- © 2024 JMP Statistical Discovery LLC. All Rights Reserved.
- Terms of Use
- Privacy Statement
- About JMP
- JMP Software
- JMP User Community
- Contact