Welcome to the JMP User Community!

Latest Discussions

• Individual and Moving Range Chart

  I am trying to create an individual and moving range chart by date on the x-axis. I know it is possible given the following article. Control Charts or SPC are easy in JMP 10 with Control Chart BuilderHowever, I am unable to "drop" the dates on the x-axis. Everytime I try, JMP assumes that I am placing it in "subgroup" and converts to an Xbar and R chart. Does anyone know where I need to drop my da...

  chuang

  Discussions |

  Jul 16, 2013 1:32 PM

  7522 views | 9 replies

• How can I automate random row selection?

  Hello All,I'm pretty new to JMP and even newer to JSL. I'm trying to write a script that subsets a number of rows based on the following specifications: if the original table has 1-15 rows, then the subset  of the original table is 2 rows, if the original has 16-25 then the subset of that table is 3 rows, if the orginal has 26-90 then the subset table is 5 rows, etc. Basically just a script to aut...

  danielsh

  Discussions |

  Jul 16, 2013 8:25 AM

  9287 views | 2 replies

• removing duplicate items in a table

  Hi All,i have a table with ~20 columns and about 500 rows, two of these columns are Serial No. and Time stamp, and the rest is miscellaneous measurment data.in some instances i have rows of data that have the same Serial No. but all other values are different.my goal is to write a script to clean up the data table so that only rows with unique Serial No. are left.I want to first select items with ...

  bk

  Discussions |

  Jul 15, 2013 9:39 AM

  12937 views | 3 replies

• JMP formula : Missing value

  JMP formula : Missing valueHi there~ ^^Could you do me a favor? Do you have any idea with this? I think this is a simple question, but I dont know yet.I want to select "Missing continous value" in formula.I wanna change missing continous values to "Unknow" with character value.

  Steve_Kim

  Discussions |

  Jul 10, 2013 3:49 PM

  13465 views | 2 replies

• How to find and delete rows in a data table containing a text (or elements in a list)

  I have a list containing a combinations of letters ... e.g A B C D...Column1ABCDABACADABCABD..... so forth or as a list e.g. mylist = {A, B, C, D, AB, AC, AD, ABC, ABD....}.While it is possible to find those cells starting with "AB" using Edit-Search-Find from the table menu, it is strange I cannot find a way to do this using JSL script.I would imagine something like:loc (mylist,"AB?") for a list ...

  woongkim79

  Discussions |

  Jul 9, 2013 10:29 AM

  9752 views | 2 replies