User Community
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: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

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

view all learning resources

Latest Discussions

  • How to add Continuous Count row with IF statement

    Hi Expert, How can I add a new column (D) that able to add count row IF "CompareSeqVsAlarmDP" is 1 in sequence using JSL?I can reproduce this condition in Excel using IF statement : IF((C27=0),0,(C27+D26)).But still unsuccessful to convert the IF condition in JMP. I think something wrong with my IF statement. My JSL statement is as below:dt1:New Column << Set Formula(If(:"CompareSeqVsAlarmDP=z"n =...

    WebDesignesCrow WebDesignesCrow
    Discussions |
    Dec 7, 2023 5:27 PM
    2423 views | 2 replies

  • How to optimize factors with uncertainty in 1 step with JMP?

    Hello community!!,A question: will it be possible for the profiler to find the best combinations of factors with uncertainty when performing a simulation, which maximize the total utility and minimize the total cost, generating a table of the best combinations found? For example:  

    Marco2024 Marco2024
    Discussions |
    Dec 7, 2023 1:02 PM
    11162 views | 25 replies

  • JSL function with SQL Join pulling data rows 3 times compared to one without JOIN -why?

    The first function below with SQL INNER JOIN pulls each data rows (for LNo) two additional times from the database compared to the second function below without JOIN. Where am I going wrong? Names Default To Here( 1 ); opnDtb = Function( {R, M, T}, {dtm}, dtm = Open Database( "Driver=SQL Server; Server=ABCD-EFGH; DATABASE=myDB; Trusted_Connection=Yes;", "SELECT SM.[LNo], SM.[TestDate] A...

    Neo Neo
    Discussions |
    Dec 7, 2023 9:59 AM
    1181 views | 1 replies

  • New data added in excel - how to refresh in JMP

    My source data is in excel. I created a script to import the data with wizard into JMP and then further scripts do many things in JMP, ultimately creating graphs. And the scripts re-run just fine as long as I just look at the original data. But when I add new rows in the excel and run the scripts, the new data is not included there. I just see the same data that was in the excel when I created the...

    Markn Markn
    Discussions |
    Dec 7, 2023 5:30 AM
    11794 views | 24 replies

  • Application Builder and Graph Builder

    Hello - I'm on day 1 of application builder, so this might be completely obvious. However, I'm not seeing anything about it on google search. I'm trying to manipulate some graphs in a way that graph builder is currently incapable of. I can program the application to feed the data to a bivariate plot, and redo it over and over, no problem. However, I'm not quite sure how to talk back and forth with...

    ehchandlerjr ehchandlerjr
    Discussions |
    Dec 7, 2023 4:08 AM
    3161 views | 6 replies

Latest Discussions

  • How to optimize factors with uncertainty in 1 step with JMP?

    Hello community!!,A question: will it be possible for the profiler to find the best combinations of factors with uncertainty when performing a simulation, which maximize the total utility and minimize the total cost, generating a table of the best combinations found? For example:  

    Marco2024 Marco2024
    Discussions |
    Dec 7, 2023 1:02 PM
    11162 views | 25 replies

  • New data added in excel - how to refresh in JMP

    My source data is in excel. I created a script to import the data with wizard into JMP and then further scripts do many things in JMP, ultimately creating graphs. And the scripts re-run just fine as long as I just look at the original data. But when I add new rows in the excel and run the scripts, the new data is not included there. I just see the same data that was in the excel when I created the...

    Markn Markn
    Discussions |
    Dec 7, 2023 5:30 AM
    11794 views | 24 replies

  • Application Builder and Graph Builder

    Hello - I'm on day 1 of application builder, so this might be completely obvious. However, I'm not seeing anything about it on google search. I'm trying to manipulate some graphs in a way that graph builder is currently incapable of. I can program the application to feed the data to a bivariate plot, and redo it over and over, no problem. However, I'm not quite sure how to talk back and forth with...

    ehchandlerjr ehchandlerjr
    Discussions |
    Dec 7, 2023 4:08 AM
    3161 views | 6 replies

  • Finding the mean, sigma, or median for a column certain conditions

    Hi all, I'm trying to find the mean, median and sigma for a column with certain conditions. For example, I need to get the mean for a test at certain frequency and a certain bandwidth.  Something like this: Col Mean where ( :column1 < Limit & :BW == Y & :Freq == XXX );  your help is appreciated :)

    RA899 RA899
    Discussions |
    Dec 6, 2023 1:24 AM
    3354 views | 5 replies

  • Setting using JSL so that the control chart does not display batches for which there are missing data for a given parameter.

    As the topic. Normally in JSL we indicate batches (represented by a given column) for which we present points on the control chart as follows: Local Data Filter( Close Outline( 1 ), Add Filter( columns( :Batch ), Where( :Batch == {"01/10/2022", "01/11/2022", "01/12/2022", "01/13/2022"} ), Display( :Batch, N Items( 15 ), Find( Set Text( "" ) ) ) ) ), However, how can we reque...

    Giardini Giardini
    Discussions |
    Dec 5, 2023 8:25 AM
    4122 views | 7 replies

Latest Discussions

  • Keyboard shortcuts

    [More Topic Containers like this] Jmp Help/Keyboard Shortcuts   assign new Keyboard ShortcutsAssigning-keyboard-shortcuts-for-frequently-used-options comment/uncomment blocks of code (international keyboard)A shortcut can be set in the menu customization Editoradd  keyboard shortcuts for your own functionsadd them to the main menu/ to a toolbar and assign a shortcutadd keyboard shortcuts for "open...

    hogi hogi
    Discussions |
    Nov 26, 2023 1:38 AM
    1137 views | 0 replies

  • Could JMP optimize factors with uncertainty?

    Hello community!!,A question: will it be possible for the profiler to find the best combinations of factors with uncertainty when performing a simulation, which maximize the total utility and minimize the total cost, generating a table of the best combinations found? For example: 

    Marco1 Marco1
    Discussions |
    Nov 21, 2023 9:08 AM
    927 views | 0 replies

  • Caution: Places where Jmp does something unexpected

    Definitely, JMP is Not a Spreadsheet . And that's great!! Besides this difference, there are other places where Jmp doesn't do/behave/produce what a newbie / innocent Jmp user expects.
    If a user knows these issues and the remedies and workarounds -  he/she can
    a) save a lot of time b) be safe from data loss c) be sure that the results are as expected.

    [More Topic Containers like this]   Topicdescrip...

    hogi hogi
    Discussions |
    Nov 17, 2023 4:15 AM
    1412 views | 0 replies

  • Is it possible to change the color of the median line in a box plot (with graph builder) via JSL?

    Is it possible to change the color of only the median (horizontal) line in a box plot (with graph builder) via JSL? If yes, could I get an example please (I am on JMP 16.2)?

    Neo Neo
    Discussions |
    Nov 15, 2023 7:25 AM
    985 views | 0 replies

  • JSL script to open a SharePoint .xlsx worksheet.

    Hi!I am getting the below error when I tried to implement this method of opening an excel worksheet from SharePoint. Is there another method ?(Solved: How to extract data from an Excel file on Sharepoint? - JMP User Community) 

    MIchaels MIchaels
    Discussions |
    Nov 15, 2023 12:58 AM
    1018 views | 0 replies
view all discussions

JMP Events

Sorrento, Italy 10-12 March
view all events
Latest Blog Post

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration

JMP blog post photo
view all blog articles

Learn more about JMP's premier analytics conference