JMP User Community

Latest Discussions

How to find the difference between rows by a group with missing data?

I'm running into this issue where I have two sets of datapoints across my timeline. One is collected at every point in the interval, the other is collected sporadically. When placed together in a data table, one of the columns is missing data every in the interval. I attached a data table as an example but essentially looks like this: What I need now is to get the difference between rows that con...
PruningTheBird9

Discussions |
Dec 30, 2025 9:55 AM

83 views | 2 replies
Tiny Traps in Jmp and JSL

JMP has 1 million cool features which allow the user to analyze the data at warp speed.
There are just a few tiny traps. They are less annoying for users who know where they are hidden.
→ Let's make a map! - and stay away from the dangerous places.

[More Topic Containers like this one] Topic:additional infov18V19Graph Builder and Reports
Graph Builder + multiple response + multiple histograms

TS...
hogi

Discussions |
Dec 25, 2025 1:41 PM

4487 views | 7 replies
Setting Value Order or Value Label by Another Column

I have an interesting value ordering/labeling problem. See attached files. The data come from a gas chromatograph. The order that matters is not the alpha-sort of the name of the compound but the retention time (R.T.). There are 31 compounds = manual value ordering of the Compound column or manual value labeling of either the R.T. or MW Order columns will be painful and error-prone. Anyone working...
markschahl

Discussions |
Dec 23, 2025 2:02 PM

797 views | 7 replies
Update Column Axis Reference Line based on data from another data table

I'm looking to add column reference lines based on data from another data able. An example, using "Big Class" would update columns "weight' and "height" with P50 and P95 values from a lookup data table. The rows on the lookup data table correspond to the column names in the main table. The reference lines would need to assign the label value from the lookup table column name "P50" or "P95" and t...
Heart_To_Tell

Discussions |
Dec 22, 2025 10:11 PM

3362 views | 9 replies
The entered formula cannot be automatically calculated. Every time the file is opened, the symbols of the formula appear in gray color. One must manually click "Apply" in the formula editor to run the formula.
wenwenzhou

Discussions |
Dec 21, 2025 9:56 PM

100 views | 1 replies

Next

Latest Discussions

Tiny Traps in Jmp and JSL

JMP has 1 million cool features which allow the user to analyze the data at warp speed.
There are just a few tiny traps. They are less annoying for users who know where they are hidden.
→ Let's make a map! - and stay away from the dangerous places.

[More Topic Containers like this one] Topic:additional infov18V19Graph Builder and Reports
Graph Builder + multiple response + multiple histograms

TS...
hogi

Discussions |
Dec 25, 2025 1:41 PM

4487 views | 7 replies
Update Column Axis Reference Line based on data from another data table

I'm looking to add column reference lines based on data from another data able. An example, using "Big Class" would update columns "weight' and "height" with P50 and P95 values from a lookup data table. The rows on the lookup data table correspond to the column names in the main table. The reference lines would need to assign the label value from the lookup table column name "P50" or "P95" and t...
Heart_To_Tell

Discussions |
Dec 22, 2025 10:11 PM

3362 views | 9 replies
The entered formula cannot be automatically calculated. Every time the file is opened, the symbols of the formula appear in gray color. One must manually click "Apply" in the formula editor to run the formula.
wenwenzhou

Discussions |
Dec 21, 2025 9:56 PM

100 views | 1 replies
Control/Spec limits color

Hi, In process screening, is there an option to set up the control and spec limits color to different one than the default? (Blue for Spec limits, Red for control limits)
ShaiV

Discussions |
Dec 21, 2025 6:51 AM

98 views | 1 replies
Update: 20 columns

It can be time-consuming to update a table with column from another table.
Especially: to pick the right columns - if the user wants to add more than a few columns - and if there are dozens or hundreds of column in the source table. For Big Class everything is smooth: What cold help: Check Box Display - the option for the Data Filter.
Is there a hidden setting to activate this mode for a Column Fi...
hogi

Discussions |
Dec 17, 2025 5:54 AM

133 views | 1 replies

Next

Latest Discussions

Workarounds

very simple tasks - JMP says NO. TaskJMP saysworkaroundswishimplementedadd column via Tables/Updatecolumn existsrename one of the columnsAllow Update platform to create new columns if they already exist in the table to be updatedv19copy a cellformula column- recode to dummy column | copy cell | delete dummy column
- screenshot | OCREdit Pane allows for text copy even if no edit ...
hogi

Discussions |
Oct 7, 2025 3:51 PM

319 views | 0 replies
Time varying effect in Recurrence Analysis, data format and calculation

Dear all
I am assigned a task to perform recurrence analysis on our data.
The data we have are robot repairs. We want to see repair events and cost in response to accumulated transactions using recurrence analysis.
I attached a simulated data for this question. It only has three bots since we haven't decided how to arrange the data and I just put those three bots manually. I will update with more ...
Caozheng0115

Discussions |
Sep 26, 2025 11:29 AM

850 views | 0 replies
Copy Formula for Tables / Update

In Tables / subset, the user can decide if a column formula is copied and if the evaluation is suppressed: Is there a hidden option which does the same trick for Tables/Update?

great for "documentation"great for "what if" ...on the other hand: one cannot guarantee that all input columns for the formula will be available in the target data table.
-> default option "suppress formula evaluation"?
hogi

Discussions |
Sep 12, 2025 7:47 AM

913 views | 0 replies
How to adjust the size of R plot imported with get R graphics(); ?

I'm trying to run R code in JMP to create a plot. I succeeded in importing the plot in png format, but failed to adjust the size of the plot. I can adjust the "plot_from_R" in png format with the set size(); function in jsl, but it is not proportional and distorted. How can I import plot_from_R in the size I want? R Init(); R Submit( "\[ windows(300,100) #it doesn't work plot(function(x) dnorm(...
CountableModel1

Discussions |
Jan 15, 2025 4:01 PM

620 views | 0 replies
user defined Transform Category?

How can I create a custom function which shows up in the Character submenu of the new formula column menu?

hogi

Discussions |
Dec 4, 2024 5:01 AM

443 views | 0 replies

Next

Welcome to the JMP User Community!

Learning Resources

Latest Discussions

How to find the difference between rows by a group with missing data?

Tiny Traps in Jmp and JSL

Setting Value Order or Value Label by Another Column

Update Column Axis Reference Line based on data from another data table

The entered formula cannot be automatically calculated. Every time the file is opened, the symbols of the formula appear in gray color. One must manually click "Apply" in the formula editor to run the formula.

Latest Discussions

Tiny Traps in Jmp and JSL

Update Column Axis Reference Line based on data from another data table

The entered formula cannot be automatically calculated. Every time the file is opened, the symbols of the formula appear in gray color. One must manually click "Apply" in the formula editor to run the formula.

Control/Spec limits color

Update: 20 columns

Latest Discussions

Workarounds

Time varying effect in Recurrence Analysis, data format and calculation

Copy Formula for Tables / Update

How to adjust the size of R plot imported with get R graphics(); ?

user defined Transform Category?

JMP Events

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration