JMP User Community

Latest Discussions

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

1269 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

442 views | 6 replies
Column Switcher not appearing in Graph Builder script

I’ve written a Graph Builder script with two Column Switchers (for X and Y axes).
The code runs without errors, but the Column Switcher controls do not appear in the graph UI. When I simplify to a standalone Graph Builder (outside New Window or New Script), the switchers appear normally. Is there a known limitation or syntax nuance that causes Column Switcher not to render when used inside saved ta...
zetaVagabond1

Discussions |
Nov 10, 2025 4:35 AM

289 views | 4 replies

Previous
Next

Latest Discussions

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

1269 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

442 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

848 views | 10 replies
DSD with categorial Factor

Hello Everyone, I am a masters student currently finishing my thesis. The objective of the thesis is to increase vertical axis wind turbine efficiency by adding winglets and optimizing the winglets design parameters to maximize efficiency (using DOE). The design parameters of these winglets consist of 7 continuous parameters, and 1 categorial parameter (2-level). I am lost on how to proceed after ...
Mohnasre

Discussions |
Nov 9, 2025 8:21 PM

879 views | 13 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