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

  • JSL how to change the color of a single column in a Pareto plot?

    Hi All,   I'm interested in using JSL to change the color of a single bar (or perhaps multiple bars) in a Pareto Plot and not rely on the interactive row selection of a data table to do so.   I found these two helpful discussions here and here, but they're not quite what I'm after. I can of course make the graph using Graph Builder instead of the Pareto Plot platform, that's not the problem necess...

    SDF1 SDF1
    Discussions |
    Oct 9, 2023 7:54 AM
    1627 views | 2 replies
  • How to filter rows of a data table with dynamical number of conditions?

     Hi everybody, I would like to select rows based on the entries of selected rows from another table. Below a code snippet. The last row is not valid, but it should clarify what I mean. selected_row_idx = DT << Get Selected Rows; measurement_starts = DT:MeasurementStart[selected_row_idx]; measurement_ends = DT:MeasurementEnd[selected_row_idx]; DTmeas << Select Where(measurement_starts[1] <= :TimeSt...

    Robbb Robbb
    Discussions |
    Oct 9, 2023 2:27 AM
    1993 views | 2 replies
  • Do Not Open CSV File after 'Save As' when scripting

    Hi, I need to save tables by scripting both as .csv and then as .jmp.When the .csv table is saved, it is automatically opened in excel (Win 11, JMP17Pro). Is there a way to set an option (or preference) to prevent the behavior? Thanks Sebastien

    Sburel Sburel
    Discussions |
    Oct 8, 2023 1:40 PM
    2120 views | 3 replies
  • Help with this simple script of fit y by x

    Hello. I try to study the relationship of a quantitative variable with multiple quantitative variables. I wrote this script but it doesn't work. I show you the script and the error message. Thank you in advance. Script Names Default To Here(1); dt = Current Data Table(); numericColNames = dt << get column names(string, numeric); For(i = 38, i <= N Items(numericColNames), i++, Bivariate(Y(:Name("E...

    gallardet gallardet
    Discussions |
    Oct 8, 2023 9:38 AM
    2897 views | 6 replies
  • How to get non-duplicate column names from the "leaf label formula" of decision tree model?

    For example, use the following JSL to get the Leaf Label Formula.Extract the column names from the formula in the first 10 rows.Thanks!d0 = Open( "$SAMPLE_DATA/Equity.jmp" ); p=Partition( Y( :BAD ), X( :LOAN, :MORTDUE, :VALUE, :REASON, :JOB, :YOJ, :DEROG, :DELINQ, :CLAGE, :NINQ, :CLNO, :DEBTINC ), Validation Portion( 0.3 ) ); p<<go;Wait(2); p << save leaf label formula;

    lala lala
    Discussions |
    Oct 7, 2023 8:02 AM
    1505 views | 3 replies

Latest Discussions

  • How to get non-duplicate column names from the "leaf label formula" of decision tree model?

    For example, use the following JSL to get the Leaf Label Formula.Extract the column names from the formula in the first 10 rows.Thanks!d0 = Open( "$SAMPLE_DATA/Equity.jmp" ); p=Partition( Y( :BAD ), X( :LOAN, :MORTDUE, :VALUE, :REASON, :JOB, :YOJ, :DEROG, :DELINQ, :CLAGE, :NINQ, :CLNO, :DEBTINC ), Validation Portion( 0.3 ) ); p<<go;Wait(2); p << save leaf label formula;

    lala lala
    Discussions |
    Oct 7, 2023 8:02 AM
    1505 views | 3 replies
  • for each group find out which value is missing in a specific column, then create a new row with the missing value for that group with 0 in the count column as a corresponding value for that row

    I have 4 columns in the mock data set (File attached below). The column "Companys" is grouped by column "Month-Year" and "State". Each "Companys" column value is associated to a value in column "Sectcor". I want find what values are missing in each group of Month-Year and State Column for example Sector "DK" has Companys "C" and "D" Associated to it but for group Jan-2021, CA we have 2 rows associ...

    j0rg j0rg
    Discussions |
    Oct 6, 2023 1:54 PM
    1648 views | 1 replies
  • Are text files locked when importing?

    Hello, I’m writing a script to scrape machine log text files and collect the data in JMP. Some of these files are ‘active’ and may be appended to or even moved.

    I’m wondering whether JMP acts like Notepad where the file is not locked at all, or if there is a small chance the import will block another program manipulating the file.

    My question is for all versions of JMP 17 for Windows

    bculver bculver
    Discussions |
    Oct 6, 2023 4:34 AM
    883 views | 1 replies
  • Search specific name by IF

    HelloI have set up a New Column "Pin Name"and would like to add a number of PINIt means if you contain gp_0 in the column "Test Name" it should be GP_0or if you have contains gp_1 in test name it should be GP_1 in Column "Pin Name"or if you have contains gp_11 in test name it should be GP_11 in Column "Pin Name"I wrote the scriptColumn(dt,"PIN_NAME") << Formula ( If ( Contains( :TEST_NAME, "gp_0" ...

    Dennisbur Dennisbur
    Discussions |
    Oct 4, 2023 6:58 AM
    1117 views | 2 replies
  • Number Edit Box Not Storing Value when Entered by User

    Hello,I have the below script that creates a Window that asks the user to populate a Part Number and Lot Number. When the value is entered in the Part Number box and the Lot Number field is clicked, the value in the Part Number field disappears. This happens vice versa as well. Any thoughts on why this is happening?nw = New Window("Material Information", << Modal, Text Box("Information Type"), ...

    Austin Austin
    Discussions |
    Oct 2, 2023 12:18 PM
    959 views | 1 replies

Latest Discussions

  • What determines which data table is seen as "Associated Data" for New Window?

    What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)?   This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...

    jthi jthi
    Discussions |
    Sep 21, 2023 9:44 AM
    871 views | 0 replies
  • Data Access Handler

    How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties.  But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...

    hogi hogi
    Discussions |
    Sep 16, 2023 12:21 AM
    657 views | 0 replies
  • Use JMP Locale Settings( 0 ) not working on macOS

    It seems the following command does not work for JMP MacOS.   Use JMP Locale Settings( 0 )   Is there a general script to deal with the following scenario? Or do we need to put conditionals depending on the OS of the user? // Configuring JMP to save CSV as commas and not If( (Num( "3.14" ) == 3.14), is_EN_num_format = 1, //"English numeric format" is_EN_num_format = 0 //"Non-english"); )...

    FN FN
    Discussions |
    Sep 15, 2023 10:21 AM
    787 views | 0 replies
  • Exporting Graphs from Tab box to Excel cell

    Hi, Is there a way to export the graphs in each tab box in the Excel cells that look something like the one below?JMP Tab Box Excel  Below is the jsl code to create graphsdt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); List1 = {"NPN1", "PNP1", "PNP2", "NPN2", "PNP3", "IVP1"}; List2 = {"PNP4", "NPN3", "IVP2", "NPN4", "SIT1"}; List3 = {"INM1", "INM2", "VPM1", "VPM2", "VPM3"}; List4 = {"SN...

    Jackie_ Jackie_
    Discussions |
    Sep 12, 2023 2:09 PM
    826 views | 0 replies
  • PickFile() from within a Project does not use file filters

    When I use PickFile() outside of a project, it works as noted in the scripting guide, scripting index, and other posts here in the forums. However, when I run the script within a project, the window that opens is a different one. It seems to be in order to allow you to pick a file that is saved to the project itself, but the filters do not work even though it shows the folder that I specified as d...

    R2OKeefe R2OKeefe
    Discussions |
    Sep 3, 2023 8:45 PM
    1204 views | 0 replies
view all discussions