Welcome to the JMP User Community!

Latest Discussions

• Filling partially missing data cells based on non-missing cells

  Hello, I'm trying to figure out a way to fill in missing cells that should have values that are based on other cells. In my table, some of these cells are properly filled in, while others aren't. Here's a rough example Column 1Column 2Column 31aa'2bb'1aa'3cc'2  3  1  3cc'2   In this example, every row that has a '1' in the first column should have an A, and then an A' in the 2nd and 3rd column, re...

  KMJHU

  Discussions |

  Jul 18, 2019 1:02 PM

  1752 views | 2 replies

• jsl: how to combine multiple report in one

  Hello,Since my last question a few days I have come a little further with my script.To complete the first step I would like to combine the reports (in 3 Windows) in one Report (1 Windows).How can I do this ... See line 51 ffAnd how can I save this Report automaticly named by data_file name (first 10 characters) AND _Baseline (if select more than one Month) OR _Monthly (with selected Month)? ... se...

  uwe_hiss

  Discussions |

  Jul 18, 2019 1:22 AM

  15046 views | 4 replies

• Add multiple columns by scripts

  Hello, I wonder to add multiple columns on the defined data table. If column has already existed, then the script could ignore the column and continue to add the rest ones if not existed until the implemented.I worte a script here. But the issue is even the column existed, the script still add duplicated column in the data table. Could you help to address this issue? Appreciate it!Names Default To...

  Adam_Xu

  Discussions |

  Jul 17, 2019 6:36 PM

  4356 views | 4 replies

• Breaking down time of day into shifts

  Hello,    I have time data that I would like to breakdown into shifts to analyze shift patterns 
  9:00PM-5:59AM = night shift 6:00AM-11:59AM = morning shift 12:00PM-8:59PM = afternoon shift     Can anyone provide any guidance on how to do this with a formula or script? I'm a beginner and am just using recode which is very slow. 

  lizrdee

  Discussions |

  Jul 17, 2019 4:09 AM

  4165 views | 4 replies

• How to Maintain JMP legend layout when copying and pasting graphs into Word/PPT?

  Since updating to JMP 13 I have not been able to maintain legend formatting when copying a graph into word or powerpoint. Attached is an example of how in JMP the legend will be formatted how I prefer and then after copying and pasting into word the legend usualy reverts to containing every possible item in the legend instead of only the items I selected. Thoughts on what might be going on?  

  Joseph_Reese

  Discussions |

  Jul 17, 2019 12:28 AM

  15681 views | 7 replies