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

  • Creating a New Column with Initial Sequence Data

    I frequently concatenate multiple data tables into a single table and then add two new columns with initialized data. New Column 1 is called "Device" and is a constant that I enter. New Column 2 is called "Index" and is sequential data from 1 to x, where x is the last row in the data table.  I would like to script the creation of these two new columns in the concatenated table, ideally with a Pop ...

    toddsmith77 toddsmith77
    Discussions |
    Jul 14, 2020 7:25 AM
    3189 views | 4 replies

  • data normalization

    Hi All,I'm very new to JMP. I am using 9.0.3 version.I want to normalize my data, using one of the cells in the same data set.Is there a function/script to do this ?Thanks for your help,Ozan.

    optoman optoman
    Discussions |
    Jul 13, 2020 11:43 AM
    13640 views | 3 replies

  • Show/Hide Labels due to number of bars

    Hi,What is the way in JSL to know how many bars a Graph Builder Bar chart has?If there are many bars (>20), I would like to hide bar labels.Thanks.

    tom_abramov tom_abramov
    Discussions |
    Jul 13, 2020 8:41 AM
    2616 views | 5 replies

  • Transposing a data table with multiple columns for same label

    Hello!

    I have a data table with multiple wafers, the tools they pass at a certain step.  Sometimes a wafer may hit multiple tools at the same step.  I am losing toolsets using: TrSWC = SWC << Transpose( columns( :Column ), Transpose selected rows only( 1 ), By( :Wafer ), Label( :Label ), Output Table( "Transpose_Table" ) ); where SWC= WaferLabelColumn1X A1XB1ZC

    TrSWC = WaferLabelXZ1ColumnBC
    ...

    timjnixon timjnixon
    Discussions |
    Jul 13, 2020 7:36 AM
    3157 views | 7 replies

  • Select where and subset based on cell value

    Hi,   I have the below piece of code where I want it to get column names from the file and then create a new subset table followed by finding mean and SD of all numeric columns. The Mean and SD code works but it is not creating the subset table at all. Any ideas? I have checked this against all posted discussions. I have tried both Starts with and Contains conditions Here is the sample file: Seria...

    Kriti Kriti
    Discussions |
    Jul 12, 2020 12:07 PM
    1890 views | 2 replies

Latest Discussions

  • Creating a New Column with Initial Sequence Data

    I frequently concatenate multiple data tables into a single table and then add two new columns with initialized data. New Column 1 is called "Device" and is a constant that I enter. New Column 2 is called "Index" and is sequential data from 1 to x, where x is the last row in the data table.  I would like to script the creation of these two new columns in the concatenated table, ideally with a Pop ...

    toddsmith77 toddsmith77
    Discussions |
    Jul 14, 2020 7:25 AM
    3189 views | 4 replies

  • Turning a continuous variable into a discrete variable

    Hi all - was wondering if someone could give me a few pointers on a problem I'm struggling with. I would like to create a dummy variable using a range of values based on a continuous variable. I would like to take a set of values and place them in nominal "buckets" if you will.For example the data is12451113I want take those values and id when range they fall into. So 1- 12, 13-20, etc. Any ideas?...

    dannyfinn11 dannyfinn11
    Discussions |
    Jul 11, 2020 7:53 PM
    14349 views | 9 replies

  • SAP to JMP

    Is there any way to import/export data between JMP and SAP?

    tom_abramov tom_abramov
    Discussions |
    Jul 11, 2020 12:38 AM
    11033 views | 5 replies

  • grouping process data by dates

    Hi,I'm trying to use JMP to plot out the following data in this format :For example :I have a ten year trend of a process unit which I'm analyzing. The unit is brought down once in a while for maintenance, and I would to monitor its performance across the cycles. Sometimes the cycles are fixed by timelength, or by dates (e.g. could be 6 months or 2 years). What would be the best way to process all...

    SCWong SCWong
    Discussions |
    Jul 10, 2020 12:22 PM
    1628 views | 1 replies

  • Comparing all pairs within groups

    Hi, I´m looking for some inspiration on how to approach a data set. I´m looking at demographics data for a group of people where I need to identify potential duplicate persons. Some parts of the data are accurate (birth date, sex, country) and other parts are not (height, weight). This means, that even though height & weight is not identical for two persons, they can actually be the same. So withi...

    JulieSAppel JulieSAppel
    Discussions |
    Jul 10, 2020 4:34 AM
    1632 views | 2 replies

Latest Discussions

  • [JSL Contour Plot] Method of define contour plot, number, minimum, maximum

    The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot.   Does someone have experience how t...

    Stokes Stokes
    Discussions |
    Jun 25, 2020 12:09 PM
    983 views | 0 replies

  • Impact of screen resolution on html output

    Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...

    Ole Ole
    Discussions |
    Jun 9, 2020 6:21 AM
    945 views | 0 replies

  • How do I have two different chart types in a single graph using two axis?

    While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot?    Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot.     To do this, first clear the row s...

    Bass_Masri Bass_Masri
    Discussions |
    Apr 28, 2020 4:28 PM
    3583 views | 0 replies

  • How do I calculate z-scores at different aggregation levels?

    Hello,  How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...

    Jmsouch Jmsouch
    Discussions |
    Feb 26, 2020 7:04 AM
    1629 views | 0 replies

  • Calling Windows API ImageViewer.dll to display JPG files.

    I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL.   ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...

    DMeakin1 DMeakin1
    Discussions |
    Jan 17, 2020 10:19 AM
    1486 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