Welcome to the JMP User Community!

Latest Discussions

• Recode using if and count functions

  Hi, I am relatively new to JMP and I am struggling to combine different functions using recoding functions and I would appreciate your help. I have a date table with one column containing plate numbers. Each Plate ID has a repetitive set of Names T0X, T0Y and T0Z associated. Now I want to recode X, Y and Z into numbers, starting from X =1, Y = 2 and Z = 3, and going on in steps of three (X = 4, Y ...

  AGB

  Discussions |

  Mar 19, 2021 2:33 AM

  1677 views | 2 replies

• Change color theme in plot legend of FIt Curve

  I am doing a fit curve and would like to alter the color theme of the plot of grouped lines. I can't find syntax to be able to do this. I found some links to XPath work for doing something similar in graph builder ( {legend box ref }<< Categorical Color theme() ) but that doesn't seem to work in the fit curve report. Grabbing the XML, it wasn't clear if needing a different node was my issue...
  
  Here...

  nathan-clark

  Discussions |

  Mar 18, 2021 1:08 PM

  2395 views | 4 replies

• Filtering Pareto charts by column.

  I have a very large dataset of manufacturing defect bin data.My columns are the manufacturing batch IDs (called lots), and then each column is a defect bin, with the numeric value for that particular defect bin for each lot. In JMP Pareto chart, the input needs all defect bins in one column. So, I have to make another table by stacking those defect bins using Table>Stack. This makes an even larger...

  spoikayil

  Discussions |

  Mar 18, 2021 12:53 PM

  1903 views | 2 replies

• Adding x number of days to a Character Date column (dd-Mon-YYYY)

  I have a JSL script that periodically pulls data from an Access database.  The access database contains a date column "Available Date" with a dd-Mon-YYYY (E.g., 12-APR-2018) format. What I am trying to do, is create a new column "Target Date" in JMP that adds x number of days to the date in "Available Date" for each row. For example: In the image below, the Target date is equal to Available date +...

  DanAlexander

  Discussions |

  Mar 18, 2021 12:25 PM

  4924 views | 3 replies

• How do I extract only the text that is between quotation marks

  I have a column containing 1000's of Machine Error Codes which are typed in by an operator at the machine.Most of the errors do not have quotation marks but for those that do I would like to be able to extract what is between the quotation marks.For other special characters I can use the escape character but I'm having problems using this with the quotation marks.Thanks in advanceFiona Example 1: ...

  fionaweston

  Discussions |

  Mar 18, 2021 10:11 AM

  2986 views | 2 replies