cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.

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

  • Help with JMP formula (IFERROR)

    My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA"). E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0.2792984. How can I re-create that formula in JMP? I'm trying with no success. 

    UpliftElk866 UpliftElk866
    Discussions |
    Feb 13, 2024 12:19 PM
    463 views | 0 replies
  • Overlay a values of a parameter on the historical mean and 95% confidence intervals of that parameter

    i  have a values for six bioreactors for a parameter and cell days as the x-axis.  I would like to overlay those values on the historical mean and 95% confidence interval as a function of cell day as shown below in JMP 16.0. The historical  mean and 95% CIs values are shown in grey and the colored values are the current values  

    timothy_forsyth timothy_forsyth
    Discussions |
    Feb 13, 2024 8:42 AM
    707 views | 1 replies
  • Use JSL to select a tab in a window

    Hi all, I am using JSL to create a window with multiple tabs in it.  I'd like to have the user select from the combo box (that has the tab names in it) and based upon the selection make that tab come to the front, as if they had clicked on the tab.  The script I've shown below is just an example I made up to demonstrate my issue. I've tried using both "bring window to front" and "show window" but ...

    tbidwell tbidwell
    Discussions |
    Feb 13, 2024 6:57 AM
    1158 views | 1 replies
  • Counting number of values or words in each column

    i have a data set and i want to count the number of "OK" and put the calculate value at the bottom of the row for each column.

    For example:abacadOH;OC;OKOKOH;OC;OKOKOH;OC;OKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK699For(i=1,i<=NCol(dt),i++, Column(dt,i)[NRows(dt)] = Char(N Rows( dt<< get rows where( As Column(dt,i) == "OK"))); )
    I was using the code above but it seems to not let me put the value in f...

    jearls11 jearls11
    Discussions |
    Feb 13, 2024 5:34 AM
    1605 views | 3 replies
  • How to prevent Milliseconds from disappearing during Import Data from Database?

    Hello,  TLDR: Is there a way to keep milliseconds when data is imported from a database? Import JSON, timestamp milliseconds all turn into 0's. JMP 16.2/17.0 I currently have a JSL script that pulls json data from a database ex ->  Data Table(open database(dsn_string, sql_string, table_name, Invisible(1)));  This script has been working with no issues except that the granularity of the timestamp c...

    Glo_Roh Glo_Roh
    Discussions |
    Feb 13, 2024 4:26 AM
    1351 views | 3 replies

Latest Discussions

  • Help with JMP formula (IFERROR)

    My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA"). E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0.2792984. How can I re-create that formula in JMP? I'm trying with no success. 

    UpliftElk866 UpliftElk866
    Discussions |
    Feb 13, 2024 12:19 PM
    463 views | 0 replies
  • Overlay a values of a parameter on the historical mean and 95% confidence intervals of that parameter

    i  have a values for six bioreactors for a parameter and cell days as the x-axis.  I would like to overlay those values on the historical mean and 95% confidence interval as a function of cell day as shown below in JMP 16.0. The historical  mean and 95% CIs values are shown in grey and the colored values are the current values  

    timothy_forsyth timothy_forsyth
    Discussions |
    Feb 13, 2024 8:42 AM
    707 views | 1 replies
  • How to prevent Milliseconds from disappearing during Import Data from Database?

    Hello,  TLDR: Is there a way to keep milliseconds when data is imported from a database? Import JSON, timestamp milliseconds all turn into 0's. JMP 16.2/17.0 I currently have a JSL script that pulls json data from a database ex ->  Data Table(open database(dsn_string, sql_string, table_name, Invisible(1)));  This script has been working with no issues except that the granularity of the timestamp c...

    Glo_Roh Glo_Roh
    Discussions |
    Feb 13, 2024 4:26 AM
    1351 views | 3 replies
  • Predictor Screening

    I am trying to use the predictor screening platform and though I have walked through the example on JMP, but I still have questions. I put my response variable in a yes, no format like the example; however, when I look to see which variables are the best predictor of the response how do I interpret the results? Is the number #1 ranked variable the best for predictor for a "yes" outcome or a "no" o...

    barr26 barr26
    Discussions |
    Feb 12, 2024 4:36 PM
    1082 views | 1 replies
  • Scheduled job failed

    Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?

    shaiv90 shaiv90
    Discussions |
    Feb 11, 2024 11:09 PM
    508 views | 0 replies

Latest Discussions

  • Help with JMP formula (IFERROR)

    My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA"). E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0.2792984. How can I re-create that formula in JMP? I'm trying with no success. 

    UpliftElk866 UpliftElk866
    Discussions |
    Feb 13, 2024 12:19 PM
    463 views | 0 replies
  • Scheduled job failed

    Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?

    shaiv90 shaiv90
    Discussions |
    Feb 11, 2024 11:09 PM
    508 views | 0 replies
  • PickFile(), Projects and Network Drives

    Did you notice that PickFile looks different when it's opened from within a project? More than that - when Pick File is opened from a project, with mydir pointing to a network drive with thousands of files, Jmp will freeze for dozens of seconds:mydir= "\\computername\directory"; Pickfile("select a file" , mydir) So, if you work in a project, to prevent Jmp from freezing, please be sure that your i...

    hogi hogi
    Discussions |
    Feb 9, 2024 3:07 PM
    518 views | 0 replies
  • How might I include a line break (or a second line) in the print header of a PDF generated from a Journal window?

     w = New Window("window", <<Journal, hlb = hlistbox() ); w << Set Print Headers( "lineone \!n linetwo", "", "Page &pn; of &pc;" ); w << SavePDF ( "C:\Users\blahblah.pdf");The above script should include a line break in the "left header" so that it has two lines. Instead the resulting PDF just has a non-printing box character between the two words, like this ... and if i copy that text into this wi...

    mann mann
    Discussions |
    Jan 31, 2024 6:25 AM
    672 views | 0 replies
  • Optimal decision tree and Adam's consensus?

    Hello - First of all, I'm speaking very much as a non-statistician here. I have a paper I'm trying to replicate that is doing hierarchical clustering with multiple similarity functions and grouping methodologies, and then using an Adam's consensus to find a sort of "optimal" dendrogram, if you will. I looked at their software they were using, and its been out of comission for a good 15 years. JMP ...

    ehchandlerjr ehchandlerjr
    Discussions |
    Jan 26, 2024 11:06 AM
    534 views | 0 replies
view all discussions