cancel
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

Latest Discussions

  • Unused levels appearing in Odds Ratio output after recoding a categorical variable in JMP

    After recoding a categorical variable (either with 'recode' or If) in JMP 18 pro, the old category “Either” still appears in the results — especially in the Odds Ratio output of a logistic regression — even though no rows in the new column contain that value anymore. It seems JMP continues to recognize “Either” as an existing level of the variable, and there is no visible option to actually delete...

    RMSEElephant848 RMSEElephant848
    Discussions |
    Nov 12, 2025 12:01 AM
    272 views | 2 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 shampton82
    Discussions |
    Nov 10, 2025 1:23 PM
    263 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 FN
    Discussions |
    Nov 10, 2025 9:45 AM
    1354 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
    1210 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
    6336 views | 24 replies

Latest Discussions

  • Unused levels appearing in Odds Ratio output after recoding a categorical variable in JMP

    After recoding a categorical variable (either with 'recode' or If) in JMP 18 pro, the old category “Either” still appears in the results — especially in the Odds Ratio output of a logistic regression — even though no rows in the new column contain that value anymore. It seems JMP continues to recognize “Either” as an existing level of the variable, and there is no visible option to actually delete...

    RMSEElephant848 RMSEElephant848
    Discussions |
    Nov 12, 2025 12:01 AM
    272 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 FN
    Discussions |
    Nov 10, 2025 9:45 AM
    1354 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
    1210 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
    6336 views | 24 replies
  • how to generate this graph in Graph Builder?

    How to generate a plot in Graph Builder with: color & fit  = Latitude binmarker = Station like this one:   The plot doesn't look fancy, but most JMP uses will get stuck when they try to adjust the markers.
    STATION is used as Color - and "therefore" the user is only allowed to change the color:

    Sure, everybody knows a JMP expert - and they will help with a  workaround [what is your favorite one?].

    ...

    hogi hogi
    Discussions |
    Oct 31, 2025 9:55 AM
    593 views | 5 replies

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 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 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 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 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 hogi
    Discussions |
    Dec 4, 2024 5:01 AM
    443 views | 0 replies
view all discussions