Welcome to the JMP User Community!

Latest Discussions

• Combining Date Column and Time Column to Create Timestamp

  For a data table with a date column and a time column, I create a new column that uses the formula Date + Time to create a timestamp.  However the formula seems to work inconsistently where some of the timestamps result in being 4 YEARS previous than what they should be.
  
  DateTimeTimestamp (formula)2021 - 10 - 0112:05 AM10/01/2021 12:05 AM2021 - 10 - 236:59 PM10/23/2017 6:59 PM2021 - 11 - 077:45 PM1...

  user8421

  Discussions |

  Feb 17, 2022 12:16 PM

  2753 views | 3 replies

• Remove the "Where" from Window and Change grouping column names

  I am looking to remove the "Where..." from my window, but it does not work as I thought it should. I tried the same method that does work for graphs (as noted by @txnelson).I am guessing it's just a simple naming convention issue? I am also trying to rename my table's grouping column :Identity to "Phase". nw =New Window("window title", V List Box( tb = concat<<Tabulate( Change Item Label(G...

  Raybob

  Discussions |

  Feb 17, 2022 9:54 AM

  1349 views | 2 replies

• Random vs Fixed Blocking Factor in DOE

  Hello All,
  
  I am trying to setup a custom DOE experiment where I am evaluation 4 continuous factors with 1 response. I have a limit of 30 runs and am interested in main effects (later I would like to do two-way interactions as well if possible). I set this run up but because these 30 runs have to be split over two imaging platforms I use a blocking of two with 15 runs per. I tried with a fixed block...

  Ekarshalev

  Discussions |

  Feb 17, 2022 8:36 AM

  4588 views | 3 replies

• Application Builder - How to maximize and restore tabs like in dashboards

  Hello everyone,
  I have created an application using the application builder and I am having trouble with the implementation of a feature. When creating a dashboard, each report window has the possibility to be maximized ("Maximize Tab") and then restored to its original dimensions ("Restore tab") using the top right icon. I can't manage to do it in the application builder ... and I suspect that it ...

  Steph_Georges

  Discussions |

  Feb 17, 2022 6:06 AM

  1019 views | 1 replies

• Formula for trimmed mean

  I have a data set that has a sample number in the first column, and then 180 columns of various measurements of the sample. I want to get the 5% trimmed mean for each of 100 samples in the table.Because of the large number of samples, going through Distributions > Summary Statistics is very impractical. Is there a way I can pull this directly using a formula? Alternatively, I could stack my column...

  HarriBradbeer

  Discussions |

  Feb 17, 2022 12:57 AM

  4454 views | 7 replies