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

  • N missing values/empty cell

    Sometime in my test product data, there are certain test whereby the product is not being tested. When I query from database, the result is empty though the category still appear hence I am getting the dark dot in JMP. Is there any way (beside exclude) whereby I can easily identify and remove those empty cell in every column. Thank you.

    adam adam
    Discussions |
    Oct 12, 2017 5:03 PM
    20337 views | 4 replies
  • Any standardize function by subset

    Hello,I have three columns:  Population, Year and Type. I need to write the Z score value of the population in a new column. This standardization applies for each subset (Year + Type). Until now, I've used the distribution platform with «BY Year» and «BY Type» and saved the normalized data (red triangle menu, Save standardized value).Since I have to update my table often, these values have to be r...

    claude_bellavan claude_bellavan
    Discussions |
    Oct 12, 2017 12:40 PM
    10992 views | 3 replies
  • Adjusting variables on Graph builder automatically

    Hi All,   I have created a final table which has a bunch of columns. The data I want to plot start from 35th column every time. The number of columns I want to plot keeps varyign with every iteration. It could vary from 1 column to many columns.   What is the best way to plot with variables continuously changing?  Is there a way to change the type of plot using an external variable like "plot_type...

    vishwasanj vishwasanj
    Discussions |
    Oct 12, 2017 12:10 PM
    5607 views | 3 replies
  • How to report box plot averages on a graph

    I am trying to analyze 5 different set of data each with 4 replicates. I have plotted each set of the data as box plots, I am looking for a way to report the average for each box plot and have it show up next to each plot. 

    jlogan jlogan
    Discussions |
    Oct 12, 2017 8:43 AM
    6707 views | 1 replies
  • Formula for Grouping months by season

    Hi,I thought this was a rather simple formula to create, but found myself receiving formatting errors.I have a column, character type, that contains months (October, November, December, and so on...).  I created a new column called "season" and wrote an IF(Contains(...formula to claasifiy if the month is October Then = fall,  and so on through the list creating the 4 categories (summer, winter, sp...

    Onjai Onjai
    Discussions |
    Oct 11, 2017 6:52 AM
    8824 views | 5 replies

Latest Discussions

  • Adjusting variables on Graph builder automatically

    Hi All,   I have created a final table which has a bunch of columns. The data I want to plot start from 35th column every time. The number of columns I want to plot keeps varyign with every iteration. It could vary from 1 column to many columns.   What is the best way to plot with variables continuously changing?  Is there a way to change the type of plot using an external variable like "plot_type...

    vishwasanj vishwasanj
    Discussions |
    Oct 12, 2017 12:10 PM
    5607 views | 3 replies
  • Selecting specific columns and concatenating

    Hi All,   Right now, I open a bunch of data tables and put it in a list called datalist.   For(i = 2 ,i <= N Items(datalist) , i++, fdt = datalist[1]; fdt<< Concatenate(Data Table(datalist[i]),append to first table(1)); close(Data Table(datalist[i]),nosave); ); fdt << set name( "Final_Table");     This concatenates everything and it takes a lot of time when I try to concatenate 100's of tables to...

    vishwasanj vishwasanj
    Discussions |
    Oct 10, 2017 1:30 PM
    6444 views | 3 replies
  • Using Graph or GraphBox - How to change X,Y axis increment & Reverse axis

    Hello,I am trying to use the Graph function but am unsuccessful in making X-axis incremements of 1 and Reversing Y-axis order.  I tried swapping the numbers in the Y Scale properties but no luck. Only way to change is to physically change graph manually. Still unable to figure this out using JSL.  Any help is appreciated! Here is a snippet of my code New Window( "Map",
    Graph(
    Frame Size( 800, 800 ),
    ...

    alexbnieto alexbnieto
    Discussions |
    Oct 5, 2017 3:04 PM
    3800 views | 1 replies
  • Change the X axis label orientation to be angled as a default

    Hello again,For "fit Y by X", Is there a way to change the X axis label orientation to be angled as a default, instead of me needing to change it every time?Thanks again.

    ileshem ileshem
    Discussions |
    Oct 5, 2017 11:37 AM
    2661 views | 1 replies
  • vlookup in JMP

    Hi, anyone know how to do vlookup in JMP?

    Discussions |
    Oct 4, 2017 3:11 PM
    2934 views | 1 replies

Latest Discussions

  • Cox Proportional Hazard - adjusting risk ratio with std dev

    I'm working with someone who is using SAS and I'm trying to do the same analysis in JMP.  When I  questioned their hazard ratio they said it was adjusted by the standard deviation. They commented:In order to obtain results in units of 1 standard deviation – you simply get the standard deviation value for parameter of interest and introduce it in the PH regression statement, for example:proc phreg ...

    Maureen Maureen
    Discussions |
    Aug 22, 2017 1:18 PM
    3362 views | 0 replies
  • JSL How do I wrap the title text of a OutlineBox?

    Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...

    AlexanderKrebs AlexanderKrebs
    Discussions |
    Jun 13, 2017 5:38 AM
    4381 views | 0 replies
  • Printing worksheet with cell colors

    Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors.  Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

    Thanks.

    ferdt58 ferdt58
    Discussions |
    May 16, 2017 9:14 AM
    2159 views | 0 replies
  • Linearity and Bias Report

    In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%.  We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.

    Aravindan Aravindan
    Discussions |
    Apr 18, 2017 12:54 AM
    4260 views | 0 replies
  • CCC Optimal

    Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,

    Lamine Lamine
    Discussions |
    Mar 17, 2017 5:25 AM
    3313 views | 0 replies
view all discussions