JSL Cookbook

Latest Posts

• Automate the Creation of a Simple Dashboard Using the Workflow Builder

  (view in My Videos)   The Workflow Builder is JMP’s built-in macro recorder that lets users log and compile interactive operations into reuseable and generalizable programs. In this recipe we create a simple Dashboard using the Workflow Builder that can be used on any dataset that contains the same columns as the original dataset. In a follow along recipe, we will see how to generalize this to an...

  DonMcCormack

  JSL Cookbook |

  Apr 29, 2025 7:00 AM

  21 views | 0 replies

• Adding Unrecorded Steps to a Workflow

  (view in My Videos) The Workflow Builder (WFB) was added in JMP 16. At the time many, but not all, interactive steps could be captured by the recording process. With every new JMP version addition steps are added. As of JMP 18, there are still process that are not recorded. What do you do when this happens? This recipe builds a Workflow to include both recorded and unrecorded steps. While these un...

  DonMcCormack

  JSL Cookbook |

  Feb 18, 2025 12:07 PM

  158 views | 0 replies

• Accessing Information using REST/API – Getting Started

  (view in My Videos)   This recipe will focus on JSL’s ability to access information through a REST API.  We’ll be using Apple’s publicly available iTunes API. We’ll build a small dialog box for user input using associative arrays to implement cascading combo boxes. Ingredients: REST/APIDialog BoxesAssociative Arrays Difficulty – Hard Video Length – 6:08 Steps: Accessing information via a REST...

  DonMcCormack

  JSL Cookbook |

  Jan 27, 2025 1:29 PM

  3412 views | 0 replies

• The JSL Debugger – Basics

  (view in My Videos) The JSL Debugger allows users to step though program code and observe values of variables. It is particularly useful when looping through a large number of values and if multiple functions are used. This first recipe looks at some basic debugger functionality. To do this, we will use a pre-baked program, Build CVC List. The program parses each cell in a table to build vocabula...

  DonMcCormack

  JSL Cookbook |

  Sep 20, 2024 10:51 PM

  3836 views | 3 replies

• Using the Script Window, Next Steps

  (view in My Videos) This recipe will demonstrate some of the lesser known but handy Script Editor features. Whether you’re new to JSL or have been scripting for a while, you may not be familiar with some of these features. We will use a modified version of the Extract Values from Report script found in the sample script directory that comes with JMP. Ingredients: Script Editor Window Sample Scri...

  DonMcCormack

  JSL Cookbook |

  Jan 24, 2024 5:41 AM

  2159 views | 1 replies

• Dynamically Change Graph Builder Chart Type Depending on Variable Modeling Type

  This recipe shows how to change the element type in Graph Builder dynamically, depending on whether the user selects a continuous or categorical x-axis variable in the Column Switcher. Elements are the graph types that appears as icons at the top of the Graph Builder palette. For continuous inputs, a radio button is added letting the user select between a Line of Fit and Contour. This recipe is...

  matth1

  JSL Cookbook |

  Dec 8, 2023 12:56 PM

  1283 views | 0 replies

• Generalizing an App Builder Parameterized Application

  (view in My Videos) Parameterized applications work well when the number and types of columns don't change. Using App Builder with many of JMP's platforms requires there to be a one-to-one correspondence between number and types of columns used to initially build the report and the columns used for future analysis. In many cases, this is too restrictive.   To circumvent this problem, it is possib...

  DonMcCormack

  JSL Cookbook |

  Dec 4, 2023 8:59 AM

  1118 views | 0 replies

• Create a Parameterized Application with Application Builder

  (view in My Videos)   Creating an application that uses visual elements such as dialog boxes and report windows is made simpler and quicker with Application Builder. Many object properties can be set interactively rather than through code. Additionally, the resulting application is more robust, easier to maintain and more compact.   In this recipe we will build a simple parameterized application ...

  DonMcCormack

  JSL Cookbook |

  Aug 31, 2023 11:25 AM

  1212 views | 0 replies

• Build a Tailored Report using Messages

  (view in My Videos)   JMP Report windows combine two separate but related objects: the underlying analysis platform and the window in which the results are displayed. In this first recipe we will look at the simplest case, where there is no grouping condition. While much of this can be easily implemented directly through hard coding, it is helpful to understand how it can be done using JSL object...

  DonMcCormack

  JSL Cookbook |

  Jul 28, 2023 3:38 PM

  1485 views | 1 replies

• Accessing the Original Analysis Script from the Report Window that Creates It

  (view in My Videos)   A lot of the work that we do with JSL is modifying or extracting pieces from generated JMP Reports.  Sometimes, however we need to go backwards from a Report and work with the underlying analysis itself.  This actually involves moving between the different "layers" of a JMP Report - the Report Layer, and the Analysis Layer.  This is easily done when you can start at the Analy...

  MikeD_Anderson

  JSL Cookbook |

  Feb 14, 2023 1:33 PM

  1174 views | 0 replies

