cancel
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

Latest Discussions

  • Lock a column in script while working with multiple tables with same column names

    I have three tables I am working with in my JSL. I am calling these dt1, dt2, dt3.  dt1 has the columns A, B, C, Ddt2 has the columns B, X, Y, Zdt3 has the columns D, Q, R, S I want to lock B in table dt2. How do I do that? The usual ":B << lock (1)" script is locking B in dt1. 

    AsymptoticCos AsymptoticCos
    Discussions |
    Jun 20, 2024 8:16 AM
    968 views | 1 replies
  • how to use jsl to calculate standard deviation by ID

    Hi, I have a table similar to this, and I wanted to select IDs where there are more than one entry and calculate standard deviation of the result grouped by ID. For example, in this case, I need to select ID 12345 and calculate standard deviation of the first 3 results.  I know I can do this by tabulate, but my actual table is very big, more than 1 million rows, tabulate by ID and calculate standa...

    emmablue emmablue
    Discussions |
    Jun 19, 2024 10:29 PM
    1948 views | 2 replies
  • UTM to decimal Degree conversion of Coordinates

    Hello, are there any JMP/JSL scripts around to transform UTM to decimal degree coordinates?Could only find the wishlist entry. Thank youhttps://community.jmp.com/t5/JMP-Wish-List/It-would-be-nice-to-add-UTM-coordinates-to-the-data-format/idi-p/668933  @martindemel 

    mlo1 mlo1
    Discussions |
    Jun 19, 2024 6:40 AM
    2298 views | 2 replies
  • How to combine rows with same value in one column?

    I have a data table that follows this format: dt = New Table( "Example", Add Rows( 5 ), New Column( "Time Stamp", Character, "Nominal", Set Values( {"1", "2", "3", "4", "5"} ) ), New Column( "Sample Name", Character, "Nominal", Set Values( {"Sample_1", "Sample_1", "Sample_2", "Sample_2", "Sample_2"} ) ), New Column( "Test1", Numeric, "Nominal", Set Values( {1, 0, 1, 0, 0} )...

    Agustin Agustin
    Discussions |
    Jun 19, 2024 5:56 AM
    1304 views | 2 replies
  • Maintain the correct zones

    On the control charts, I want to exclude the zones over the average when there is no lower limit. 
    Here is my script :  // Loop across the split data table and read the values for that column from the dt_limits_copy data table. Populate the Spec Limits and Control Limits For(i = 1, i <= N Cols(dtsplitcopy), i++, limrow = Try((pIDlimits_copy << get rows where(pIDlimits_copy:labelny == c...

    ConvergentWhale ConvergentWhale
    Discussions |
    Jun 19, 2024 3:57 AM
    1175 views | 2 replies

Latest Discussions

  • UTM to decimal Degree conversion of Coordinates

    Hello, are there any JMP/JSL scripts around to transform UTM to decimal degree coordinates?Could only find the wishlist entry. Thank youhttps://community.jmp.com/t5/JMP-Wish-List/It-would-be-nice-to-add-UTM-coordinates-to-the-data-format/idi-p/668933  @martindemel 

    mlo1 mlo1
    Discussions |
    Jun 19, 2024 6:40 AM
    2298 views | 2 replies
  • Maintain the correct zones

    On the control charts, I want to exclude the zones over the average when there is no lower limit. 
    Here is my script :  // Loop across the split data table and read the values for that column from the dt_limits_copy data table. Populate the Spec Limits and Control Limits For(i = 1, i <= N Cols(dtsplitcopy), i++, limrow = Try((pIDlimits_copy << get rows where(pIDlimits_copy:labelny == c...

    ConvergentWhale ConvergentWhale
    Discussions |
    Jun 19, 2024 3:57 AM
    1175 views | 2 replies
  • calendar week?

    year-week can be calculated in different ways.a)  via the right click context menu/new formula column : b) via Time Bins in Graph Builder [via DateIncrement(date, 0)] This plots shows both values in the same graph.
    On the top is: week by binning in Graph Builder, the bottom graph shows the week calculated via new formula column: Why is "week" not defined consistently at both places ?!?How can I mak...

    hogi hogi
    Discussions |
    Jun 18, 2024 4:54 PM
    1502 views | 3 replies
  • How to improve PNG picture resolution by jsl

    Hi,JMPerI'm using Mac version, and want to save some boxplot charts to PNG by jsl.How to improve the PNG picture resolution? I used below jsl and change resolution number, it sames not take effective.graph1 <<Save Picture("/Users/Downloads/TEST"||"/TEST-"||text||".png","png",resolution(600)); The resolution is not good as below.  

    CompleteLeopard CompleteLeopard
    Discussions |
    Jun 18, 2024 1:09 PM
    2232 views | 3 replies
  • Concatenation highlights of columns

    Hello there,I have a table with some columns, for example, "HIGH" and "SMART," and there are three optional values: "0," "1," and "None."I want to create a new column that describes each row.For example, if the first row has a "1" in the "HIGH" and "SMART" columns, the new column should contain "HIGH, SMART." How can I achieve this using column formulas?Thank you.

    Liranlev Liranlev
    Discussions |
    Jun 18, 2024 11:12 AM
    1180 views | 2 replies

Latest Discussions

  • How do I make scattorplot Matrix with multiple cloumns I select?

    Hi. I'm Jeon.I'm beginner of JMP. I want to have a script for making scattorplot Matrix with Items I select.Could you give me a help with it? I splited one data table to two data table. one has value of test items(*Data type : Numeric & Continuous) , another one has upper limit & lower limit.(*Charactor & Norminal) Column names(=test item names) are the same in 2 different data table. Two sample d...

    NagneTE1 NagneTE1
    Discussions |
    May 27, 2024 5:18 PM
    784 views | 0 replies
  • graph builder bug - x group shift

     (JMP 17, MacOS) I have a JSL scripts that creates multiple graph builder charts, but in some of them, and it's not repeatable always - some of the x groups  are getting different height, causing also the data plotted to be shifted. Another issue - is that I can't set the X group lables text to be 90 degrees rotated to fit long strings without making the chart too wide. This is supported for X var...

    ShlomiB76 ShlomiB76
    Discussions |
    Apr 14, 2024 12:08 AM
    718 views | 0 replies
  • Project ignoring H Splitter Box Set Sizes . . . sometimes

    I'm working with a JMP 17 Project and have a script to import a CSV file, embed a script into the Data Table, and execute the embedded script. The embedded script creates a graph from the data and sets the Project layout. All of these pieces, executed individually, work as intended. The problem I am having is that when I execute the combined script, the outer H Splitter Box ignores <<Set Sizes and...

    ionatx ionatx
    Discussions |
    Apr 4, 2024 1:25 PM
    709 views | 0 replies
  • Error during stemming in text explorer: Inconsistent Recodes in access or evaluation of 'List'

    Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer( Text Columns( :col1) ); obj << Stemming("Stem for Combining"); obj << Add Recodes( {{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...

    sm3001 sm3001
    Discussions |
    Mar 21, 2024 12:49 AM
    932 views | 0 replies
  • 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
    662 views | 0 replies
view all discussions