JMP User Community

Latest Discussions

How do I get rows based on dynamic column selection in JSL

In a JMP script I would like to retrieve the rows matching a certain criteria specified by user. I would like to do something similar to this: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); r = dt << Get Rows Where( :sex == "M" ); Show( r ); Only where the criteria is selected by the user, i.e. the column ("sex") and the target value ("M") should be dynamic. I have tried ...
peter_t

Discussions |
Aug 26, 2025 2:25 AM

820 views | 1 replies
create new column and set each row value from different column based on another column (column name variable)

Hi, I have data similar to example in picture. first 6 columns are related. I created MaxCol to find out who has the Max which based on first 3 columns, then I want to create MaxValFromCol column where it take value from one of the column from 4-6. it will pick value from column 4-6 based on MaxCol. I tried to set the value of MaxValFromCol using Column(char(:MaxCol) || "_t"), but not success. ...
dadawasozo

Discussions |
Aug 25, 2025 9:31 PM

1253 views | 5 replies
Add a column with a column name where last data is available.

How can I add failure column with a column name from where test data start missing?
ConfidenceOwl94

Discussions |
Aug 25, 2025 9:26 PM

820 views | 2 replies
Easy way to broadcast x-axis settings in Run Chart

Under Analyze>Quality and Process>Control Charts>Run Chart, if you make run chart plots of multiple Y variables, it does not appear that you can broadcast x-axis settings for all the charts. Rather frustrating. Any workarounds for this?
MathStatChem

Discussions |
Aug 25, 2025 10:35 AM

462 views | 3 replies
Different % Gaugae R&R results in Variability Gauge report

In a Variability Gauge report there are two different %Gauge R&R results cfr. below Why is result 41,1% in Summary Gauge R&R statistics different from Variance Components result = 16,89% ? Which result must be used to report %Gauge R&R?
frankderuyck

Discussions |
Aug 25, 2025 8:12 AM

514 views | 3 replies

Previous
Next

Latest Discussions

create new column and set each row value from different column based on another column (column name variable)

Hi, I have data similar to example in picture. first 6 columns are related. I created MaxCol to find out who has the Max which based on first 3 columns, then I want to create MaxValFromCol column where it take value from one of the column from 4-6. it will pick value from column 4-6 based on MaxCol. I tried to set the value of MaxValFromCol using Column(char(:MaxCol) || "_t"), but not success. ...
dadawasozo

Discussions |
Aug 25, 2025 9:31 PM

1253 views | 5 replies
Easy way to broadcast x-axis settings in Run Chart

Under Analyze>Quality and Process>Control Charts>Run Chart, if you make run chart plots of multiple Y variables, it does not appear that you can broadcast x-axis settings for all the charts. Rather frustrating. Any workarounds for this?
MathStatChem

Discussions |
Aug 25, 2025 10:35 AM

462 views | 3 replies
How to separate excel "copy paste" in JMP string?

Hey, so by copy pasting some cells from excel into a JMP data table column, the cells are perfectly split into separate rows. But if I paste the same cells into a text edit box or just in a JSL script, the cells are only separated by a "pseudo" line break. They all are in different rows but don't have a whitespace or line break or other delimiter in between. How can I separate them like JMP does i...
Erik_The_First

Discussions |
Aug 25, 2025 12:13 AM

911 views | 3 replies
PSM

JMP Student Editionを使用しています。プロペンシティスコアマッチングを利用したいため、フリーのアドオンソフトをダウンロードできたりしますか？
hro0802

Discussions |
Aug 22, 2025 1:22 PM

747 views | 1 replies
Making the 'automatic peak finding' work (JMP Pro V18)

I have data with very clear peaks as in the image below. However, if I try and use the 'automatic peak finding' It identifies the right number of peaks, but they're all the same with start / stop as the beginning and end of the data for every peak. (second picture) What am I doing wrong?
RC_Flyer

Discussions |
Aug 22, 2025 2:43 AM

