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

  • How to get column sum according to same column values?

    Hi all How to calculate the Total Qty if they have the same code? I am currently using Col Sum(:Qty) but it is getting the sum of all column values. I just want the sum of values with the same code & date  DateCodeQtyTotal Qty10-23-23004910-23-23005910-23-23016610-24-23033310-24-23044410-25-23056810-25-230528 

    UserID16644 UserID16644
    Discussions |
    Apr 3, 2024 1:46 AM
    1393 views | 2 replies

  • Standardizing attributes by column name

    I tend to work with the same types of data every day.  Every time I load a file, JMP sets some columns as "Continuous" that really work better as nominals. Is there a way to tell JMP that if it sees a column with a specific name, e.g. "case_id", that it should always flag it as nominal? I know scripts can do this, but having to run a script every time I open a file has gotten a bit tedious.

    BHarris BHarris
    Discussions |
    Apr 2, 2024 7:10 PM
    6325 views | 3 replies

  • Update name column

    HelloI have 2 tables1) Pareto_table with name columns 1 and 2 2) the second Date_table I have the same numbers 1 and 2 in column "Rank"my question is,  how I can update by the script JSL in Pareto_table the column 1 to value of 2024-01-05 and  and 2 to value 2024-03-13?in the end it will look like in this table exampleThank you

    Dennisbur Dennisbur
    Discussions |
    Apr 2, 2024 2:11 PM
    1209 views | 1 replies

  • How to get Col Sum of a row in a conditional statement?

    Hi all, I have a column where I need to filter out some values to get the sum of columns (using Col Sum). Is it possible to get the col sum according to the condition? For example, every 0 code will be excluded from the computation: CodeQtyTotal CountTotal % (Col Sum (qty)/total count)050250-025250-160250205/250 x 100 = 82%667250205/250 x 100 = 82%378250205/250 x 100 = 82% I tried using an If stat...

    UserID16644 UserID16644
    Discussions |
    Apr 2, 2024 1:40 PM
    2140 views | 3 replies

  • How can you calculate the product of non-empty rows up to the current row?

    I'm trying to write a column formula that will calculate the product of all of the (non-empty) rows up to the current row.I've attached an example data table (& screenshot). I am trying to get the "Product" column to be the product of all of the non-empty rows from the "Value" column. I show the manually calculated result and math in the "Desired Result" & "Desired Result Explanation" to the right...

    Kast Kast
    Discussions |
    Apr 2, 2024 11:10 AM
    1497 views | 2 replies

Latest Discussions

  • How to get column sum according to same column values?

    Hi all How to calculate the Total Qty if they have the same code? I am currently using Col Sum(:Qty) but it is getting the sum of all column values. I just want the sum of values with the same code & date  DateCodeQtyTotal Qty10-23-23004910-23-23005910-23-23016610-24-23033310-24-23044410-25-23056810-25-230528 

    UserID16644 UserID16644
    Discussions |
    Apr 3, 2024 1:46 AM
    1393 views | 2 replies

  • Standardizing attributes by column name

    I tend to work with the same types of data every day.  Every time I load a file, JMP sets some columns as "Continuous" that really work better as nominals. Is there a way to tell JMP that if it sees a column with a specific name, e.g. "case_id", that it should always flag it as nominal? I know scripts can do this, but having to run a script every time I open a file has gotten a bit tedious.

    BHarris BHarris
    Discussions |
    Apr 2, 2024 7:10 PM
    6325 views | 3 replies

  • Generating summary table with p-values from iterative t-test

    I am looking for a script that will automatically generate a summary/pivoted table of means and p-values for pairwise t-tests compared with one reference group. I am using JMP 17.In the below data table, there are columns for SubjectId, measured BMI, measured VO2max, year, and Reference to indicate whether or not the row has a SubjectID that is a reference.I have been generating summary tables man...

    LinkageBee996 LinkageBee996
    Discussions |
    Apr 2, 2024 9:33 AM
    5120 views | 8 replies

  • dt: image - missing?

    What is the correct way to check if an image in a data table is missing?... and why is there a difference between the column formula and the JSL questionis missing(:pet[5]) Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); dt[[4],"pet"]=.; New Column( "is missing",Formula( Is Missing( :pet ) )); New Column( "is empty", Formula( Is Empty( :pet ) )); New Column( "is nu...

    hogi hogi
    Discussions |
    Mar 31, 2024 8:45 AM
    1575 views | 3 replies

  • how to get Plot of several Plots time vs dimensions

    I would like to have a script for the dimension control by time, for this I need something like the sketch below. The Date Table is attached. In total there are 49 plots in one plot, 7 time points and 7 dimensions, some of the dimensions are measured in different points (a,b,c,d) then each points should have a certain color. Thank you everyoneJMP17 

    Mendes-Burak Mendes-Burak
    Discussions |
    Mar 29, 2024 9:07 AM
    1520 views | 3 replies

Latest Discussions

  • Error during stemming in text explorer: Inconsistent Recodes in access or evaluation of 'List'

    Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer( Text Columns( :col1) ); obj << Stemming("Stem for Combining"); obj << Add Recodes( {{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...

    sm3001 sm3001
    Discussions |
    Mar 21, 2024 12:49 AM
    931 views | 0 replies

  • DataTable Prompt in application builder on module load

    Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable only when that module loads.By default it prompts when the application loads  Kindly guide. Thanks in advance

    ComplexNerd ComplexNerd
    Discussions |
    Mar 7, 2024 3:54 AM
    662 views | 0 replies

  • JMP Project Global Data Filter and Column Switcher

    Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project.Currely i have created a jmp project with various reports from a datatable (similar to dashboard) but i want to know if there is a option to add a global data filter and also a global column switcher to this screen. My idea : To create a sc...

    ComplexNerd ComplexNerd
    Discussions |
    Mar 7, 2024 12:10 AM
    619 views | 0 replies

  • "If" returns error response

    I have a script to draw charts and use "if" for the reference line."Sometimes" the reference line is not correct. For example, when Rel_Test=H3TRB, the reference line should be 10, but it shows 5.How could I fix it? 
    d6_graph=dt2 << Graph Builder( Size( 400, 300 ), Show Control Panel( 0 ), Variables( X( :Lot), Y( :dIGSS, Position( 1 ) ), Color( :Lot ), By(:Rel_Test) ), Elements( Box Pl    ...

    LT LT
    Discussions |
    Mar 4, 2024 8:08 PM
    941 views | 0 replies

  • Neural networks that learn and predict in real time (incremental learning)

    Hello community!!A query:- How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights according to new inputs and generates updated real-time predictions.Greetings,Marco

    Marco2024 Marco2024
    Discussions |
    Mar 4, 2024 9:37 AM
    849 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