JMP User Community

Latest Discussions

Combine information in rows by common name in one column

I have a large spreadsheet and want to sum information into one row by the name in the last column shown here. Is there an easy way to do this?
BiologyUser

Discussions |
Feb 28, 2017 6:29 AM

11520 views | 2 replies
Screening test in mixture design

Hi Martin Y here: I have a question about how to run screening in mixture design. Below is an example: Cement 1: 36%Cement 2: 15%gypsum: 5%accelerator: 0.2%retarder: 0.1%additive 1: 0.2%additive 2:0.3%filler 1: 20%filler 2: 23.2%Total 100% Suppose I want to run a screening test first, I want to pick 5 or 6 factors, the ingredients in the formulation all can not be zero. So all the ingredien...
MartinY

Discussions |
Feb 27, 2017 3:25 PM

8967 views | 5 replies
Using functions within Graph Builder Dispatch

I am building a tool for some custom graphs. I want the tool to be easily modified by users that I share it with. To reduce the barrier for entry I would like to use sub-functions which I call within a master function. Each sub function would represent a smaller part of the overall main function.
My question: Is it possoble to replace the arguments of 'Dispatch' within the graph builder as a functi...
kevinwtbolger

Discussions |
Feb 26, 2017 1:46 PM

8267 views | 4 replies
Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3592 views | 0 replies
Labeling rows as greater/less than a date with JSL

I have a dataset with a date column formatted dd/mm/yyyy hh:mm. In my script I want to be able to set a variable equal to some date and then have the script create a new column labelling all rows as being “before” of “after” the specified date.The workaround I’m using is to format the variable and the column in seconds but it’s not easy to read.Is there a way to keep the dd/mm/yyyy formatting whe...
jamiesupica0

Discussions |
Feb 25, 2017 11:49 AM

9530 views | 2 replies

Previous
Next

Latest Discussions

Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3592 views | 0 replies
Using "Get Rows Where"

I need to use Get Rows Where to get the row with value that is just below certain value.In other words:I have a Date AI have a table with dates. I need to get the row where the date is the latest, but less than Date A Example:I have a date when person died.I have table with all event when somebody logged in into his account. There are dates before and after his death.I need to find the latest dat...
miguello

Discussions |
Feb 18, 2017 4:45 AM

7329 views | 3 replies
Make JMP Journal Transportable

JMP supports talks about "Building a JMP Journal Presentation". How can you create a journal that will still work when it is: Transported to another computer, possible switching between Windows and Mac, Viewable from a USB drive, no matter what drive/folder the host mounts the drive in.
kthompsn

Discussions |
Feb 15, 2017 10:45 AM

7731 views | 3 replies
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4586 views | 0 replies
Automate a Gauge R&R with many measurement columns

I would like to know if you can take a "spec limit" file that is used to add limits to a capability study and use it to add limits to the column properties all at once to perform a gauge R&R without inputting them in one by one. I would like to get a precision to tolerance ratio and need the spec limits for all of the columns.
jjhartwi

Discussions |
Feb 14, 2017 11:41 AM

5547 views | 3 replies

Previous
Next

Latest Discussions

Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3592 views | 0 replies
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4586 views | 0 replies
How to Maintain JMP Graphs Table Layout When Copy and Pasting into Word

For years I've had to build sets of graphs using the Fit Y by X platform. The graphs are simple: X-axis is always (1) a character, nominal column and (2) a numeric, continuous date/time column. The Y-axis is always numeric, continuous data (bins, registers, parameters). The result is a list of box plot on the left, time trend on the right. There could be many plots at a time. In JMP 12 (and I thin...
MIKE

Discussions |
Dec 14, 2016 8:48 AM

4912 views | 0 replies
Odds ratios for multiway tables

On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...
DonMcCormack

Discussions |
Aug 10, 2016 3:35 PM

5038 views | 0 replies
How to find ETA squared effect size for MANOVA?

Hello, Does anyone know how to calculate the eta squared value from a manova analysis in JMP? I know that the E and H matrices tab shows the sum of squares for each parameter, but which values do I use to calculate SStotal and SSeffect? In my model, I have 2 control variables (age and gender) and then a two way factorial. If only one of these variables (in addition to both control variables) is si...
nsalmano_stanfo

Discussions |
Aug 8, 2016 7:04 AM

4127 views | 0 replies