Welcome to the JMP User Community!

Latest Discussions

• Character to DateTime Conversion Help Needed

  Hi  I am attaching a sample single row table. Date1 column is character e.g. 03-Mar-22 12.13 PMie. DD-MMM-YY HH.MM am/pm Date2 has a datetime format I need a formula for especially Date1 to convert it into DateTime w/ desired format of MM/DD/YYYY HH:MM:SS am/pm(SS, seconds would be automatically zero ) My goal is to update a table based on a second one (or join) once I can 2 comparable datetime co...

  altug_bayram

  Discussions |

  Mar 2, 2023 1:51 PM

  5967 views | 10 replies

• How to make Graph Builder use the specified row colors & markers over any other colors/markers?

  Hi there! I am having trouble with adjusting the graph builder markers and colors to match what I have customized in the JMP table. For some reason, it is showing that there are a rainbow of colors and symbols when on the table I specified only black and red for 2 distinct data sets.How can I get graph builder to:1) "clear" the default colors/symbols that are showing up in the saved graph?2) Read ...

  AU

  Discussions |

  Mar 2, 2023 12:05 PM

  4201 views | 7 replies

• Insert contents of variable/expression rather than variable name into New Script

  It would be convenient to be able to assign an expression to a variable and then use that variable to insert the expression into a data table script using New Script.  dt = New Table("test dt"); anExpr = Expr( Show("Hello world.") ); dt << New Script("hello world", anExpr); Show(dt << Get Property("hello world"));However, when I try this, the script's content is only the variable name.  It works ...

  austinspencer

  Discussions |

  Mar 2, 2023 11:26 AM

  2185 views | 4 replies

• DOE for Nested Factors

  Hello!  I'm designing an experiment with 5 factors.  Factor X1 is Ingredient Type, a two-level categorical variable (Ingredient A or Ingredient B).  But we also want to investigate the concentration of both ingredients.  Ingredient A has a range of 5% to 20%, while Ingredient B has a range of 1% to 10%.  I can't include this as three independent factors.  I see two reasonable options:- Run two seq...

  chris_rigdon

  Discussions |

  Mar 2, 2023 8:40 AM

  1881 views | 2 replies

• Bug? Excel add-in not loading combined cells properly

  In JMP 16.2, the Excel add-in doesn't merge combined cells as it happens with the Excel wizard. Let's create a table with combined cells (a common practice in Excel). [see attached] RowABCXYZ10.7762170.9834860.25715600020.9760180.9965870.68016510130.9525020.8645370.16730901040.1993490.3476250.2285311-1-150.1876440.8889050.94740700-160.4202030.4967390.786041-101 Using Excel-addin (preferences chang...

  FN

  Discussions |

  Mar 2, 2023 6:59 AM

  1467 views | 2 replies