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

  • JMP HOME WINDOWS

    Hello guys,I had a strange issue the last week. When I click on any JMP file, the file opens with a new Home Window of JMP.
    The problem is, when I would like to analyze between 2 opened files, I cannot do it because it looks like I've opened them in separate JMP apps, and there isn't any connection between them.so I found a solution to open the first file regularly by double clicking and following ...

    Dennisbur Dennisbur
    Discussions |
    Feb 23, 2024 12:42 AM
    1689 views | 1 replies
  • How do you get the confidence intervals output for performance measures in the add ins imbalanced misclassification?

    I am wondering if you can let me know how can I get the performance measure Confidence Intervals (lower and the upper limit) and the alpha when I do the add ins imbalanced classification analysis to evaluate models (I picked all the models [except for generalized regression] and sampling techniques). I am able to get the PR Curve AUC, ROC Curve AUC, but I am not able to locate how to get the confi...

    NishaKumar NishaKumar
    Discussions |
    Feb 22, 2024 8:44 AM
    672 views | 0 replies
  • How to properly use LAG function in Conditional Statements?

    I have this formula but it is adding the value on the same row. If( :Column 2 != Lag( :Column 2 ) | Row() == 1, :Column 1, Row() == 2 | Lag( :Column 2, 1 ) != :Column 2, :Column 2 - (:Column 1 + Lag( :Column 1, 1 )), Lag( :Result ) - :Column 1 )    What I would want to do is something like this:Column 1 and Column 2 are given values. If Column 2 value changes, the result should be like the star...

    UserID16644 UserID16644
    Discussions |
    Feb 22, 2024 5:36 AM
    2536 views | 6 replies
  • How to subtract values from previous row values?

    Hi all Can someone help me how to formulate a formula that would subtract Column 2 to the previous value in Column 1? It should look like this. The column Equation only shows how the subtraction of values should be.TIA  

    UserID16644 UserID16644
    Discussions |
    Feb 22, 2024 4:15 AM
    3897 views | 7 replies
  • Date Difference calculation referencing grouping columns

    I am trying to calculate a Date Difference in Days between the current row and the last row where a comment is non-missing. Any help greatly appreciated! If( (:ID == Lag( :ID ) | Row() == 1) & !Is Missing( :Comments ), 0, Date Difference( :Sampled Date, Lag(:Sampled Date, n=last row where !Is Missing(:Comments)), "Day" ) )  

    ktbrickey ktbrickey
    Discussions |
    Feb 22, 2024 2:56 AM
    4064 views | 7 replies

Latest Discussions

  • How do you get the confidence intervals output for performance measures in the add ins imbalanced misclassification?

    I am wondering if you can let me know how can I get the performance measure Confidence Intervals (lower and the upper limit) and the alpha when I do the add ins imbalanced classification analysis to evaluate models (I picked all the models [except for generalized regression] and sampling techniques). I am able to get the PR Curve AUC, ROC Curve AUC, but I am not able to locate how to get the confi...

    NishaKumar NishaKumar
    Discussions |
    Feb 22, 2024 8:44 AM
    672 views | 0 replies
  • How to pass parameters to the specified JSL in the graph fetch?

    Examples in the index of softwaredt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); gb = dt << Graph Builder( Show Control Panel( 0 ), Variables( X( :age ), Y( :weight ) ), Elements( Bar( X, Y, Legend( 7 ) ) )); frame = (gb << report)[FrameBox( 1 )]; frame << Set Graphlet( Picture( loader = Include( "$BUILTIN_SCRIPTS/hllib.jsl" ); hlp = loader:lazyLoad( "hllPresets" ); hlp:launchPie(); ), Titl...

    lala lala
    Discussions |
    Feb 22, 2024 12:55 AM
    3604 views | 11 replies
  • group file name and set lable by JSL looping, work fine but slowly

    I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...

    BayesRabbit7133 BayesRabbit7133
    Discussions |
    Feb 22, 2024 12:24 AM
    733 views | 0 replies
  • Working on multiple data files and creating a summary table that contains the mean, std, etc.

    Hi,  Lets say we have multiple big class data files, with different height, weight column, etc and I want to create a summary table that contains the mean, standard deviation,  cpk, Spec limits, etc.  I want to have a summary data table that lists the mean for example, for the first big class file, do the same thing for the next big class file. Is there are a method that I can use to perform such ...

    RA899 RA899
    Discussions |
    Feb 21, 2024 10:07 AM
    1388 views | 3 replies
  • Excel cell format

    Hello 

    I'm encountering an issue with inconsistent cell formatting across multiple Excel files. I've written a script that imports all Excel files within a specific folder and then creates a new table with selected data from these files. However, I'm running into a problem because some of the Excel files have cells formatted as 'General', while others are formatted as 'Number'. This discrepancy in ...

    SeasonalControl SeasonalControl
    Discussions |
    Feb 21, 2024 7:34 AM
    1244 views | 2 replies

Latest Discussions

  • How do you get the confidence intervals output for performance measures in the add ins imbalanced misclassification?

    I am wondering if you can let me know how can I get the performance measure Confidence Intervals (lower and the upper limit) and the alpha when I do the add ins imbalanced classification analysis to evaluate models (I picked all the models [except for generalized regression] and sampling techniques). I am able to get the PR Curve AUC, ROC Curve AUC, but I am not able to locate how to get the confi...

    NishaKumar NishaKumar
    Discussions |
    Feb 22, 2024 8:44 AM
    672 views | 0 replies
  • group file name and set lable by JSL looping, work fine but slowly

    I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...

    BayesRabbit7133 BayesRabbit7133
    Discussions |
    Feb 22, 2024 12:24 AM
    733 views | 0 replies
  • JMP 16 Discreet Fit to Gamma Poisson to Kulmogrov

    Hello All, Need assistance trying to get the goodness-of-fit test for the following parameters in JMP 16: 1. Discrete Fit2. Fit Negative Binomial (equivalent to Gamma Poisson as no option to choose gamma poisson)3. Goodness-of-fit4. output -> Pearson Chi-square -> no values  From past version of JMP 14, there was a gamma poisson option with a goodness-of-fit option that outputted kolmogorov's D va...

    RichC RichC
    Discussions |
    Feb 19, 2024 10:19 AM
    565 views | 0 replies
  • Visualizing 2-way clustering

    Hello - I have a table of 180 factors. I have used the 2-way clustering to visualize the grouping in the dendrogram, which works really well for a few factors. Close to 200? Not so much, especially in a paper. In my mind, I have basically the K-means type plot of all of the factors clumped and colored. But this doesn't make sense for factors. Is there a way that to plot the clustering on a 2-D plo...

    ehchandlerjr ehchandlerjr
    Discussions |
    Feb 15, 2024 2:53 PM
    581 views | 0 replies
  • 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
    679 views | 0 replies
view all discussions