User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

Find courses, tutorials, and lots of other methods of learning JMP.

view all learning resources

Latest Discussions

  • Formula in jsl script

    I have single column table of numeric type, I want to add column and give a formula where it will check each cell of the first column with a variable name passed in script,  mycol << New Column ("belowCount", Numeric, Formula(If( col_to_check < limit_val, 1, 0 ) );   mycol is single column data table and col_to_check is reference first column and limit_val is variable When I open table formula is ...

    ravij ravij
    Discussions |
    Nov 11, 2025 9:18 AM
    310 views | 3 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 SDF1
    Discussions |
    Nov 10, 2025 2:51 PM
    10646 views | 17 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 zetaVagabond1
    Discussions |
    Nov 10, 2025 4:35 AM
    349 views | 4 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 zetaVagabond1
    Discussions |
    Nov 9, 2025 9:30 PM
    1137 views | 10 replies

  • Undocumented Secrets

    hidden secret in JMP: you can paste multiple column names via CTRL+C | CTRL+V   https://community.jmp.com/t5/Abstracts/Plenary-John-Sall-on-Secret-Features-of-JMP/ev-p/849554 @ 44min: (view in My Videos)   https://community.jmp.com/t5/Abstracts/Advanced-Data-Preparation-10-Essential-Tools-in-JMP-to-Get-From/ev-p/849401 ( @julian )   https://community.jmp.com/t5/Discussions/Possible-to-rename-all-c...

    hogi hogi
    Discussions |
    Nov 8, 2025 6:59 AM
    6192 views | 24 replies

Latest Discussions

  • 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 zetaVagabond1
    Discussions |
    Nov 9, 2025 9:30 PM
    1137 views | 10 replies

  • Undocumented Secrets

    hidden secret in JMP: you can paste multiple column names via CTRL+C | CTRL+V   https://community.jmp.com/t5/Abstracts/Plenary-John-Sall-on-Secret-Features-of-JMP/ev-p/849554 @ 44min: (view in My Videos)   https://community.jmp.com/t5/Abstracts/Advanced-Data-Preparation-10-Essential-Tools-in-JMP-to-Get-From/ev-p/849401 ( @julian )   https://community.jmp.com/t5/Discussions/Possible-to-rename-all-c...

    hogi hogi
    Discussions |
    Nov 8, 2025 6:59 AM
    6192 views | 24 replies

  • How to Generate Structured Gauge R&R Reports Across Multiple Tests (with Summary Tables)

    Hi JMP Community, Please see the attached image below for reference. I'm using JMp18.2.0. I attached the example file below as well.  I'm running Gauge R&R studies using JMP with the following setup: Operator1 is mapped to DIB_id Operator2 is mapped to Site I have 8 parts used for each test The Part ID column is used as the last nesting level (as shown in the "Variance Components for Gage R&R"...

    RA899 RA899
    Discussions |
    Nov 7, 2025 6:09 AM
    359 views | 4 replies

  • Encrypted Multiple File Import with XML Settings Troubles (JMP 18)

    XML Settings and Encryption don't seem to work well together. I repeatedly get the error: 
    "The XML Settings must begin with XMLSettings(...). Multiple File Import stopped.
    JSL Encrypted" Guessing Tall would work except there's metadata I need from a different section in the XML document Is there any way to get around this error? I am not sure why it cannot pull the XML settings when encrypted, but ...

    JMPHOWHIGH JMPHOWHIGH
    Discussions |
    Nov 7, 2025 5:24 AM
    220 views | 1 replies

  • Is there a way to make a script for a JMP Database Query?

    In order to get traceability of our materials, I currently build a DB query to pull data from a table an Engineering table in our DB.   Can I create a script to do this?

    cjackso21 cjackso21
    Discussions |
    Nov 6, 2025 7:08 PM
    247 views | 1 replies

Latest Discussions

  • 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 hogi
    Discussions |
    Nov 6, 2025 3:08 AM
    197 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 Thierry_S
    Discussions |
    Oct 30, 2025 9:04 AM
    187 views | 0 replies

  • WINDOWS > JMP 17.2 > Custom Report Window > Save Presentation ==> Only portion saved to PPTX

    Hi JMP Community, I built a simple report with a graph builder plot, a multicolumn text section, and a summary section (see below)  that I would like to export to PowerPoint. While I can save this report as a PDF without any problems, when I save it as a Presentation/PowerPoint manually or within the script, JMP generates slides that only contain the plot section and none of the text (GO GENES and...

    Thierry_S Thierry_S
    Discussions |
    Oct 20, 2025 8:06 AM
    255 views | 0 replies

  • 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 hogi
    Discussions |
    Oct 7, 2025 3:51 PM
    311 views | 0 replies

  • How to export a model formula to Excel?

    I want to be able to take the prediction formula that I got from my multiple linear regression and put it in excel. I have multiple Quantitative and Categorical X variables and some are splined. I have also preformed a BoxCox transformation. What are the steps that I need to do to take the formula that is given and have it working in excel. I have no coding experience but am not against learning a...

    DWS DWS
    Discussions |
    Jun 13, 2025 8:33 AM
    517 views | 0 replies
view all discussions

JMP Events

Sorrento, Italy 10-12 March
view all events
Latest Blog Post

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

JMP blog post photo
view all blog articles

Learn more about JMP's premier analytics conference