cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

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

  • 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
    4756 views | 10 replies
  • Value Ordering in JMP Script by a Variable

    Hello all,In my data set I will be using a column, called Set, as my x-axis variable in a barchart.  I want them to be sorted in the order from smallest response value to largest response value so I have bars that are increasing in length.  For example if I have the following data:Set      ResponseA          5B          -7C          10I would want the order in the barchart to be B, A, C.  Obviousl...

    mjbauer mjbauer
    Discussions |
    Oct 9, 2021 6:57 AM
    20160 views | 7 replies
  • Saving Variables to New Tables and New Columns

    I wrote a script that finds rows where col2 and col3 match specific strings and then returns the value of the cell in col7 of those rows.  However, I am having problems writing these variables to New Columns in New Tables. .... New Table( "Results",Add Rows( 2 ), New Column( " FUS",Character,"Nominal", Set Values({"Fus1","Fus2"})), New Column( "PASS/FAIL",continuous,"Nominal", formul...

    SMW SMW
    Discussions |
    Oct 8, 2021 4:21 PM
    2153 views | 5 replies
  • FPCA summaries via JSL

    I would like to save the FPCA summaries automatically using JSL. It seems I need to script the actions by clicking on the menu options. So far, I can create the model with the using this script FPCA // → Data Table( "Fermentation Process" ) Open( "$SAMPLE_DATA/Functional Data/Fermentation Process.jmp" ); Functional Data Explorer( Y( :Ethanol ), X( :Time ), ID( :BatchID ), Data Processing( Ali...

    FN FN
    Discussions |
    Oct 8, 2021 11:09 AM
    1664 views | 4 replies
  • JSL: How to auto click JMP Alert "OK" button in pop-up window?

    Hi All,   I have a JSL question as I'm stuck with some code that I'm working on right now.   Basically, what I'm doing is using the Special Purpose Space Filling DOE platform to generate a DOE that I need to feed to another JSL routine. The problem is not in getting the JSL to run, but with an automated JMP Alert popup window that appears each time.   Below is the basic code for generating the DOE...

    SDF1 SDF1
    Discussions |
    Oct 8, 2021 10:27 AM
    2018 views | 3 replies

Latest Discussions

  • 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
    4756 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
    1958 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
    6943 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
    882 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
    799 views | 0 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
    799 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
    943 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
    943 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
    655 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
    1214 views | 0 replies
view all discussions