Welcome to the JMP User Community!

Latest Discussions

• How do I do a count formula

  I have a data set that had 19 million rows.  Within that data set I want to count the number of instruments a customer has.  I have the customer data in one column and the instruments in another column.  My goal is to select customers that only have 1 instrument.   Thanks 

  VR

  Discussions |

  Jan 10, 2020 4:56 PM

  3306 views | 2 replies

• Running script from command line on MAC

  Not a mac person.  Does anyone know how to run a jsl script from command line on a mac?  I specifically mean WITHOUT "//!" at the top of it.     I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl

  vince_faller

  Discussions |

  Jan 10, 2020 2:26 PM

  1558 views | 0 replies

• Fill empty cells with last valid value

  Hello, I have the following problem. My dataset is composed by a list of rows, each representing one item produced by a machine. Normal items are not measured, but from time to time some "measurement items" are produced and the propetries measured. The assumption is that all the parts not measured will have properties similar to the latest measurment. How can I fill the empty cells using this logi...

  lburtone

  Discussions |

  Jan 10, 2020 7:53 AM

  15960 views | 4 replies

• XBar Chart not Calculating or Displaying UCL and LCL Correctly

  Hi, I'm a JMP 10 user. I can't figure out why my XBar charts are not calculating or displaying the UCL's and LCL's correctly. Here's my script and a snip-it of what the charts look like. I'm not sure if something strange is going on with my data set or my script. Thanks.  Control Chart( SendToByGroup( {:Category == "A"} ), Sample Label( :Name( "Date" ) ), KSigma( 3 ), Chart Col( :Process, XBar...

  Raquel

  Discussions |

  Jan 9, 2020 7:13 AM

  5198 views | 4 replies

• What's wrong with below code

  I've got errors on below code: dt << New Column( "Stage", If( Formula( Substr( :Column 9, 1, 2 ) ) == "CP", Formula( Left( :Column 9, 3 ) ), " " ) );   I want to add a new Col named "Stage" besides a raw Column 9, if starts with CP get the 1st 3 letters else blank, but I've got errors    Unexpected end of input. Perhaps there is a missing "," or ")".
  Trying to parse arguments of function "New...

  jerryspilTC

  Discussions |

  Jan 8, 2020 4:42 PM

  2845 views | 2 replies