Welcome to the JMP User Community!

Latest Discussions

• Different icons for JMP Files

  Hi Guys,   I recently had someone work on my computer, previously all the different JMP files, such as Scripts, Journals and Data tables had different icons when they were sitting in my working folder, since the work was done all these have the same icon and are very hard to identify unless i look at the extension, and everytime l click on one it reopens JMP,  so i may reopen JMP several times in ...

  Mickyboy

  Discussions |

  Sep 25, 2024 7:18 PM

  3920 views | 6 replies

• Changing colors in compare means analysis

  Hi, Comparing multiple groups and hitting the "compare all means."I always find it challenging to understand which circle belongs to which group.I tried color-coding the groups, but I still can’t get the circles to change their colors. I know JMP is programmed to indicate statistically significant groups by marking red vs. gray, but that is not helpful to my purposes. I copied the picture and over...

  Shahar_JMP

  Discussions |

  Sep 25, 2024 10:01 AM

  2270 views | 2 replies

• JSL- Formula for calculating column average for last x rows per ID

  I am trying to create a column formula to calculate the average for the last 30 sets of data per cycle run (shown in the example below):I have been able to achieve this, however I would like to be able to calculate the average per "ID" rather than the entire data set per test cycle. The formula I have used is shown below:If( Row() == Col Max( Row(), :Cycle ), Mean( As Column( "Output, mV" )[Index...

  AvgLlama27

  Discussions |

  Sep 25, 2024 8:00 AM

  710 views | 1 replies

• Fit Spline for multiple columns and saving predicted values

  Hi all,    I have a lot of different columns from an FTIR spectra experiment, and in order to correct the baseline, I need to perform a Fit Spline on each column (one column = one spectra). I would like to do this automatically using JSL, so I don't have to save hundreds of "Predicted values" by hand.  I tried to create a code but somehow it doesn't want to save the values or put 0 in each columns...

  LGaspard_98

  Discussions |

  Sep 25, 2024 5:10 AM

  1292 views | 2 replies

• How to write a formula that counts number of rows that are not excluded?

  I am trying to write a simple formula that will count the number of rows in my datatable that are not excluded. I want the total to be updated as I change row states using the graph builder. In another part of the formula I was able to successfully use the Excluded () function, e.g.  <jsl> X = Col Sum( :MG1_2520_LH_Setting, Excluded() ); However, I am using N Rows() to count the total number of ro...

  BrianB

  Discussions |

  Sep 24, 2024 7:58 AM

  1795 views | 4 replies