Welcome to the JMP User Community!

Latest Discussions

• How to color/marker selected rows based on multiple selection criteria?

  Hi,I am writing a script that is able to color and mark selected rows. Let's take the Big Class table as an example. The following is my script, can anyone help out to get the selected rows to be colored to specific color like "Blue" and able add different marker for age =12 and age=13. Open( "$SAMPLE_DATA/Big Class.jmp" );  For Each Row( Selected(Row State()) = And ( Or (age == 13, age ==12), sex...

  bernie426

  Discussions |

  Nov 10, 2015 7:29 AM

  11980 views | 2 replies

• How to stop users from resizing windows in JSL?

  This might seem like a very simple question, but I was wondering, is there a way to stop users from re-sizing windows/dialogs using JSL?There is a message you can send to a display box for auto stretching, min and max size, etc. Is there any flag for turning off the user capability to resize windows by default (i.e. mouse cursor doesn't show the resize arrows when hovering on the edge of a window?...

  nkelleh

  Discussions |

  Nov 9, 2015 8:04 AM

  14824 views | 7 replies

• How to calculate Cpk?

  In most of JMP reference books from sas , how to calculate Cpk? we are told that1. If data are normal or similar to normal distribution, then go it from analysis>distribution> capability2. If data are non normal distribution, in analysis>distribution, detect what its distribution is? then calculate Cpk corresponding to identified distribution, analysis>distribution>capability, and select its corr...

  mujahida

  Discussions |

  Nov 8, 2015 4:08 PM

  29828 views | 1 replies

• How do I look for a blank cell with an if statement?

  Hi,Does anyone know if there's a way of assigning a blank cell in an if statement?I want to make a column with a formula that either uses the value from column 2, if one exists, or the value from column 1 if the cell in column 2 is blank. I tried to achieve this using the following formula for column 3:If( :Column 2 > 0,:Column 2,:Column 1)but if column 2 doesn't contain a number then the resultin...

  stephaniejlucas

  Discussions |

  Nov 6, 2015 12:57 AM

  25809 views | 4 replies

• Missing Values/Calculations

  
  I have a data table in which I want to add the row values of four columns into a fifth column.  However, I have missing values in all four original columns and that is OK, but when I apply the formula to add the four columns, all I get is a column of missing values because JMP will not add three values and a missing value.  What can I do to remedy this situation?

  Steven_Moore

  Discussions |

  Nov 5, 2015 6:52 AM

  14888 views | 3 replies