• Add a Summary Statistic Graph Reference Line that Responds to Local Data Filter Changes

      Create a run chart with a reference line for the mean of the data. Add a local data filter and have the mean change as categories are selected. Have the mean honor excluded rows. Ingredients: Graph BuilderRow State Handlers Sample Data Table: Big Class Difficulty: Hard Steps: Start the script with Names Default to Here(1);Open the Big Class sample data table and give it a reference dt. dt...

  Di_Michelson

  JSL Cookbook |

  Oct 17, 2022 1:58 PM

  1269 views | 0 replies

• Run a Platform without Knowing the Number or Names of Columns

  (view in My Videos)   A common practice is to run a regular analysis using data where the number or names of the inputs differ. This recipe provides a general method for getting columns into an analysis platform without knowing how many there are or their names. This is accomplished through the power of expression handling. Ingredients: Expression handling Sample Data Tables: Cars 1993 Difficu...

  DonMcCormack

  JSL Cookbook |

  Oct 13, 2022 2:07 PM

  1862 views | 1 replies

• JSL Cookbook Subject Index

  Subject Recipes Application Builder   Create a Parameterized Application with Application Builder Generalizing an App Builder Parameterized Application   Associative Arrays   Accessing Information using REST/API – Getting Started   Colors   Modify a Report Based on Analysis Results   Data Table Objects   Join 2 Tables and Create a Subset   Debugger   The JSL Debugger – Basics The JSL Deb...

  DonMcCormack

  JSL Cookbook |

  Oct 13, 2022 12:30 PM

  1033 views | 0 replies

• The JSL Debugger – Next Steps

    For this recipe, we will look at what makes the JSL debugger truly powerful, conditional breakpoints. This feature lets us pause a script when a specific condition is met, such as when a variable reaches a certain value. With it, we can target specific input values, loop iterations, column numbers, etc. We will use the same program as we did for the JSL Debugger – Getting Started recipe. It ha...

  DonMcCormack

  JSL Cookbook |

  Oct 13, 2022 8:06 AM

  1421 views | 0 replies

• Join 2 Tables and Create a Subset

  (view in My Videos)   In this simple recipe we see how to work with operations from the Tables menu. The JSL code behind many common interactive operations to JMP objects is saved to the Action Recorder and we will want to use it here. Only a few slight tweaks to the prepackaged code are needed to make the results more general and robust. We will start by performing all operations interactively t...

  DonMcCormack

  JSL Cookbook |

  Feb 25, 2022 12:42 PM

  1564 views | 0 replies

• Using a Dialog Box to Create a Tailored Report

  (view in My Videos)   This takes the code from Build a Tailored Report using Messages and generalizes it so it can be used with two or more continuous columns from any data table. A non-modal dialog box is created so columns can be selected by the user. Ingredients: DialogsUser InputExpression Handling Sample Data Tables – Tablet Production Difficulty – Hard Video Length – 5:07 Steps: Start w...

  DonMcCormack

  JSL Cookbook |

  Feb 23, 2022 1:49 PM

  1721 views | 0 replies

• The Script Window - Basics

  (view in My Videos)   The script window contains several interesting features of which new users may not be aware. This recipe introduces you to some. Ingredients: Script EditorScripting IndexEnhanced Log Difficulty – Very Easy Video Length – 3:40 Steps: Open both the log (Windows: View > Log, Mac: Window > Log) and a new script window (File > New > Script, Mac: File > New > New Script). Type...

  DonMcCormack

  JSL Cookbook |

  Feb 23, 2022 12:14 PM

  4713 views | 0 replies

• Modify a Report Based on Analysis Results

  (view in My Videos)   This recipe is motivated by material in the Display Trees chapter of the Scripting Guide. We will fit several models using the Bivarate platform and modify the report based on the results. The recipe shows how to navigate a report window to find the elements of interest. The Properties Window is used to show how to identify the object class name of report elements. A basic o...

  DonMcCormack

  JSL Cookbook |

  Feb 23, 2022 12:13 PM

  1349 views | 0 replies

• Concatenate CSV Files Selected by User

  (view in My Videos) For this recipe, we’ll keep things simple. It lets us adapt Multiple File Import so files can be selected at runtime. The Enhanced Log will be used to capture the code associated with opening CSV files. User input comes via the Pick File function, returning a list of file paths. We will parse these results to extract the directory containing the files and the file names. These ...

  DonMcCormack

  JSL Cookbook |

  Feb 14, 2022 12:42 PM

  1715 views | 0 replies