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

  • refer to levels of variables

    Dear Community How do I perform a count of the levels of a variable?In R i can type length(levels(x)). example: the species of bacteria are levels of the variable "species"  best,

    ezorlo ezorlo
    Discussions |
    Feb 14, 2024 4:39 AM
    4259 views | 7 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
    2026 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
    2483 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
    2299 views | 3 replies

  • How to loop when querying date?

    Hi allI am trying to query the database using JMP. In my query, I manually change the dateNow value from day 1 to 30 then run the script. But I needed to create another one that would loop all through the days. How can I create a loop that queries every date starting from July 2023 to January 2024? dateNow = "01/11/2024"; dt = Open Database( "DSN=databasename;UID=root;PWD=admin;APP=JMP;DATABASE=d...

    UserID16644 UserID16644
    Discussions |
    Feb 12, 2024 10:58 PM
    1586 views | 2 replies

Latest Discussions

  • 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
    2299 views | 3 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
    832 views | 0 replies

  • I'm Confused About Variables

    I'm having a conceptual problem figuring out how local variables work. I'll simplify the issue to focus in on what is confusing to me. I create a local variable, say t0, with a value of 5. Then I write a column formula to increment this value by 1... either t0=t0+1 or t0+=1 (it doesn't seem to matter), the result that I expected was that when JMP evaluated each cell in the column, it would increme...

    scott1588 scott1588
    Discussions |
    Feb 10, 2024 11:21 AM
    3519 views | 4 replies

  • remove string that contains number from text

    Hi,
     is that a way to remove any string that contain numbers using JSL? Example:
    I ate 4 apples and 2 bananas
    the model number is 0998GBELS03/45 is the ratio to check Targeted Output:I ate apples and bananas
    the model number is  is the ratio to check 

    dadawasozo dadawasozo
    Discussions |
    Feb 10, 2024 8:52 AM
    2129 views | 3 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
    886 views | 0 replies

Latest Discussions

  • 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
    832 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
    886 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
    1092 views | 0 replies

  • GraphBuilder Legend hook

    There are many useful instances of being able to have a hook onto the selection state change of a legend for a chart / graph.  With the non graph-builder method of generating charts' and graphs' legends (using Row Legend()), this was quite simple as the display element was simply a Table Box() that can receive a Set Row Change Function() message.  The same cannot be done (to my knowledge) with Gra...

    ErraticAttack ErraticAttack
    Discussions |
    Jan 17, 2024 6:41 PM
    747 views | 0 replies

  • Copy Columns - selected rows

    Copy Columns from the right-click context menu of a column header is very useful. Just copy the column(s)  - with all the settings ... and paste it into a JSL script - or another table. There is a hidden feature:
    When rows are selected, the values of the selected rows are used as arguments of the Set Values() command and will populate the cells of the new column. So, when you select all rows before...

    hogi hogi
    Discussions |
    Jan 3, 2024 1:27 PM
    1228 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