Welcome to the JMP User Community!

Latest Discussions

• How to Get Row Number When There is Missing Data

  There is missing value in my data.I'm trying to create script for new column 'Row Number' to get row number of lagged value of Col1(non-missing data).I'm facing problem when missing data is encountered.Below is my data with required row number outcome.How to create script for this? Row#Col1Row Number(outcome)111 218133424 35 36 372038 79 71024711141012171113 1214 12151612162515      

  bzanos

  Discussions |

  Sep 25, 2020 5:18 AM

  2117 views | 2 replies

• Color cells and points discretely

  I have a column with continuous data (millimeters) and I would like to color the cells according to spec and warn limits. The coloring should be discrete, not continuous. When creating a plot using Graph Builder, the points should be colored in the same way as the cells.This is the desired coloring:< -4: red>= -4 and <-2: yellow>=-2 and <=2: green>2 and <=5: yellow>5: red I tried using the column ...

  JWi

  Discussions |

  Sep 25, 2020 2:44 AM

  2750 views | 2 replies

• Wilcoxon Sign Ranked Test - JMP OUT PUT

   Hi,  So I am doing Wilcoxon Sign Ranked test and I am not understanding what JMP is doing for where it says test statistic. I understand its using the "Pratt method" and this is the formula S = R+ - 1/4[(N(N+1)-do(do+1)]but could you expand on this a little further as I am not getting the same thing as what JMP is gettting. where my values are :R+ is 1527,my sample has 76 pairs,and 11 0's. I try ...

  rlw268

  Discussions |

  Sep 25, 2020 1:45 AM

  4273 views | 3 replies

• Label Offset for MarkerSeg

  I need to have a label offset for all my labels (if I choose to label a row) on my plots.So, I have 8 plots through "Group X". In each plot I have exactly 30 points.I'm trying to do the following:rgb = Report (gb); For( i = 1, i <= 8, i++, frame = (gb << report)[FrameBox(i)]; seg = frame << Find Seg( Marker Seg( 1 ) ); for(j = 0, j < 30, j++, seg << label offset({j, 10, -60} ) ); );  But it doesn...

  miguello

  Discussions |

  Sep 24, 2020 5:46 PM

  1448 views | 1 replies

• Check column name if existing

  Hi,I have a list of column names that I need to check from my table if it exist.How will I check every columns of the table and prompt an error and stop the program from running if it is not existing? col_list = {"Col1", "Col2", "Col3", "Col4", "Col5" }; //checks column if exist

//..code continue running
//if column doesn't exist
//..code will stop script & error prompt  

  UserID16644

  Discussions |

  Sep 24, 2020 5:30 AM

  4435 views | 5 replies