Welcome to the JMP User Community!

Latest Discussions

• Redo - for a Report in a Dasboard?

  Redo Analysis from the the red triangle/Redo menu is great.It generates an exact copy of the current report. Is there also a possibility to get an exact copy of a report (e.g. Graph uilder Plot ) that is inside a Dashnoard?
  - including the filters that were applied by the surrounding dashbord?

  hogi

  Discussions |

  Jul 26, 2023 1:43 AM

  565 views | 0 replies

• 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

  1767 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

  1175 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

  2311 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

  906 views | 1 replies