User Community
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: 
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

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

view all learning resources

Latest Discussions

  • Deleting Similar Rows

    I'm trying to create a script that will delete a row from my table if the ID and two values are the same as the row before it. I cant delete all duplicate rows because there is a "run number" column that is unique to each row. Does anyone know why my code isn't working?   // Delete Duplicate Rows (re-entries) NRows = N Rows(dt); For(i = 1, i <= NRows, i++, If( dt:ID[i] == dt:ID[i + 1] & Data T...

    S_Boilermaker S_Boilermaker
    Discussions |
    Jun 14, 2024 7:49 AM
    918 views | 1 replies

  • How to Process Continuous Alarm Data Using a JMP Script

    I want to count the number of times an alarm occurs in the process. The data comes in every second. When an alarm occurs, the data shows 1, and if the worker doesn’t turn off the alarm, the number 1 continues to appear.

    The problem is, if the alarm is not turned off within 10 seconds, it actually counts as one alarm but appears as 10 alarms in the data.

    I want to leave only one row and delete the re...

    Ronaldo Ronaldo
    Discussions |
    Jun 11, 2024 3:25 PM
    1365 views | 2 replies

  • Consolidating Repeated Values

    I have a table like this with an ID number and a value assigned to each. Some ID numbers were tested multiple times and so have multiple values. I've seen codes to remove all rows with duplicate ID numbers, but I'd like a code that deletes all rows with duplicate ID's BUT saves the value from the nth test under a new column (e.g. value 2, value 3, value n)... Any help would be greatly appreciated....

    S_Boilermaker S_Boilermaker
    Discussions |
    Jun 10, 2024 1:46 PM
    985 views | 1 replies

  • Data preparation- substract column data by other column

    Hi,I have a table with different scan results.I have 180 scans with 1000 results per scan.results are at the Z column.I want to create a new column with relative scan results, meaning the results of scan 2 - the results of scan 1, results of scan 3 - the results of scan 2, and so on.subtraction of results must be by Location number, 1-1, 2-2, 3-3, and so on.I've tried to transpose the data but got...

    Ohad_s Ohad_s
    Discussions |
    Jun 9, 2024 4:57 AM
    1938 views | 4 replies

  • Recding in JSL while keeping most initial values

    Hi,I have a column with probablities. Mostly these are just numbers between 0 and 1. However, for a probablity of 100% I got 100 instead of 1. My idea to fis the issue was simply to ues the recoding function and then replace all occurences of "100" by "1".The code scnipped I'm using is:dt << Recode Column ( :"probability"n, {IF( _rcNOW == 100, 1)}, Target Column (:"probability"n) );This works p...

    matthias_bruchh matthias_bruchh
    Discussions |
    Jun 7, 2024 11:48 AM
    1646 views | 3 replies

Latest Discussions

  • Deleting Similar Rows

    I'm trying to create a script that will delete a row from my table if the ID and two values are the same as the row before it. I cant delete all duplicate rows because there is a "run number" column that is unique to each row. Does anyone know why my code isn't working?   // Delete Duplicate Rows (re-entries) NRows = N Rows(dt); For(i = 1, i <= NRows, i++, If( dt:ID[i] == dt:ID[i + 1] & Data T...

    S_Boilermaker S_Boilermaker
    Discussions |
    Jun 14, 2024 7:49 AM
    918 views | 1 replies

  • Consolidating Repeated Values

    I have a table like this with an ID number and a value assigned to each. Some ID numbers were tested multiple times and so have multiple values. I've seen codes to remove all rows with duplicate ID numbers, but I'd like a code that deletes all rows with duplicate ID's BUT saves the value from the nth test under a new column (e.g. value 2, value 3, value n)... Any help would be greatly appreciated....

    S_Boilermaker S_Boilermaker
    Discussions |
    Jun 10, 2024 1:46 PM
    985 views | 1 replies

  • How to convert decimal value to binary value in another column?

    How to convert decimal value to binary value in another column?

    Liranlev Liranlev
    Discussions |
    May 31, 2024 12:43 PM
    3788 views | 8 replies

  • Update column with formula

    Hi all,I have two data table (dt1 & dt2). I need to add dt2's column (Col1) to dt1 with a formula in it. But when I update the table, the values from Col1 are empty. Seems to be a problem in the formula. Please help current data table (dt1); dt1 << Update( With( dt2), Match Columns( :KeySample= :KeySample), Add Columns from Update table ( :Col1) ); dt1:Remarks << Formula ( If( :Col1== "Out of...

    UserID16644 UserID16644
    Discussions |
    May 30, 2024 11:53 AM
    2827 views | 5 replies

  • Make calculation show on table summary?

    Hi!I am trying to get a column to show up on my table summary. This column would be the output of one of the columns IN the table summary divided by a constant. Is there a way to do that?

    eruck eruck
    Discussions |
    May 30, 2024 8:31 AM
    933 views | 1 replies

Latest Discussions

  • How to categorize the same ID in row with other columns?

    Hi, I have the data set that the same ID in multiple rows. Each rows had 1 to 3 categories. The columns represent costA to costZ that I need to stack in the same Cost column. However, I need to generate group by category 1 ( 1 if category 1 < 2000, 2 if category 1 = 2000 - 4000, 3 if category 1 = 4000 - 6000, 4 if category 1 = 6000 - 10000, 5 if category 1 > 10000). However, I need to delete categ...

    doraemengs doraemengs
    Discussions |
    Mar 25, 2024 9:12 PM
    1173 views | 0 replies

  • RSS, TSS, precent of residual sum of squares

    Is it possible to calculate RSS and TSS and precent of residual sum of squares for a linear calibration curve in JMP?

    gholamhasantey gholamhasantey
    Discussions |
    Mar 25, 2024 3:29 AM
    1093 views | 0 replies

  • Is there a way to change the defaults for the Summary platform?

    Hi All,   Does any know if it's possible to change the defaults of the Summary platform (Tables > Summary)?   By default, Summary sets the new column names to be stat(column) and checks that the new data table is linked to the original data table.  For much of the work I do, I don't like these features and wish I didn't have to change them every time I run a Summary. I know it can be useful at tim...

    SDF1 SDF1
    Discussions |
    Feb 29, 2024 8:08 AM
    745 views | 0 replies

  • Custom Binning - how to edit the bins?

    Wow, custom binning even works with dates, cool! There is even a possibility to edit the binning. But: quite uncomfortable to type in the dates in seconds and to correct the labels manually.What do I have to change in my workflow to be able to enter the "dates" in a usual format - and to get the labels adjusted automatically?

    (view in My Videos) dt = Open( "$SAMPLE_DATA/Aircraft Incidents.jmp" ); d...

    hogi hogi
    Discussions |
    Jan 21, 2024 2:33 AM
    1061 views | 0 replies

  • Custom Binning - how to edit Transform Column settings?

    In Jmp16, Custom binning was introduced: Interactive Binning - New in JMP 16 Very useful, thanks a lot to the developers! There are 3 ways (or more?) to use this feature:In the data table, via the menu:  Col/Utilities/Make Binning Formula ...
    or via right click / New Formula Column/Distributional */Custom Binning ...


    for plot modes like Overlay, Color, X/Y Group, Page:
    via right click/Levels/Custom L...

    hogi hogi
    Discussions |
    Jan 19, 2024 10:50 PM
    801 views | 0 replies
view all discussions

JMP Events

Sorrento, Italy 10-12 March
view all events
Latest Blog Post

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration

JMP blog post photo
view all blog articles

Learn more about JMP's premier analytics conference