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

  • Comparing two rows with the same time stamp and picking the higher value from a different column

    Hi, I have a dataset where by I have a single column with minute by minute data (time stamped) and in many cases the same minute is duplicated. For those instances, there is another column with different values. How do I find duplicated timestamp rows and pick the max. value between them e.g.Initial TableTime      Flow12:00     34512:01     123 12:01      45612:02      22312:02      11212:03      ...

    nv11 nv11
    Discussions |
    Mar 7, 2024 1:08 PM
    1375 views | 3 replies
  • How to overlay data points from one group onto the box plots of a second group in graph builder?

    I have data from two studies (#1 and #2), each study had four ages of subjects (A, B, C, D) and one continuous result (score). Study #2 also has treatment groups (x, y, z, etc). I am trying to make a graph to compare the two studies. Ideally, the graph includes box plots of age (x-axis) and Score (Y-axis) ONLY FROM STUDY #1. And then overlay the scores from study #2 as individual data points onto ...

    Mcc99 Mcc99
    Discussions |
    Mar 7, 2024 12:41 PM
    2751 views | 2 replies
  • How to skip item on JSL list in SQL query if it does not exist?

    Hi all,I have a script that queries from JSL list. However, it gets an error whenever something is not existing on the database. Is there a way that I can skip what is not existing and proceed to the next value in the list? I have this example: NameList = {"John","Jane","Anna","Dominic"}; NameItems = ConcatItems(NameList ,","); Eval (Parse (Evalinsert("\[ db= Open Database("Server Specs", "SELE...

    UserID16644 UserID16644
    Discussions |
    Mar 7, 2024 11:40 AM
    1452 views | 2 replies
  • Name Unresolved for column name when using Match function

    Hi, I have a script that pulls a query then I attempt to recode some of the query information. whenever I run the "match" function in a separate script it works but when I combine it into my full script I get the error: "Name Unresolved: SamplePoint at row 1 in access or evaluation of 'SamplePoint' , SamplePoint/*###*/"   SamplePoint is the column I'm trying to recode   Here is the full code:  //!...

    Bluebird73 Bluebird73
    Discussions |
    Mar 7, 2024 11:20 AM
    1334 views | 1 replies
  • [JSL] Get "Best Fit" Capability statistics from a data table and populate a new table

    Hello, I have to manage big data files on a daily basis (10k columns x 20k rows).My goal is to get capability statistics from all columns with limits, by using the best fit method (only a few columns are normally distributed).I have made a quick and dirty script that:- loop through columns with limits,- plot distribution > "fits all" > capability,- picks the info in the report window and- close th...

    Voizingu Voizingu
    Discussions |
    Mar 7, 2024 10:55 AM
    2254 views | 2 replies

Latest Discussions

  • Linear constraints in mixture design

    I am facing difficulties in implementing the constraints for my mixture design. The design consists of water as a filler and four additives, namely A1, A2, A3, and A4, which have specified value ranges. I need to impose a combination constraint that allows a maximum of two out of the three factors, A2, A3, and A4, to be used simultaneously. A1 and water are not important in constraining, but it is...

    Principles77 Principles77
    Discussions |
    Mar 7, 2024 10:55 AM
    1100 views | 1 replies
  • Python: get error message?

    Python integration in jmp is very useful.For debugging - when I executing a command in Python  viaPython Submit()and get a return value -1, indicating that something went wrong. Is there a possibility to get the error message? e.g. an automatically updated Python variable, which I could get back to JSL via Python Get(PythonErrorMessage) #myTop10_2022
    -> JMP 18 : )

    hogi hogi
    Discussions |
    Mar 7, 2024 10:01 AM
    3167 views | 6 replies
  • How to use the tabulate function with raw data instead of summary statistics?

    Dear community, How can I use the tabulate function with the actual data of a continuous variable and not a summary statistic?Or in other words: is there a way to create a table with a column and row headers in multiple levels but using the raw data? Thanks, T

    ContinuousPath3 ContinuousPath3
    Discussions |
    Mar 7, 2024 8:07 AM
    1907 views | 2 replies
  • Importation of an Excel file encrypted with a password in JMP

    Hello all,I would like an Excel file encrypted with a password in JMP.However, when I import the file, JMP ask me 3 times the password.Is there a way to import an encrypted Excel file by asking the password only once?Thanks a lot for your answer,Sébastien

    Sebastienlg Sebastienlg
    Discussions |
    Mar 7, 2024 7:58 AM
    998 views | 1 replies
  • Group homogeneity tests - difference when using right censor and interval censored data

    Hi, can you explain how JMP handles Group homogeneity tests (Logrank, Wilcoxon, Peto-Peto) with different type of event censoring? Are there any differences in methods used by JMP to calculate those tests under different event censoring? I made a 2 populations comparisons in JMP platform Life Distribution - Compare Groups, using same dataset, but with different event censoring definition. For unce...

    Ceg1 Ceg1
    Discussions |
    Mar 7, 2024 6:33 AM
    1025 views | 1 replies

Latest Discussions

  • DataTable Prompt in application builder on module load

    Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable only when that module loads.By default it prompts when the application loads  Kindly guide. Thanks in advance

    ComplexNerd ComplexNerd
    Discussions |
    Mar 7, 2024 3:54 AM
    552 views | 0 replies
  • JMP Project Global Data Filter and Column Switcher

    Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project.Currely i have created a jmp project with various reports from a datatable (similar to dashboard) but i want to know if there is a option to add a global data filter and also a global column switcher to this screen. My idea : To create a sc...

    ComplexNerd ComplexNerd
    Discussions |
    Mar 7, 2024 12:10 AM
    519 views | 0 replies
  • Do 3rd order effects help define curvature?

    If you have are making a design with a factor you are certain will have a quadratic relationship against a response but you have a wide range, can it be helpful to define a 3rd order model effect for that factor to better identify and model curvature. I work in purification and we often deal with a recovery vs. purity balance. This relationship is usually quadratic around the optimal, where at a l...

    MetaLizard62080 MetaLizard62080
    Discussions |
    Mar 4, 2024 8:21 PM
    887 views | 0 replies
  • "If" returns error response

    I have a script to draw charts and use "if" for the reference line."Sometimes" the reference line is not correct. For example, when Rel_Test=H3TRB, the reference line should be 10, but it shows 5.How could I fix it? 
    d6_graph=dt2 << Graph Builder( Size( 400, 300 ), Show Control Panel( 0 ), Variables( X( :Lot), Y( :dIGSS, Position( 1 ) ), Color( :Lot ), By(:Rel_Test) ), Elements( Box Pl
    ...

    LT LT
    Discussions |
    Mar 4, 2024 8:08 PM
    670 views | 0 replies
  • Neural networks that learn and predict in real time (incremental learning)

    Hello community!!A query:- How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights according to new inputs and generates updated real-time predictions.Greetings,Marco

    Marco2024 Marco2024
    Discussions |
    Mar 4, 2024 9:37 AM
    714 views | 0 replies
view all discussions