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

  • if "compare" column value is greater than 100%, then change the value to 100%, if less than or equal to 100%, then keep the value no change

      Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); New Column( "Compare", Numeric, "Continuous", Format( "Percent", 12, 0 ), Formula( :weight / :height ) ); //change the value on position of :weight[2] to 59. But seems not work. could you help edit the script on this place? dt:weight[2] << Set Values( 58 ); // I hope realize if the column "compare" result >100%, then ou...

    Theresa Theresa
    Discussions |
    Jun 10, 2020 12:32 AM
    2964 views | 2 replies

  • Getting mode statistics in tabulate

    Hi JMP user community,I have periodic inprocess record for batches manufactured, monitoring frequency is every 15 mins.I have to calculate batch specific mode for the respective in-process entry.I can't see the option of mode statistics in Analyze > tabulate. I am using JMP 14.3.0.Is there way to get Mode as statistics using tabulate.Thanks!  

    nil nil
    Discussions |
    Jun 9, 2020 11:09 PM
    3118 views | 2 replies

  • Parse a concatenated string which has comma

    Hi all, I have a datatable with multiple columns, some of which I want to add together. As a part of my script, I am selecting some of the columns, storing the column names in a list and then hoping to add the selected columns using the "Sum" feature.   In order to do that I need to build a string ":DATA1, :DATA2, :DATA3" and Parse it in a column.  New Column( "Addition", Numeric, Continuous, Form...

    noviJSL noviJSL
    Discussions |
    Jun 9, 2020 12:11 PM
    2760 views | 2 replies

  • How to find row and column (cell) that matches a value

    I have tables that are generated and the format is different from time to time and it breaks my script.  The tables are massive and so the way i handle my loops is that i import the first 100 rows and 5 columns, for speed.  Then i search a particular column for a keyword to help me know where which row the real data starts.  I close the file then reopen with that variable identifying the column he...

    SamKing SamKing
    Discussions |
    Jun 9, 2020 7:11 AM
    4393 views | 2 replies

  • Impact of screen resolution on html output

    Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...

    Ole Ole
    Discussions |
    Jun 9, 2020 6:21 AM
    1313 views | 0 replies

Latest Discussions

  • if "compare" column value is greater than 100%, then change the value to 100%, if less than or equal to 100%, then keep the value no change

      Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); New Column( "Compare", Numeric, "Continuous", Format( "Percent", 12, 0 ), Formula( :weight / :height ) ); //change the value on position of :weight[2] to 59. But seems not work. could you help edit the script on this place? dt:weight[2] << Set Values( 58 ); // I hope realize if the column "compare" result >100%, then ou...

    Theresa Theresa
    Discussions |
    Jun 10, 2020 12:32 AM
    2964 views | 2 replies

  • Getting mode statistics in tabulate

    Hi JMP user community,I have periodic inprocess record for batches manufactured, monitoring frequency is every 15 mins.I have to calculate batch specific mode for the respective in-process entry.I can't see the option of mode statistics in Analyze > tabulate. I am using JMP 14.3.0.Is there way to get Mode as statistics using tabulate.Thanks!  

    nil nil
    Discussions |
    Jun 9, 2020 11:09 PM
    3118 views | 2 replies

  • How to find row and column (cell) that matches a value

    I have tables that are generated and the format is different from time to time and it breaks my script.  The tables are massive and so the way i handle my loops is that i import the first 100 rows and 5 columns, for speed.  Then i search a particular column for a keyword to help me know where which row the real data starts.  I close the file then reopen with that variable identifying the column he...

    SamKing SamKing
    Discussions |
    Jun 9, 2020 7:11 AM
    4393 views | 2 replies

  • Impact of screen resolution on html output

    Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...

    Ole Ole
    Discussions |
    Jun 9, 2020 6:21 AM
    1313 views | 0 replies

  • Load data to a google sheet using JMP

    Hello everybody, I was wondering if it was possible to load data to a google sheet using JMP. I'm running a script, it generates some numbers, and I would like those numbers to end up in a google sheet. Any ideas on how to do this? Cheers, Eduardo

    Eduardo Eduardo
    Discussions |
    Jun 9, 2020 2:02 AM
    3937 views | 2 replies

Latest Discussions

  • Impact of screen resolution on html output

    Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...

    Ole Ole
    Discussions |
    Jun 9, 2020 6:21 AM
    1313 views | 0 replies

  • How do I have two different chart types in a single graph using two axis?

    While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot?    Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot.     To do this, first clear the row s...

    Bass_Masri Bass_Masri
    Discussions |
    Apr 28, 2020 4:28 PM
    4662 views | 0 replies

  • How do I calculate z-scores at different aggregation levels?

    Hello,  How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...

    Jmsouch Jmsouch
    Discussions |
    Feb 26, 2020 7:04 AM
    2216 views | 0 replies

  • Calling Windows API ImageViewer.dll to display JPG files.

    I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL.   ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...

    DMeakin1 DMeakin1
    Discussions |
    Jan 17, 2020 10:19 AM
    2020 views | 0 replies

  • Running script from command line on MAC

    Not a mac person.  Does anyone know how to run a jsl script from command line on a mac?  I specifically mean WITHOUT "//!" at the top of it.     I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl

    vince_faller vince_faller
    Discussions |
    Jan 10, 2020 2:26 PM
    1668 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