1.
|
2.
|
Select Tables > JMP Query Builder.
|
3.
|
Click Build Query.
|
4.
|
In the Available Columns list, double-click t1.Movie Name, t1.Rotten Tomatoes Score, t1.Audience Score, and t1.Theaters Opening Wknd to add them to the Included Columns tab.
|
5.
|
Click Run Query.
|
The queried data appears in a new data table. Note the Source table script. When you open the dashboard, JMP runs this Source script to query the data in Hollywood Movies.jmp.
6.
|
In the new data table, run the Graph Builder: Scores by Opening Weekend table script to create a report.
|
1.
|
From the report window, select File > New > Dashboard.
|
2.
|
Select the Blank Dashboard template.
|
3.
|
Double-click the Data Filter(Local) box in the left pane to add it to the dashboard.
|
4.
|
Figure 10.15 Dashboard for Hollywood Movies
1.
|
From the Dashboard Builder red triangle menu, select Save Script > To Add-In.
|
3.
|
Click the Menu Items tab and type Hollywood Movies Dashboard next to Menu item name (the name of the add-in menu item).
|
4.
|
Click Save and save the add-in to your desktop.
|
5.
|
Click Close on the Add-In Builder window.
|
6.
|
The Hollywood Movies.jmp data table is queried, and the dashboard opens to show the local data filter and updated report.
Figure 10.16 Hollywood Movies Add-In