Add favorite formula columns to a table
Problem You want to add the same set of new, formula-based columns to your data over and over again. Solution Store the formulas and column names in a table. Extract them from that table...
hardnerProblem You want to add the same set of new, formula-based columns to your data over and over again. Solution Store the formulas and column names in a table. Extract them from that table...
hardnerProblem While looking at an aggregated data visualization, I want to get insights into the underlying data distribution by having the associated histogram displayed directly on the graph toolt...
nascif_jmpProblem In many situations, when you are using a slider box to control a numeric variable, you also want a editable number display to display the value of the variable, and that allows you to manuall...
MathStatChemProblem Create a geographic map with "graphlets" positioned over associated map locations. Solution Context is everything! So just as one might want to embed tiny line...
nascif_jmpProblem Some web sites provide a REST API to read data, and often the response is text in JSON format. How do we get that into JMP? Solution Here is a example using the meetup.com REST API....
XanGreggProblem You run an analysis in JMP and want to extract some of the statistics from the platform report. Then you want to place those statistics into a custom report window, so that you can keep tho...
michael_jmpProblem You need to sort a table using one or more columns as the sort key. Solution Use the table's sort method, which supports ascending and descending order and in-place or new table sor...
Craige_HalesProblem You need to execute some JSL more than once. Solution Use a for(...) or while(...) or one of the more exotic variations. The for loop is the most common way to repeat some s...
Craige_HalesProblem You have colors in the HTML format "#RRGGBB" and you want to use them in JMP graphs. For instance, here is the data set I used for the world metro stations scatter plot. The color colu...
XanGreggProblem You need special purpose icons on buttons. Solution Make your own pictures and specify them as the icon for a button. First, an easy example, where you might use ms-paint to make a ...
Craige_HalesProblem So here's the deal, I do a lot of presenting on lots of JMP topics for general and specific audiences. Not only different audiences but also I use a Mac and a PC virtual machine on the same...
Byron_JMPProblem You have a list of items that you want to rotate, moving items from the beginning of the list to the end or the end to the beginning. You might think of the list as circular. Rotate a c...
Craige_HalesProblem You need a countdown timer for New Year's Eve, and for some reason, you need it built from unlikely display boxes. Solution Use a LineUp box to hold a bunch of spacer boxes to form ...
Craige_HalesProblem You have JSL that can be used in more than one project, with minor changes, and you want to keep one copy to make it easier to maintain. Solution Use a separate file and include it ...
Craige_HalesProblem You've opened a table to show a report. The table might be temporary or invisible, and you want the table to go away silently when the report is closed. Solution Use the <<OnC...
Craige_HalesProblem You have some XML data that you want to import into a JMP Data Table. In this example, I am using the JMP User Community's RSS feed for add-ins found here. Below is a snippet of the feed....
Justin_ChiltonProblem As a JMP HTML5 tester, what I often do is to generate a JMP report, and then export it to HTML5. However, I want to cover more testing cases for each exporting. For example...
Hui_DiProblem You need to compress an entire folder into a single ".zip" file. Solution Use JMP's built-in support for compressing files to create a ZipA...
Justin_ChiltonProblem I'm doing a bunch of research on a long list of companies and I want to know what their websites are. A good indicator that a company has be acquired is that either its website is missing o...
Byron_JMPProblem You have a text string that has a repeating pattern. You want to extract some data from the string into a data table. Each repetition in the string represents a row in the table. There migh...
Craige_HalesProblem You are writing JSL to make a data table and you are not sure how to script creating the table and columns. Solution Make a data table, using JMP's GUI, that looks the way you want....
Craige_HalesProblem Many applications require prompting the user for inputs or choices and then acting on that input. This recipe creates a modeless (i.e., non-modal) dialog box with choices. When th...
Jeff_PerkinsonProblem You need a set of bitmaps to make a GIF animation or a video. Solution This JSL shows how you might change a platform parameter over a series of values and capture a picture at each...
Craige_HalesProblem Often, sensors recording values of system have specification of operating range and/or minimum and maximum allowable values. For various reasons, sensor occasionally send spurious values, w...
Daniel_ValenteProblem Instead of a full data set, you have a summarized version that contains the five numbers needed to define a box plot. Solution You can use frequencies to mimic a full data set based...
michael_jmp