JMP User Community

Latest Discussions

Random effect mixed model

Hello, I am building a DoE model. However, I see that the R2 for my model fit is not good. This could be due to the analytical sequence of sample measurement affecting the measured data. I added 'Analytical sequence- Series' as a random effect factor in the model. I see that the % from this factor is quite high in the model. In other models, they are lower. At what value should we start considerin...
Coverbird30

Discussions |
Nov 11, 2025 6:48 AM

343 views | 4 replies
Tracking events in a dot plot

Hi, I frequently make these sparse dot plots -- this is tracking a metric over a counting metric, so left to right is further into a test. The ordinate is a one-dimensional spatial location. When we see shapes in the data, we want to know what event may have precipitated them. What we typically do is use Color of an event column. But I'm not a fan because the colors on these small dots can be di...
jay_holavarri

Discussions |
Nov 10, 2025 3:47 PM

610 views | 7 replies
How to use a column to "Value Order" another column

Dear JMP Community, Is it possible to use the numerical values (integers) of one column as a way to "Value Order" another column? I have a text column that I'd like to have ordered according to another column that contains integers. As an example, I have a column called :Text and one called :Level. By default, JMP orders the "Value Order" column property as such: I'd prefer to have it ordere...
SDF1

Discussions |
Nov 10, 2025 2:51 PM

10387 views | 17 replies
Zero padding as a column format

Hey JMP peps! Is there a way to use a column format to make an integer value be zero padded? I know you can make a new formula and use right(:col, 5, "0") to get zero padding but it creates a new column that is a character Data type. In excel, you can use a format of "00000" to get zero padding up to five digits (to match the right() example above). Thanks for any ideas! Steve
shampton82

Discussions |
Nov 10, 2025 1:23 PM

203 views | 2 replies
Formula column to obtain unique values using grouping columns

What would be a simple column formula to obtain unique values with large datasets (100k rows)? Is this possible? For example, looking at Cars.jmp. The distribution platform gives already the number of levels (unique elements), but I couldn't find a formula column able to calculate these. Make column --> 37 levels (different manufacturers). This is often called cardinality, distinct, or number of u...
FN

Discussions |
Nov 10, 2025 9:45 AM

1267 views | 4 replies

Previous
Next

Latest Discussions

Random effect mixed model

Hello, I am building a DoE model. However, I see that the R2 for my model fit is not good. This could be due to the analytical sequence of sample measurement affecting the measured data. I added 'Analytical sequence- Series' as a random effect factor in the model. I see that the % from this factor is quite high in the model. In other models, they are lower. At what value should we start considerin...
Coverbird30

Discussions |
Nov 11, 2025 6:48 AM

343 views | 4 replies
Formula column to obtain unique values using grouping columns

What would be a simple column formula to obtain unique values with large datasets (100k rows)? Is this possible? For example, looking at Cars.jmp. The distribution platform gives already the number of levels (unique elements), but I couldn't find a formula column able to calculate these. Make column --> 37 levels (different manufacturers). This is often called cardinality, distinct, or number of u...
FN

Discussions |
Nov 10, 2025 9:45 AM

1267 views | 4 replies
Process capability Non-conformance to conformance

Hello. I am using the Process Capability analysis to generate charts for my reports. One of the summary tables is for 'Nonconformance', which can also be used to represent failure rate I am interested in generating a table that shows yield numbers directly instead of having to interpret it from the Nonformance table. Is there a way to achieve that directly through the default options available wit...
syshah_psiq

Discussions |
Nov 10, 2025 9:42 AM

441 views | 6 replies
Difficulty in finding course data folder in Jmp coursera course

Hi I have can't find the course data folder in Jmp coursera course. In Module 3 course, it says "Open the file Chemical Manufacturing.jmp in the course data folder." but i can't find the course data folder, Any taking this course, please help, thanks
Khalil

Discussions |
Nov 10, 2025 1:11 AM

135 views | 1 replies
How to convert UTC timestamp to local time in a column formula

Hi all, I have a column Timestamp UTC in JMP with values like 2025-10-31T08:30:00.
I want to create a new column Timestamp Local that converts this UTC time to local time
Is there a simple formula-based way to add 5.5 hours to my timestamp directly in a column formula, without scripting or using Date Add? Something like: Informat(:Timestamp UTC, "yyyy-mm-ddThh:mm:ss") + (4 * 3600) but I’m not sur...
zetaVagabond1

Discussions |
Nov 9, 2025 9:30 PM

846 views | 10 replies

Previous
Next

Latest Discussions

Shape column : default markers?

Hi, while waiting for new Column Property: Value Markers , I tried to use a Shape Column in Graph builder for better/consistent marker control: Not bad ... but I need more details: How can I specify one of the default markers? nice trick: empty entries are displayed with a "dot"
but: Marker Drawing Mode - Outlined doesn't work. why? View more... Names Default to Here(1); dt = Open( "$SAMPLE_D...
hogi

Discussions |
Nov 8, 2025 8:38 AM

144 views | 0 replies
Creating a separate Y axis for each panel of my bar chart

Hello everyone! Does anyone know how to create individual Y axis for a bar chart that consists of two different panels? I'd like to adjust the scale on the top panel but I haven't been able to do so... I've tried dragging two different variables onto the Y axis. While that works for the axis' scale, it does weird things for my error bars, since it combines the standard deviation of both panels ont...
Mariana_Aguilar

Discussions |
Nov 6, 2025 8:48 PM

127 views | 0 replies
Python and Formula Columns

Formula Column are very restrictive.
If the entries of a JMP column are defined by a column formula , there is no possibility to change individual entries, neither manually nor via JSL: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << new column("row", Formula(row())) << run formulas; :row << suppress eval; Try(:row[5]=7, Caption("change a cell of a formula column via JSL? doesn't work")); Wait(2...
hogi

Discussions |
Nov 6, 2025 3:08 AM

169 views | 0 replies
Windows 11 > JMP 17.2 > Fit Model > Contrasts > How to Build a Contrast Matrix with More Columns than Conditions?

Hi JMP Community, When building contrasts in a Regular Least Squares Fit Model analysis, the number of columns (i.e., discrete contrasts) is limited to the number of conditions (i.e., number of items produced by the combinations of all parameters). In many cases, I'd like to create more contrasts than conditions (i.e., comparisons of multiple pairs of factor combinations) Example: VAR1 = A, B, C ...
Thierry_S

Discussions |
Oct 30, 2025 9:04 AM

160 views | 0 replies
QQ Plot behavior under factor coding and no-intercept model

Hi everyone, When I fit a model in JMP using factor coding and set the model to no intercept, I noticed that the residual normal quantile plot (QQ plot) behaves differently compared to the version with an intercept. Specifically, the residuals and the fitted “robust fit line” in the QQ plot seem to shift vertically, and even after centering the residuals, the slope of the fitted line changes sligh...
happy

Discussions |
Oct 30, 2025 4:56 AM

209 views | 0 replies