Welcome to the JMP User Community!

Latest Discussions

• How to get date yesterday?

  I would want to get the date yesterday, I am using the today () functiondateNow = Format (Today(), "m/d/y");However, I don't know how to derive from dateNow the date yesterday. Tried using d = (dateNow - 1);but is not working.

  UserID16644

  Discussions |

  Jul 26, 2023 1:21 AM

  2879 views | 2 replies

• Rename column Max(Max(date))

  How to rename column Max(Max(date)) to "date"? I tried:1. :Max(Max(date)) << Set Name ("date");2. :Name (Max(Max(date)) ) << Set Name ("date");3. Column( dt, Max(Max(date))) << Set Name( "date" );3. Column( dt, :Name (Max(Max(date))) ) << Set Name( "date" ); But none of these works 

  UserID16644

  Discussions |

  Jul 25, 2023 10:11 PM

  2115 views | 2 replies

• how to change variable in multiple JSLs at once

  Hi, I use include() to run multiple JSLs in each JSL I have variable "todaydate". However, now I want to run all the JSLs using include, but change the todaydate across all JSLs to 03Jun2023. How I can do that ? todaydate = Format date( Today(), "ddmonyyyy" );
  
  I was thinking:
  todaydate = "03Jun2023";  // this will replace in all 10 jslinclude(jsl1);include(jsl2);...include(jsl10);

  dadawasozo

  Discussions |

  Jul 25, 2023 4:18 PM

  3829 views | 5 replies

• Identify lowest 5 sequential rows byVar

  Suppose I have a table of RunNumber (1,2,3...) and Result (numeric/continuous). How can I create a formula column that identifies (e.g. with a "1") the sequence of 5 Result numbers with the lowest average value for each RunNumber, and a "0" everywhere else?

  BHarris

  Discussions |

  Jul 25, 2023 3:58 PM

  1495 views | 1 replies

• Select where with hide and exclude does not work in a for loop

  Hello community, I want to be able to use the for loop to update row exclusions, but when I use it, all the rows get hidden/excluded. Would appreciate any help. // This works dt << select where( :Flag !=""); dt << hide and exclude; // This does not work For( i = 1, i <= N Items( hides ), i++, dt << select where( hides[i] !=""); dt << hide and exclude; ); // Neither does this dt << select where...

  Kenobi

  Discussions |

  Jul 25, 2023 2:25 PM

  4712 views | 6 replies