cancel
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
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • Concatenate and Suppress Formulas

    Folks, I have several tables (samples) that have many active column formulas. My script at one point, concatenates all the tables. However, I want the formulas to suppress since I want to keep the individual table data (sample) intact so as to compare / overlay all the data that was concatenated. Unfortunately, I can't seem to properly turn off the formulas when concatenated, and the newly concate...

    NRW NRW
    Discussions |
    Jan 25, 2022 8:23 AM
    4227 views | 9 replies
  • Query Builder filtering on date stored in Varchar(20)

    Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO]      ,[DESPA...

    HansD HansD
    Discussions |
    Jan 25, 2022 6:12 AM
    1390 views | 0 replies
  • update table based on timestamp

    Hi,I have two tables. (A and B)Table A contain (2000events along the duration of a test) events marking the beginning of a period and the name of the period at specific timestamps (underlined line is header)TimeStamp, Period30-12-2021 17:35:49.1, A 30-12-2021 17:39:36.8, B ...so Period A is between "30-12-2021 17:35:49.1" and "30-12-2021 17:39:36.8" Table B is of a log file recording data also wit...

    Shahars Shahars
    Discussions |
    Jan 25, 2022 4:08 AM
    1692 views | 4 replies
  • How do I round the results to two decimal places In the Summary Statistics?

    Analyze --> Distubutions - In the Summary Statistics table how do I round the results to two decimal places?

    Harold_9127178 Harold_9127178
    Discussions |
    Jan 24, 2022 6:02 PM
    2635 views | 1 replies
  • Enhanced log question

    In using the enhanced log in JMP 16, I don't seem to get the script for "make into data table" after a tabulation.  I open a file and tabulate and both of those appear in the script.  But when I make the tabulation into a data table no script appears.  If I close the data table I created, closing that file appears - but not the "make into data table."

    dale_lehman dale_lehman
    Discussions |
    Jan 24, 2022 2:29 PM
    1299 views | 3 replies

Latest Discussions

  • Query Builder filtering on date stored in Varchar(20)

    Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO]      ,[DESPA...

    HansD HansD
    Discussions |
    Jan 25, 2022 6:12 AM
    1390 views | 0 replies
  • update table based on timestamp

    Hi,I have two tables. (A and B)Table A contain (2000events along the duration of a test) events marking the beginning of a period and the name of the period at specific timestamps (underlined line is header)TimeStamp, Period30-12-2021 17:35:49.1, A 30-12-2021 17:39:36.8, B ...so Period A is between "30-12-2021 17:35:49.1" and "30-12-2021 17:39:36.8" Table B is of a log file recording data also wit...

    Shahars Shahars
    Discussions |
    Jan 25, 2022 4:08 AM
    1692 views | 4 replies
  • How do I round the results to two decimal places In the Summary Statistics?

    Analyze --> Distubutions - In the Summary Statistics table how do I round the results to two decimal places?

    Harold_9127178 Harold_9127178
    Discussions |
    Jan 24, 2022 6:02 PM
    2635 views | 1 replies
  • Enhanced log question

    In using the enhanced log in JMP 16, I don't seem to get the script for "make into data table" after a tabulation.  I open a file and tabulate and both of those appear in the script.  But when I make the tabulation into a data table no script appears.  If I close the data table I created, closing that file appears - but not the "make into data table."

    dale_lehman dale_lehman
    Discussions |
    Jan 24, 2022 2:29 PM
    1299 views | 3 replies
  • calculation using data from 2 tables

    Hi all,wandering if you can help...I'm trying to create new columns in a table from a calculation of a transposed summary but I keep getting errorswith defining some constants from the table.any idea what I'm doing wrong?  src_tran = src_sum << Transpose( Label( :Label ) ); Current Data Table( src_tran ); src_tran << new column("N", Formula(If( Substr( :Label, 0, 1 ) == "M", Substr( Substr( ...

    Boaz Boaz
    Discussions |
    Jan 24, 2022 1:56 PM
    1137 views | 2 replies

Latest Discussions

  • Query Builder filtering on date stored in Varchar(20)

    Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO]      ,[DESPA...

    HansD HansD
    Discussions |
    Jan 25, 2022 6:12 AM
    1390 views | 0 replies
  • M1 Macbook Pro JMP Capabilities

    Hi all, 
    I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...

    MikeDereviankin MikeDereviankin
    Discussions |
    Jan 21, 2022 1:52 PM
    789 views | 0 replies
  • How do I apply time fixed effects with multiple regression

    I have financial panel data and would like to hold dummy time variables fixed as I regress the other independent variables to test my model's significance. Not sure how to proceed. Is this function only available in SAS? Thanks   

    RiDe RiDe
    Discussions |
    Jan 10, 2022 11:18 PM
    701 views | 0 replies
  • separating labelled values from graph points

    I have looked in the scripting help section and all over this community and haven't found a solution for my problem so hopefully someone can help. I have a graph containing two trend lines and a bar graph and want to label the values of each point but when I set the labels both values show up on each trend line and I can't figure out how to separate the labels. I tried stacking the labelled column...

    Cdougz Cdougz
    Discussions |
    Dec 31, 2021 7:38 AM
    913 views | 0 replies
  • Expand Contours

    Hi, 

    I understand that the contouring is done based on triangulation to data points, but is there a method for expanding them further to fit a custom SHP file I've imported into JMP? I've already set the alpha and the lowest value so the contour should cover the, 'most', area. Any other methods? Thanks! 

    MikeDereviankin MikeDereviankin
    Discussions |
    Dec 15, 2021 12:49 PM
    710 views | 0 replies
view all discussions