JMP User Community

Latest Discussions

Exclude Grouping values in nested groups in graph builder.

I have a heat map that needs some nested groups (in order to properly show values inside the heat map) squares. My issue is that a lot of the rows are entirely missing because it forces every group to exist. Is there a way to only show valid groups? For example: Names Default to here(1); dt = open("$SAMPLE_DATA\Big Class.jmp"); rows = dt << Get Rows Where(:age == 14 & :sex == "M"); dt << del...
vince_faller

Discussions |
Jun 14, 2018 10:05 AM

10241 views | 6 replies
How do I evaluate a JMP derived desirability function on specific parameters not run in experiment

Context: I have data from a respose surface experiment. I've modeled the responses and obtained the desirability function (e.g. I used the profiler to "save desirabilities" got a new column in my table and can double click the column header and see the function). I know about as much as one can about how that function comes about up to what I think is proprietary --- that it is Exp(w_1Log(d_1) +...
ataylor

Discussions |
Jun 14, 2018 9:40 AM

5121 views | 1 replies
Stack with spec limits

Hi,How can I perform new table by stack for several columns with spec limits (as properties) and create two new columns with spec low and spec high each Label according to initial table properties?See attachedIf possible, also pass/fail column Thanks in advance!Assaf
Assaf1

Discussions |
Jun 14, 2018 6:20 AM

10061 views | 4 replies
Nested if Statement

Hi, I just want to make sure that the following nested if statement will function correctly. At the moment I'm getting an error so I thought it might be to do with the way I constructed my nested if statement:If (ismissing(dt:newColumnName[k]), For Each Row(If(dt:colAutomatically <= colManually[k] & dt:colAutomatically >= colManuallyStart[k], dt:newColumnName = colInstructions[k], dt: newColumnNa...
Jaz

Discussions |
Jun 14, 2018 2:04 AM

4671 views | 2 replies
Variability Gage plot labeling of means

Hello! Whenever I plot a variability gage plot, I use text boxes in order to label the means displayed in the summary report below the plot. Is there an easier way to quickly create labels? My only thought on this would be to create a new column to calculate the means of each grouping so that I can then label rows by that new column. However, I have no idea how to "group-by" in the formula editor....
Dr_Ballesteros

Discussions |
Jun 13, 2018 2:05 PM

4107 views | 1 replies

Previous
Next

Latest Discussions

Nested if Statement

Hi, I just want to make sure that the following nested if statement will function correctly. At the moment I'm getting an error so I thought it might be to do with the way I constructed my nested if statement:If (ismissing(dt:newColumnName[k]), For Each Row(If(dt:colAutomatically <= colManually[k] & dt:colAutomatically >= colManuallyStart[k], dt:newColumnName = colInstructions[k], dt: newColumnNa...
Jaz

Discussions |
Jun 14, 2018 2:04 AM

4671 views | 2 replies
Variability Gage plot labeling of means

Hello! Whenever I plot a variability gage plot, I use text boxes in order to label the means displayed in the summary report below the plot. Is there an easier way to quickly create labels? My only thought on this would be to create a new column to calculate the means of each grouping so that I can then label rows by that new column. However, I have no idea how to "group-by" in the formula editor....
Dr_Ballesteros

Discussions |
Jun 13, 2018 2:05 PM

4107 views | 1 replies
The difference between glue and if

Could someone gives me some insprision about the differences between glue and if in jmp? I got so confused. Thanks a lot!
Anonymous

Discussions |
Jun 13, 2018 5:42 AM

6668 views | 4 replies
Use ComboBox on TableBox

Hi I want to make a tablebox that one of it column eatch cell can have a value of "Yes" or "No"thought of using a combobox for ittry using the following code with no success new window("Bla Bla",
tb = Table Box(
c1 = String Col Box( "Bla Bla", {cb = combo box({"Yes","No"}) << get selected})
)
) any idea
cerdmh

Discussions |
Jun 11, 2018 5:31 AM

4732 views | 4 replies
How to set changing upper/lower limit lines on graph builder

Hello, I have a simple Y vs X graph that the upper limit and lower limit are changing at different X values. Does anyone know how to do this on Graph Builder? or if there's a better way to do it? Thanks,Gary
bgeaibreyi

Discussions |
Jun 8, 2018 4:54 PM

7047 views | 4 replies

Previous
Next

Latest Discussions

Time Series - Prewhiten

Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2508 views | 0 replies
Fit Spline By Group: Save Spline Coefficients to Column?

Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

3094 views | 0 replies
Why does Profiler not stop

All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.
uday_guntupalli

Discussions |
Apr 27, 2018 7:12 AM

1889 views | 0 replies
P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

4058 views | 0 replies
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard

Discussions |
Mar 15, 2018 1:57 PM

2861 views | 0 replies