cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

Latest Discussions

  • Recode a value in a column with a formula instead of a static value

    The original value that is in the table that I want to recode will always be 01/01/1900.  I want to recode that to today's date.  This only returns a blank, and not today's date.  Any idea what I need to change? Thanks! Transfers << Begin Data Update; Transfers << Recode Column( Transfers:OrderDate, {Map Value( _rcOrig, {-126144000, short date(today())}, Unmatched( _rcNow ) )}, Update Propertie...

    Phil_Nash Phil_Nash
    Discussions |
    Oct 7, 2025 1:22 PM
    1287 views | 2 replies
  • Order Within Grouping Variable

    I apologize if this has been answered, but I can’t find quite the right answer in the discussions.  I have a grouping variable and I performed a t test with two values in the grouping variable.  The variable values are “Before” (n=6,437) and “After” (n=264).  JMP is showing me the t-test as (Before minus After), which results in a negative value.  I understand that I can just multiply by -1 to rev...

    LawOfAardvark73 LawOfAardvark73
    Discussions |
    Oct 6, 2025 8:00 PM
    306 views | 2 replies
  • Time varying effect in Recurrence Analysis, data format and calculation

      Dear all
    I am assigned a task to perform recurrence analysis on our data.
    The data we have are robot repairs. We want to see repair events and cost in response to accumulated transactions using recurrence analysis.
    I attached a simulated data for this question. It only has three bots since we haven't decided how to arrange the data and I just put those three bots manually. I will update with more ...

    Caozheng0115 Caozheng0115
    Discussions |
    Sep 26, 2025 11:29 AM
    852 views | 0 replies
  • Tables/Update changed!

    Please note, there is a significant change of the Tables/Update functionality in JMP19. dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); // Update data table Data Table( "Big Class" ) << Update( With( Data Table( "Big Class Families" ) ), Match Columns( :name = :name, :age = :age ), Replace Columns in Main Table( None ) );   Available columns afte...

    hogi hogi
    Discussions |
    Sep 25, 2025 12:56 AM
    1738 views | 4 replies
  • Single Column V look up equivalent

    Hey everyone, So I have been using a formula that works in the same way as vlookup in excel but I have now discovered that it does not work on larger data tables as it basically bogs down and kills JMP.   Attached is a sample data table and where I have split out the two functions that I had combined which works as expected:       VLU Item   VLU Result         If I were to take the formula from...

    shampton82 shampton82
    Discussions |
    Sep 21, 2025 10:21 PM
    1482 views | 7 replies

Latest Discussions

  • Recode a value in a column with a formula instead of a static value

    The original value that is in the table that I want to recode will always be 01/01/1900.  I want to recode that to today's date.  This only returns a blank, and not today's date.  Any idea what I need to change? Thanks! Transfers << Begin Data Update; Transfers << Recode Column( Transfers:OrderDate, {Map Value( _rcOrig, {-126144000, short date(today())}, Unmatched( _rcNow ) )}, Update Propertie...

    Phil_Nash Phil_Nash
    Discussions |
    Oct 7, 2025 1:22 PM
    1287 views | 2 replies
  • Time varying effect in Recurrence Analysis, data format and calculation

      Dear all
    I am assigned a task to perform recurrence analysis on our data.
    The data we have are robot repairs. We want to see repair events and cost in response to accumulated transactions using recurrence analysis.
    I attached a simulated data for this question. It only has three bots since we haven't decided how to arrange the data and I just put those three bots manually. I will update with more ...

    Caozheng0115 Caozheng0115
    Discussions |
    Sep 26, 2025 11:29 AM
    852 views | 0 replies
  • Tables/Update changed!

    Please note, there is a significant change of the Tables/Update functionality in JMP19. dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); // Update data table Data Table( "Big Class" ) << Update( With( Data Table( "Big Class Families" ) ), Match Columns( :name = :name, :age = :age ), Replace Columns in Main Table( None ) );   Available columns afte...

    hogi hogi
    Discussions |
    Sep 25, 2025 12:56 AM
    1738 views | 4 replies
  • How to order my values including supercategories created?

    Hello, I have created supercategories but can't order my values including my supercategories in a specific order (ex: supercategory Top2Boxes, then supercategory TopBox, then each of my value in descending order 'strongly agree' etc.). How can I do this please? Many thanks and kind regards, 

    Nath Nath
    Discussions |
    Sep 19, 2025 2:13 AM
    487 views | 4 replies
  • Why is Tables/Concatenate so slow?

    Has this ever happened to you?
    Sometimes it takes a very long time for Tables/Concatenate to finish merging two tables.More than a minute for just a few columns and some 100k rows.What could be the reason? 

    hogi hogi
    Discussions |
    Sep 17, 2025 11:47 PM
    2052 views | 5 replies

Latest Discussions

  • Time varying effect in Recurrence Analysis, data format and calculation

      Dear all
    I am assigned a task to perform recurrence analysis on our data.
    The data we have are robot repairs. We want to see repair events and cost in response to accumulated transactions using recurrence analysis.
    I attached a simulated data for this question. It only has three bots since we haven't decided how to arrange the data and I just put those three bots manually. I will update with more ...

    Caozheng0115 Caozheng0115
    Discussions |
    Sep 26, 2025 11:29 AM
    852 views | 0 replies
  • Copy Formula for Tables / Update

    In Tables / subset, the user can decide if a column formula is copied and if the evaluation is suppressed:   Is there a hidden option which does the same trick for Tables/Update?

    great for "documentation"great for "what if" ...on the other hand: one cannot guarantee that all input columns for the formula will be available in the target data table.
    -> default option "suppress formula evaluation"?

    hogi hogi
    Discussions |
    Sep 12, 2025 7:47 AM
    913 views | 0 replies
  • How to adjust the size of R plot imported with get R graphics(); ?

    I'm trying to run R code in JMP to create a plot. I succeeded in importing the plot in png format, but failed to adjust the size of the plot. I can adjust the "plot_from_R" in png format with the set size(); function in jsl, but it is not proportional and distorted. How can I import plot_from_R in the size I want?   R Init(); R Submit( "\[ windows(300,100) #it doesn't work plot(function(x) dnorm(...

    CountableModel1 CountableModel1
    Discussions |
    Jan 15, 2025 4:01 PM
    621 views | 0 replies
  • user defined Transform Category?

    How can I create a custom function which shows up in the Character submenu of  the new formula column menu? 

     

    hogi hogi
    Discussions |
    Dec 4, 2024 5:01 AM
    444 views | 0 replies
  • Error add-in manager :AddinID == selectionID

    I am taking the above error once i click to build currently selected add-in button at the add-in manager.  Error Message: {"Send Expects Scriptable Object"(1, {23}, 2, "Send", here:addinTable << /*###*/get rows where(:AddinID == selectionID) /*###*/)} Error: Send Expects Scriptable Object 1 time(s). Data Table Indices: 23 Type: Error Function Name: Send Function being executed: here:addinTab...

    Georgios_Tsim Georgios_Tsim
    Discussions |
    Oct 29, 2024 6:41 AM
    688 views | 0 replies
view all discussions