925 views | 2 replies

Previous
Next

Latest Discussions

permutation test for PLS-DA

Hi all! I've run a PLS-DA test for a data set that consists of FTIR spectral data of 5 different systems under 5 different treatments. I've used the fit model platform so that I could handle categorical variables in my Y variables. According to PRESS statistics, this model has an optimum number of factors of 7 and possesses good discriminating power between my samples. Then, I noticed that the st...
Mariana_Aguilar

Discussions |
Aug 20, 2025 8:45 PM

1183 views | 0 replies
How to assign columns to 'Cause' and 'Grouping' roles, 'scale' and 'shape' effect in JMP recurrence analysis

Hi, all
I am a new member to the community. I am assigned a task to perform recurrence analysis on our data. I never used JMP or did any recurrence analysis. So I will bring some stupid questions for sure.
The data we have are robots repair. We want to see repairs event pattern for the bots and I was told to use recurrence analysis (don't know why). So we have around 15000 robots, I used the 'bot_id...
Caozheng0115

Discussions |
Aug 8, 2025 10:42 AM

733 views | 0 replies
Customer quantile

Hello, looking for the upper and lower cut off of exponential distribution and Weibull distribution, I could find custom quantile to designate the probability. Have a couple questions. In the old jump version, saw it quantile feature allowing probability number to type, it is the same as custom quantile in JUMP 17. Seems like there is confidence level set as default value of 0.95, having trie...
SignalRaccoon27

Discussions |
Aug 8, 2025 7:25 AM

353 views | 0 replies
Regarding the "Model Sensitivity Profiler" in "Constant Stress ALT Design". The pre-estimated values have been set in the "Acceleration Model settings", and these set values cannot be modified. Besides, the values of "Approx. Fail Time for Setting 1" and "Approx. Fail Time for Setting 2" in the "Mod

May I ask a question: Regarding the "Model Sensitivity Profiler" in "Constant Stress ALT Design". The pre-estimated values have been set in the "Acceleration Model settings", and these set values cannot be modified. Besides, the values of "Approx. Fail Time for Setting 1" and "Approx. Fail Time for Setting 2" in the "Model Sensitivity Profiler" are also unchangeable. What is the significance of th...
Rily_Maya

Discussions |
Jul 15, 2025 6:14 PM

512 views | 0 replies
Rows inclusion in PCA

Hello, I am running a PCA on an NMR dataset that contains some missing values. This isn't due to an error—it's simply the nature of the data, as some samples do not show certain peaks. I have noticed that when I include these parameters Y variables in the PCA and color the score plot by sample, some samples are missing entirely from the plot. It's not consistent—some samples with missing values...
NMR

Discussions |
Jul 11, 2025 3:57 AM

314 views | 0 replies

Previous
Next

Welcome to the JMP User Community!

Learning Resources

Latest Discussions

How do I get rows based on dynamic column selection in JSL

create new column and set each row value from different column based on another column (column name variable)

Add a column with a column name where last data is available.

Easy way to broadcast x-axis settings in Run Chart

Different % Gaugae R&R results in Variability Gauge report

Latest Discussions

create new column and set each row value from different column based on another column (column name variable)

Easy way to broadcast x-axis settings in Run Chart

How to separate excel "copy paste" in JMP string?

PSM

Making the 'automatic peak finding' work (JMP Pro V18)

Latest Discussions

permutation test for PLS-DA

How to assign columns to 'Cause' and 'Grouping' roles, 'scale' and 'shape' effect in JMP recurrence analysis

Customer quantile

Regarding the "Model Sensitivity Profiler" in "Constant Stress ALT Design". The pre-estimated values have been set in the "Acceleration Model settings", and these set values cannot be modified. Besides, the values of "Approx. Fail Time for Setting 1" and "Approx. Fail Time for Setting 2" in the "Mod

Rows inclusion in PCA

JMP Events

Exploring space filling designs part 3: Results, analysis, and design selection guidelines