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 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
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: 

Learning Resources

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

view all learning resources

Latest Discussions

  • data cleanup, merge data from 3 columns into one column

    HI Newbie here, I need some help to merge the data from 3 columns into one column, the data were collected in different time and by different person, and in 3 columns, so there are some missing data, some matched, like this: A  B  C  1  1  0      01      1 How do I merge the data in A, B, C columns into one column in JMP?Thank you so much for helping!

    TonyS TonyS
    Discussions |
    Oct 8, 2021 9:32 AM
    2748 views | 6 replies

  • How to Assign Date Values based on a Current Month Key

    I have data from a data base that assigns a column for the Current Month number when the data gets pulled, and then creates separate columns for previous months counting back. So for a 24 month data pull from September, there will be a column "Current Month" that has the value "9" for all rows, then it will have 24 columns with subscript header "_01", "_02", ..."_24", which denotes "Aug 2021", "Ju...

    Mo Mo
    Discussions |
    Oct 8, 2021 6:19 AM
    1643 views | 2 replies

  • need to close an open plot window

    Hi - I am using JMP 12.1 and trying to use script to close an open plot window after it displays for about 5 seconds.  I am using the following script but it is not working.  (I am new to scripting and unfortunately am not finding the answers I need in the JSL index - probably user error(!) - but so far it has not been very intuitive or simply has not had the information I'm looking for.)  ....fit...

    learning_JSL learning_JSL
    Discussions |
    Oct 8, 2021 6:13 AM
    1541 views | 2 replies

  • Import Excel with Macro formula

    I have an issue here: When importing an Excel file which contains Macro based formulas, these cells only yield missing values instead of their actual values. How can I import this data correctly? Note: I assume that the values are stored in the Excel file, similar to the values of normal formula cells, because when I open the file in Excel with deactivated macros, the values are well present. Here...

    JWi JWi
    Discussions |
    Oct 8, 2021 4:53 AM
    7004 views | 9 replies

  • How to make a subset file based on certain rows.

    Hello guys, I am working on an experiment, where I had to measure people's baselines and responses and I am sorting the data out. What I need to do is to make a subset file based on all the rows where the name "baseline" is in. Kind regards,  

    Ben1 Ben1
    Discussions |
    Oct 8, 2021 3:39 AM
    1508 views | 1 replies

Latest Discussions

  • Import Excel with Macro formula

    I have an issue here: When importing an Excel file which contains Macro based formulas, these cells only yield missing values instead of their actual values. How can I import this data correctly? Note: I assume that the values are stored in the Excel file, similar to the values of normal formula cells, because when I open the file in Excel with deactivated macros, the values are well present. Here...

    JWi JWi
    Discussions |
    Oct 8, 2021 4:53 AM
    7004 views | 9 replies

  • Column filter for graph builder (Parallel plot)

    The local data filter allows the user to select the rows of interest. I wonder how I can allow the same functionality but for columns without having to edit the graph. For example, allowing the user to select what to visualize between weight, size, age, sex...  Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); Graph Builder( Size( 490, 448 ), Show Control Panel( 0 ), Varia...

    FN FN
    Discussions |
    Oct 8, 2021 1:15 AM
    901 views | 1 replies

  • JSL: Saving multiple chart and auto fit each of them into 1 page

    I have created a Window with V List Box which contained multiple Variability Charts and tried to save them into 1 pdf. What i want to achieve is saving and auto scale each of the Variability Charts into 1 single page of pdf. Can anyone help to advise how to do that? Much appreciated!nw = New Window( "taskQueryCharzCurrent - Variability Chart of current", V List Box( Variability Chart( Y( :cu...

    giin giin
    Discussions |
    Oct 7, 2021 6:42 AM
    822 views | 0 replies

  • "^" next to P-value

    Hello,After running a custom design, the symbol " ^ " appears next to the P-value of some 2nd order variables.What does it mean? Does it mean that the variable alone has less influence on the answer than the 2nd order factor ?Thanks

    Fredix Fredix
    Discussions |
    Oct 7, 2021 2:27 AM
    982 views | 1 replies

  • Sheet result of fit parametric survival: how to know if a parameter is protective or deleterious?

    Dear CommunityI have performed a fit parametric survival analysis in a cohort of patients.I’m able to identify in the sheet results that several characteristics are statistically associated with the survival.However, I’m not able to identify whether these characteristics are protective or deleterious.May you please indicate me how to find this information in the sheet result?Thank you very muchWit...

    Titanescu Titanescu
    Discussions |
    Oct 6, 2021 11:51 PM
    1295 views | 2 replies

Latest Discussions

  • JSL: Saving multiple chart and auto fit each of them into 1 page

    I have created a Window with V List Box which contained multiple Variability Charts and tried to save them into 1 pdf. What i want to achieve is saving and auto scale each of the Variability Charts into 1 single page of pdf. Can anyone help to advise how to do that? Much appreciated!nw = New Window( "taskQueryCharzCurrent - Variability Chart of current", V List Box( Variability Chart( Y( :cu...

    giin giin
    Discussions |
    Oct 7, 2021 6:42 AM
    822 views | 0 replies

  • Skip Lot Sampling Plan

    Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam

    AT AT
    Discussions |
    Sep 10, 2021 10:38 AM
    973 views | 0 replies

  • Time values in xls or xlsx, csv, and JMP

    Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...

    fliew0410 fliew0410
    Discussions |
    Sep 7, 2021 7:25 AM
    961 views | 0 replies

  • Error while using Azure MFA to connect with JMP

    I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14.  [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Password option must not be specified, if Authentication option is 'ActiveDirectoryInteractive'.

    hariharan249 hariharan249
    Discussions |
    Sep 3, 2021 7:14 AM
    687 views | 0 replies

  • Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

    Hi everyone,  I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along.  I f...

    caseylott caseylott
    Discussions |
    Aug 17, 2021 11:15 AM
    1237 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

More on the many advantages of structural equation models

 view all blog articles

Learn more about JMP's premier analytics conference