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: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
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: 

Learning Resources

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

view all learning resources

Latest Discussions

  • Cumulative sum by grouping and rolling values formula??

    I have a data set with groups, days and visits on those days.  I would like to get a rolling sum of every 3 days, so at day 3 the value would be sum of day 1, 2, 3, but on day 4 the value is the sum of days 2, 3,4.   And do this by group.  I know I can use the cumulative sum by group, but that returns the sum each day, so day 4, would be the sum of all 4 days, but I would like the first day to dro...

    chadyoder chadyoder
    Discussions |
    Oct 25, 2022 12:15 PM
    1390 views | 2 replies

  • Best practice for preventing namespace pollution/cross-talk when calling Functions in an included file

    There are several threads on this topic already, as well as a section in the Scripting Guide, but none really answer my question. I have two files, Main.jsl and Function.jsl, and I include the latter file in the former. There is a Function defined in Function.jsl that I wish to call inside of a For loop in Main.jsl. The problem I had is that the called Function also uses a For loop, and both the F...

    AutoSalamander3 AutoSalamander3
    Discussions |
    Oct 25, 2022 8:25 AM
    1455 views | 2 replies

  • How do I split text in a cell into rows without a delimiter?

    I would like to split data in my rows from looking like this:Start Letter No.End Letter No.Letter SequenceDelta D3033ABCD0.065to looking like this:Start Letter No.End Letter No.Letter SequenceDelta D3030A03131B0.0653232C0.0653333D0.065 Where the sequence of letters in the text are split into a single letter in each row and this is associated with it's corresponding number in the sequence. The 'Del...

    MarginOfMap112 MarginOfMap112
    Discussions |
    Oct 25, 2022 8:12 AM
    2067 views | 1 replies

  • Column Group with variable Column Count

    Query_DT << GROUP COLUMNS("WEEKS",COLUMN(12),75); COLGRP = Query_DT << GET COLUMN GROUP ("WEEKS"); Query_Stack = Query_DT << STACK(columns(COLGRP), Source Label Column( "Label" ), Stacked Data Column( "Data" ) );I need to group columns to create a stacked table..  the problem is that the number of columns can vary.  This code works fine, except in the Group Columns function I need the 75 to be ...

    Phil_Nash Phil_Nash
    Discussions |
    Oct 25, 2022 6:28 AM
    1298 views | 2 replies

  • How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

    Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...

    SquaresDingo505 SquaresDingo505
    Discussions |
    Oct 24, 2022 7:23 PM
    724 views | 0 replies

Latest Discussions

  • Cumulative sum by grouping and rolling values formula??

    I have a data set with groups, days and visits on those days.  I would like to get a rolling sum of every 3 days, so at day 3 the value would be sum of day 1, 2, 3, but on day 4 the value is the sum of days 2, 3,4.   And do this by group.  I know I can use the cumulative sum by group, but that returns the sum each day, so day 4, would be the sum of all 4 days, but I would like the first day to dro...

    chadyoder chadyoder
    Discussions |
    Oct 25, 2022 12:15 PM
    1390 views | 2 replies

  • How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

    Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...

    SquaresDingo505 SquaresDingo505
    Discussions |
    Oct 24, 2022 7:23 PM
    724 views | 0 replies

  • How to create categorization from data with with known categories for comparison and categorization of a new data run of unknown category

    Scenario: I have 8 compounds A-H, for each compound I have 5 runs* of time-temperature data with a known category. I need to be able to compare a single data run of an unknown category to those existing runs and assign a category to that run. A few things going on which may also need accounted for:1) My start times (when heating began vs the data run started) do not all align.2) Not all runs end a...

    atoomey atoomey
    Discussions |
    Oct 24, 2022 8:13 AM
    6568 views | 10 replies

  • Change column names at once

    Hello, I have a data table with several continuous columns, each column with a different name. I wish to: 1) duplicate continuous columns all at once; 2) rename these new columns with their original names (i.e., lady beetle) plus add "/100" to their names (i.e., column name would be: lady beetle/100) all at once; then 3) I want to multiply these new columns by 4 all at once (only the continuous co...

    bordini bordini
    Discussions |
    Oct 23, 2022 8:54 AM
    2930 views | 3 replies

  • know number of data-missing row when making a summary table

    Hi all JMP experts, I'm making a summary table from a raw data table - taking median by group names defined in column "purpose," e.g. a group is named "BSL."The summary table shows that there are totally 744 rows of group "BSL" that are used for summary-extraction, but is there a way to know within the 744 data rows, how many rows contain/doesn't contain(i.e. missing) numbers?   

    stevend1219 stevend1219
    Discussions |
    Oct 22, 2022 5:22 AM
    888 views | 1 replies

Latest Discussions

  • How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

    Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...

    SquaresDingo505 SquaresDingo505
    Discussions |
    Oct 24, 2022 7:23 PM
    724 views | 0 replies

  • How to Analyze and Graph Responses with Supercategories

    I use JMP Pro 16. I am doing MCA on 90 columns that have supercategories.  I want to do the analysis and viz on the supercategory classification. Is there a way to do this without having to create separate columns that only have the supercategory classification?  PS:  I don't know how to do JSL scripting.

    TCM TCM
    Discussions |
    Oct 21, 2022 5:59 AM
    767 views | 0 replies

  • 標準化列名稱如何用變數取代求解

    //新增周標準化
    weekEMC_HF_C_12_0 = Data Table( "周_EMC_HF_C_12um" ) << Get Column Names( string );
    weekEMC_HF_C_12 = {};
    //少一周={:"2022W38"n,:"2022W40"n,:"2022W41"n};
    For( j = N Items( weekEMC_HF_C_12_0 ), j >= (N Items( weekEMC_HF_C_12_0 ) - 5), j--,
    Insert Into( weekEMC_HF_C_12, weekEMC_HF_C_12_0[j] )
    );
    Try(
    Local( {old dt = Current Data Table()},
    Current Data Table( Data Table( "周_EMC_HF_C_12um" ) );
    For Each( ...

    Ken697 Ken697
    Discussions |
    Oct 20, 2022 9:22 PM
    680 views | 0 replies

  • Methods for compressing a CSV or TSV file with jmp compression to save as .jmp table without having to open the csv in JSL first?

    I have access to both JMP12 and JMP14, so a solution for either would work. What I am trying to achieve is saving very large text files (csv,tab,tsv,etc.) with JMP compression such that I get a compressed .jmp file as the result. By large I mean 2-6gb files. Currently I use something like this: MyDataFile = open(filename,Private); MyDataFile << Compress File When Saved; MyDataFile << save(filetosa...

    CurbStegosaurus CurbStegosaurus
    Discussions |
    Oct 14, 2022 9:06 AM
    1831 views | 0 replies

  • Model classification thresholds add-in display "negative" probability

    Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...

    Agustin Agustin
    Discussions |
    Sep 13, 2022 6:43 AM
    578 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

More on the many advantages of structural equation models

 view all blog articles

Learn more about JMP's premier analytics conference