cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Find courses, tutorials, and lots of other methods of learning JMP.

view all learning resources

Latest Discussions

  • Rolling Maximum Sum Over a finite Period

    Hi, I have a dataset of about 500,000 rows, each date stamped by the minute. I am trying to find the maximum sum over a 15 minute, 1 hours and 4 hour period i.e. Row 1-15 sum = e.g. 5000 (5000 would be the sum of rows 1-15)Row 2-16Rows 3-17 sum = e.g. 8000 (8000 would be the sum of rows 3-17)... Rows 10-25 sum = e.g. 7900 (7900 would be the sum of rows 10-25) I would like the tabulation to return ...

    nv11 nv11
    Discussions |
    Mar 7, 2024 9:26 PM
    2116 views | 6 replies

  • How to query in SQL using list from JSL

    Hi all, How can I insert a list from JSL to my SQL query? Currently I am using this to get the list that I need: NameList = Associative array( dtNames:"Names" ) << Get Keys; And will use it as a SQL query dt = Open Database( "DSN=db;UID=uname;PWD=pw;APP=JMP;DATABASE=dbname;", "select name, age, address, sex from db_Details where name in ('"||NameList||"')", // Im getting an error here "Details" ...

    UserID16644 UserID16644
    Discussions |
    Mar 7, 2024 2:31 PM
    1168 views | 2 replies

  • 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

Latest Discussions

  • How to query in SQL using list from JSL

    Hi all, How can I insert a list from JSL to my SQL query? Currently I am using this to get the list that I need: NameList = Associative array( dtNames:"Names" ) << Get Keys; And will use it as a SQL query dt = Open Database( "DSN=db;UID=uname;PWD=pw;APP=JMP;DATABASE=dbname;", "select name, age, address, sex from db_Details where name in ('"||NameList||"')", // Im getting an error here "Details" ...

    UserID16644 UserID16644
    Discussions |
    Mar 7, 2024 2:31 PM
    1168 views | 2 replies

  • 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
    3173 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

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
    553 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

JMP Events

view all events
Latest Blog Post

Vroom! Vroom! Vroom! Join the JMP Summer Challenge: Motorsport edition

 view all blog articles

Learn more about JMP's premier analytics conference