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: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.

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

  • Column formula dependency cycle error

    Hi all,  Just wonder how we can do circular references in JSL.For example, I have a population qty and failure rate. But the failure rate for each year depends on the survive parts. Year Original equipment   Failed    Survive1        100                           1             992        99                             2             97   3        97                             3             94 I kn...

    mquyen mquyen
    Discussions |
    Oct 30, 2023 11:40 AM
    2188 views | 7 replies

  • Using a formula column, how do I find a value in a subset of the data based on other columns

    If I have two different time series in a table, and there is a findable event in both series, but they occur at different times. How can I specify a formula column to subtract off the time such that the finable events start at time zero?

    Cactus123456 Cactus123456
    Discussions |
    Oct 30, 2023 10:49 AM
    1042 views | 2 replies

  • Creating a list/box of numbers with variable decimal places

    I feel like I've been doing something the extra hard way that seems like it should be a relatively straightforward task.  Wondering if anyone else has advice on a better approach.I'm trying to create a custom table like the one shown here, where each of the entries in the "Value" column can have a different number of decimal places.  In the example below, "N" should have 0 decimal places, "Mean"/"...

    jc510_2 jc510_2
    Discussions |
    Oct 30, 2023 9:44 AM
    1522 views | 3 replies

  • Concatenate all data tables using JSL

    Hi, I want to concatenate all open data tables. However, the number of data tables can vary and I want the script to be able to adapt for different number of tables.   This is the code for what I want to do, however I want to have it generalised:   Data Table(N Table()) << Concatenate( Data Table((N Table() - 1)), Data Table((N Table() - 2)), Data Table((N Table() - 3)), Data Table((N Table()...

    MedianRooster10 MedianRooster10
    Discussions |
    Oct 30, 2023 9:38 AM
    2493 views | 6 replies

  • Entering a difference column in jmp tabulate

     Hi,In above graph I looking to add a 3  columns "Delta1, Delta2, Delta3" to the right which evaluates difference between values rxAnt 1,2,3 for Kestrel and rxAnt 1,2,3 for Owl resp i.e  Delta1 = -97 - (-98) = 1Delta2 = -97 - (-98) = 1Delta3 = -100 - (-100) = 0  Can we do this?  

    vharibal vharibal
    Discussions |
    Oct 30, 2023 7:25 AM
    1785 views | 5 replies

Latest Discussions

  • Entering a difference column in jmp tabulate

     Hi,In above graph I looking to add a 3  columns "Delta1, Delta2, Delta3" to the right which evaluates difference between values rxAnt 1,2,3 for Kestrel and rxAnt 1,2,3 for Owl resp i.e  Delta1 = -97 - (-98) = 1Delta2 = -97 - (-98) = 1Delta3 = -100 - (-100) = 0  Can we do this?  

    vharibal vharibal
    Discussions |
    Oct 30, 2023 7:25 AM
    1785 views | 5 replies

  • Create columns with 'Steps' and 'Runs' based on column with sequential numbers but varying rows, 'Steps' repeat every 4th number.

    Having a tough time trying to word this question! But I have a data set, 'Sample', that start at 1 and is continuous but number of rows per value is not consistent (ie. 1,1,1,2,2,3,3,3,3,4,4,5...). Format for sample and desired columns below. Thanks!  SampleStep # (desired)Run # (desired)111111221331331441512512622732732732732842913913913102310231023113312431243124313141424153416441644

    Ctron87 Ctron87
    Discussions |
    Oct 30, 2023 7:23 AM
    1260 views | 4 replies

  • Add-in Manager with Google Drive

    Hello, I have an add-in that I deploy and maintain at a customer site with dozens of users. The problem is that when I deliver a new version, the users have to update. This customer has the google suite, so I drop the new version each time on a private google Drive directory , and the users have to retrieve this new version each time to update. We all agree that this is very time-consuming, not op...

    SophieCuvillier SophieCuvillier
    Discussions |
    Oct 30, 2023 7:03 AM
    1075 views | 2 replies

  • MFI import data start on row X

    Hello, I am trying to do a multi file import, but I have data with a header on row 7 and data starting on row 8. I know how to change this in the script for individual worksheet imports. How do I do it for MFI? Using JMP 17. 

    patriciafm811 patriciafm811
    Discussions |
    Oct 30, 2023 6:42 AM
    588 views | 1 replies

  • Add Counter for Unique Cases in Groups

    Hi all,  How can I write an integer value counter to increment unique values in column B within group A, to do this? Here is what I have tried so far:   dt_Table1 = Data Table("Table1"); dt_Table1 << New Column("Dataset", Numeric, "Nominal", Set Selected); Sum1 = dt_Table1 << Summary(Group(:Group, :Date)); Sum2 = Sum1 << Summary(Group(:Group)); :N Rows << Set Name("N Datasets in Group"); dt_Tab...

    StumptownSlash StumptownSlash
    Discussions |
    Oct 29, 2023 3:30 PM
    2684 views | 10 replies

Latest Discussions

  • Functional data in rows-as-functions, but different rows have different step size

    Hello - I have a table with 250+ experiments and thousands of columns, about 100 that are for either raw or transformed data, and then I'm taking output from an xml file with functionally "spectral data" (XRD diffractograms for anyone that is familliar), and just laying that on its side in row form (more explanation if needed in another question I posted here: https://community.jmp.com/t5/Discussi...

    ehchandlerjr ehchandlerjr
    Discussions |
    Oct 28, 2023 12:33 PM
    511 views | 0 replies

  • How to adjust the factor range for specific factors within an ongoing DOE

    Hi, I designed a DOE that has two independent buffers. This DOE will range components in each buffer which will be used in a processing step sequentially. IE, buffer A, followed by buffer B. We already prepared for the DOE, and formulated the A buffers as per the recommended design. For the B buffers, we intended on ranging 2 components but later decided to reduce to ranging one component, and als...

    MetaLizard62080 MetaLizard62080
    Discussions |
    Oct 26, 2023 5:25 PM
    466 views | 0 replies

  • Type 1 MSA for microscope and Offset.

    Hello Everyone,I was looking for someone who could help me with a dilemma I'm facing with respect to an MSA for a microscope. The specific problem is that i do not have tolerance I can input for my type 1 analysis. Resolution used is 5 microns per pixel, the accuracy cannot be below 5 microns. This is the standard resolution for particles starting from 50 microns. I have attached the Linearity stu...

    MSAanalysis MSAanalysis
    Discussions |
    Oct 23, 2023 12:58 AM
    1008 views | 0 replies

  • Is it possible to customize such buttons in the toolbar: a button next to an editor bar?

    The edit bar can fill in characters, click the button to run a JSL, JSL can automatically read the content of the edit bar and write into the variable. Thanks!

    lala lala
    Discussions |
    Oct 19, 2023 11:01 PM
    418 views | 0 replies

  • Is it possible to have independent x-axis ordering within x-axis groups in graph builder?

    In the attached data table the saved script plots the chart below.I want the x-axis parameter bars to change in order with the highest number of fails appearing first within each week (i.e. a Pareto type plot within each week)I created a FailOrder column for ordering within each week, but it does not seem to do what I want. Is there a way, via JSL, to have the order of the parameters (Para) in asc...

    Neo Neo
    Discussions |
    Oct 17, 2023 7:33 AM
    465 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

JMP® Marketplace Feature: S3 Data Connector

 view all blog articles

Learn more about JMP's premier analytics conference