cancel
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
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • need jsl formula to account for empty cell in conditional if statement

    Hi - I am new to jsl scripting and am trying to construct a jsl statement as follows: if column A is empty, column C = empty,else if column A < 500 and column B = 200, column C = 0,else if column A>500, column C = 1.How would I frame a jsl formula to do this?  Thanks! 

    learning_JSL learning_JSL
    Discussions |
    Oct 10, 2021 6:21 AM
    5869 views | 10 replies
  • Box size of Graph builder plot

    Is there a way I can specify box size for a graph builder plot? See highlighted image below. Box size does not include the axis label sizes. I want to make multiple plots with same box size. Frame size considers the size of the whole frame and not the box. 

    pankajsync pankajsync
    Discussions |
    Oct 10, 2021 2:39 AM
    4389 views | 5 replies
  • Open Files in Directory based on a List of Variable Filenames

    Hi all, I have a list of filename. This list of filename is variable and change from to time. I want to match these file name to the files available in a directory. If match , open the files. I write below code and run it. It does not work.Need guidance here.  folder = "C:\savefile\"; filename ={"Jan", "Feb", "Mar"}; filelist= Files In Directory(folder); For(i=1, i<= N items(filename), i++, ...

    bzanos bzanos
    Discussions |
    Oct 9, 2021 6:29 PM
    2535 views | 4 replies
  • Stepwise Show Formula Change

    Hello I am fairly new to JMP, I created a stepwise and saved my probability formula. It shows my formula answers for Lin(no), Prob(no), and Prob(yes), is there any way to get it to show me Lin(yes). I need it to actually show up on the data sheet aswell.

    mbauriem mbauriem
    Discussions |
    Oct 9, 2021 10:50 AM
    914 views | 1 replies
  • Screening designs - How do we know if the effects are not significant or if the whole data is not good (significant variation) without doing replicates?

    To show robustness of a chemical process, we often need to show regulators that selected parameters (temp, equivalents, time and reagent ratios) are not impacting the quality (purity) of final product.  In order to show this, regulators prefer performing screening designs.  Usually, we want to show that the parameters do not have detrimental effect within the ranges studied, so that the process is...

    jmpkat jmpkat
    Discussions |
    Oct 9, 2021 10:44 AM
    4826 views | 10 replies

Latest Discussions

  • Box size of Graph builder plot

    Is there a way I can specify box size for a graph builder plot? See highlighted image below. Box size does not include the axis label sizes. I want to make multiple plots with same box size. Frame size considers the size of the whole frame and not the box. 

    pankajsync pankajsync
    Discussions |
    Oct 10, 2021 2:39 AM
    4389 views | 5 replies
  • Stepwise Show Formula Change

    Hello I am fairly new to JMP, I created a stepwise and saved my probability formula. It shows my formula answers for Lin(no), Prob(no), and Prob(yes), is there any way to get it to show me Lin(yes). I need it to actually show up on the data sheet aswell.

    mbauriem mbauriem
    Discussions |
    Oct 9, 2021 10:50 AM
    914 views | 1 replies
  • Screening designs - How do we know if the effects are not significant or if the whole data is not good (significant variation) without doing replicates?

    To show robustness of a chemical process, we often need to show regulators that selected parameters (temp, equivalents, time and reagent ratios) are not impacting the quality (purity) of final product.  In order to show this, regulators prefer performing screening designs.  Usually, we want to show that the parameters do not have detrimental effect within the ranges studied, so that the process is...

    jmpkat jmpkat
    Discussions |
    Oct 9, 2021 10:44 AM
    4826 views | 10 replies
  • Combining models

    If I learned one thing from Discovery Summit Americas this year, it was how common it is to average and/or create ensemble models, something I had heard about but never considered (being a modeling novice). So I decided to do it. Making an ensemble model is easy; I saved the model as a prediction formula and simply included that as a predictor in the next round of model screening (using JMP Pro 16...

    abmayfield abmayfield
    Discussions |
    Oct 8, 2021 9:56 AM
    1991 views | 3 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
    7002 views | 9 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
    970 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
    959 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
    684 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
    1234 views | 0 replies
view all discussions