Welcome to the JMP User Community!

Latest Discussions

• Convert numeral to letter in adjacent column

  Hi, hopefully this isn't a dumb question, I'm new to JMP and coding generally. In JMP 18, if I have a column of numerals (0-11) and I want a second column that correlates to this column with letters (a-k) is there a simple formula command I could use to make the second column auto-populate with the corresponding letter for every numeral associated in the adjacent column? 0 = a, 1 = b, etc.  Thanks...

  graphical

  Discussions |

  Dec 4, 2024 9:59 PM

  779 views | 2 replies

• Column Formula to Determine Test Order for Repeated Samples

  Attached is JMP file and want to replicate the Test Order column with column formula. Test Order column is based on SerialNo and TransactionBegDtm across multiple LotNo. Goal is to know if the SerialNo tested 1st vs 2nd based on TransactionBegDtm. I tried formula below, but was not able to get the correct matching sequence. dt = Current Data Table();dt << New Column( "Duplicate", Formula( Col Cumu...

  VT23

  Discussions |

  Dec 4, 2024 3:18 PM

  739 views | 2 replies

• help to get R squared predicted

  Hello!I installed a script from a community response regarding the calculation of R²pred, as shown in the image below (I'm using JMP 18 pro): (link da resposta do @erich_gundlach https://community.jmp.com/t5/JMP-Add-Ins/Predicted-R-square-calculator/ta-p/39927)  In PRESS, R²pred didn't appear. (Press is low because I haven't reduced the model yet, don't worry =))  I really need to show these R²pre...

  ivanpicchi

  Discussions |

  Dec 4, 2024 10:21 AM

  480 views | 0 replies

• Currently the Tables "Update" menu item is grayed out in JMP PRO 18

  Is anyone running into the issue where the tables "update" menu item is grayed out and not usable?

  NormalityBird81

  Discussions |

  Dec 4, 2024 9:47 AM

  1023 views | 4 replies

• Custom function with varying number of input columns?

  Hi, is it possible to define a custom function which works for 2-5 selected columns?
  
  Add Custom Functions( New Custom Function( "custom", "concat", Function( {col1, col2, col3=., col4=., col5=.}, If(not (is missing(col 4)), Char(col1) || "_" || Char(col2)|| "_" || Char(col3)|| "_" || Char(col4)|| "_" || Char(col5), not (is missing(col 4)), Char(col1) || "_" || Char(col2)|| "_" ||...

  hogi

  Discussions |

  Dec 4, 2024 8:14 AM

  1026 views | 4 replies