Workflow Builder Hands-on Activity and Solution
This hands-on activity allows you to practice using Workflow Builder to import data from Excel, reshape the data table in JMP, then build a graph using Graph Builder. The instructions are below and...
This hands-on activity allows you to practice using Workflow Builder to import data from Excel, reshape the data table in JMP, then build a graph using Graph Builder. The instructions are below and...
Before launching the course, please download and extract the zip file above (intro-to-jsl-journal.zip) for use with the course activities. This course covers a range of scripting...
Unlock the Power of Python Integration in JMP® 18 Welcome to the world of JMP 18, where one of the standout features is the enhanced Python integration capabilities. This article is designed to help you understand the value of this powerful tool, along with offering best practices for maximizing its benefits in your data analysis workflows. What Does Python Integration Mean in JMP? (view in My Vi...
Here are some Tips and Tricks for using JMP more effectively! Drilling Down into Data Create Graphlets and use graphs to filter on additional graphs! (view in My Videos) Capturing Data Selections Capture data selections that have been made interactively to filter and create new variables for analysis. Name Selection in Column and creating a formula that uses row states interactively are shown. (...
This hands-on activity allows you to practice using Workflow Builder to import data from Excel, reshape the data table in JMP, then build a graph using Graph Builder.
The instructions are below and in the attached PDF, which also contains the solutions. The Excel file is also attached to this post.
1. Create a new workflow and start recording.
2. Import the data from the file Practice.xls into JMP....
These hands-on activities are for JMP scripters to practice scripting New Window( ) to communicate with the user and use the information provided by the user to develop appropriate reports. The instructions are provided below and in the attached PDF file, which also contains the solutions. The attached zip file contains the solution scripts and a data table used in one of the activities. Suppose y...
To save a report as a Microsoft PowerPoint presentation: Select File > Save As.In the Save as type menu, select PowerPoint Presentation (*.pptx). Example of a PowerPoint Slide Example of a PowerPoint Slide Tip of the Day - Save a Report as a Microsoft PowerPoint Presentation
Here are some helpful tips when working with the legend in Graph Builder: Double-click anywhere in the legend to hide or rearrange items. Press Control and click an item in the legend to change its properties. Click an item in the legend to select the corresponding rows in the data table. Legend Settings Window
From a data table or report window, select Tools > Help and then click anywhere to launch the JMP Help for that area. This example shows the JMP Help for the Frequencies report in the Distribution platform. Help Tool on Frequencies Report Help for the Frequencies Report
Create a new column that contains a value for selected and deselected rows. In this example, the height column contains the measured heights (in inches) of students in a study. Heights over 60 inches are considered tall, and heights below 60 inches are considered short. You can select the tall data in a report and then create a new column that assigns a value of Tall to the selected students and...
The enhanced log shows summary information in an interactive table and scripting details in a text pane. To open the log, select View > Log (Windows) or Window > Log (macOS). Tip: If you do not see the enhanced log, check the mode setting under Preferences > Log. Enhanced Log This log shows that the following actions were performed: The Nicardipine Lab Patterns.jmp data table was openedA column na...
To change the format of values and their confidence intervals in Prediction Profilers, change the format of the response column in the associated data table. In a data table, right-click the response column and select Column Info.Change the format and click OK.Run the Prediction Profiler report. In the examples below, the initial format is updated from Best, Width 10 to Fixed Dec, Width 10 Dec 2 (...
When you publish a report to JMP Live or export it to interactive HTML, most features are interactive. If your report contains features that are not supported and will be static, you get a notification during the publishing process. Notification of Partially Implemented HTML Features To find out which features are not supported, open the JMP Log. Select View > Log. JMP Log
Code folding markers show the beginning and the end of the code block, so you can collapse and expand code. To turn on code folding: Select File > Preferences > Script Editor.Select Code folding.Click OK. Note: By default, code does not remain collapsed after you save the script and restart JMP. To save the state of the folded code, select Save and restore document state information in the Script ...
Code folding markers show the beginning and the end of the code block, so you can collapse and expand code. To turn on code folding: Select JMP > Preferences > Script Editor.Select Code folding.Click OK. Note: By default, code does not remain collapsed after you save the script and restart JMP. To save the state of the folded code, select Save and restore document state information in the Script E...
For ease of comprehension, use Squarify to arrange the rectangles in order of size in your treemap. The largest rectangle appears in the top left corner and the smallest rectangle appears in the lower right corner. Turn on Squarify: From Graph Builder: In the Treemap properties panel, change the Layout to Squarify.From Treemap: In the launch window, select Squarify from the Layout list. Example of...
To overlay an element on an existing element in Graph Builder, press Shift then click the element icon that you want to overlay. For example, if you already have points showing in your graph, and you want to overlay a contour, press Shift and click the Contour element. Overlay Graph Builder Elements
Here are some helpful tips when working with the legend in Graph Builder: Double-click anywhere in the legend to hide or rearrange items. Right-click an item in the legend to change its properties. Click an item in the legend to select the corresponding rows in the data table. Legend Settings Window
A dashboard is a visual tool that lets you run and present reports on a regular basis. To create a dashboard: Open the windows that you want to combine. Select File > New > Dashboard (Windows) or File > New > New Dashboard (Macintosh).Select the Blank Dashboard template.From the Reports pane, double-click each open window to place it on the dashboard.From the Dashboard Builder red triangle menu, s...
To access JMP tools, press the following keys: Arrow tool = aHelp tool = ?Selection tool = sScroller tool = rGrabber (Hand) tool = hBrush tool = bLasso tool = lMagnifier (Zoom) tool = zCrosshairs tool = cRuler tool = d(Text) Annotate tool = tLine, Polygon, and Simple Shape tool = no shortcuts Note: The letter can be lowercase or capitalized.
If your data table contains row states and you do not want to affect them, use the Local Data Filter. The actions of this data filter are temporary and you can experiment with it. Choose how to add a Local Data Filter to a report: In the Report toolbar, click Local Data Filter Local Data Filter Icon.If you don't see the Report toolbar, select View > Toolbars > Report. From the report's red trian...
If your data table contains row states and you do not want to affect them, use the Local Data Filter. The actions of this data filter are temporary and you can experiment with it. Add a Local Data Filter to a report: Click the right arrow at the top of the report window and select Local Data Filter.Local Data Filter Option If the report window is wide enough, click the Local Data Filter icon that ...
Display the embedded log to quickly see the results of your changes as you run and develop a script. To open the embedded log, right-click in the Script Editor and select Show Embedded Log. Or, to open the embedded log every time you open the Script Editor, select File > Preferences > Script Editor > Show embedded log on script window open. Embedded Log
Display the embedded log to quickly see the results of your changes as you run and develop a script. To open the embedded log, right-click in the Script Editor and select Show Embedded Log. Or, to open the embedded log every time you open the Script Editor, select JMP > Preferences > Script Editor > Show embedded log on script window open. Embedded Log
Switch columns in a report using the Column Switcher: There are two ways to open the Column Switcher:In the Report toolbar, click Column Switcher Column Switcher Icon.If you don't see the Report toolbar, select View > Toolbars > Report. From the red triangle menu, select Redo > Column Switcher. Choose the column that you want to switch from. Choose the columns that you want to switch to.Click OK....
Switch columns in a report using the Column Switcher: From the red triangle menu, select Redo > Column Switcher.Choose the column that you want to switch from. Choose the columns that you want to switch to.Click OK. If you have multiple columns, use the buttons to animate the column switching or step through each column manually. Column Switcher
Apply attributes and properties (such as formulas) to several columns at once: Select the column with the attributes that you want to copy.Select Cols > Standardize Attributes.Click the Attributes button and select the attribute name that you want to copy to the destination columns.Click the button next to Format and select the format that you want to use and any additional options.In the data t...