Welcome to the JMP User Community!

Latest Discussions

• 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

  1176 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

  907 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

  2712 views | 6 replies

• Adding custom marker and colors to GraphBuilder in JSL

  Hello, I am trying to add color/markers to row states through Flags mentioned in a particular column. For instance, working on the Cities dataset, I created random flags (5 different classes of flags) for few rows, and most are empty. Now, the majority of those values are plotted with a single black dot, I am fine with it. But, the major issue arises, when I try to create an individual value plot ...

  Kenobi

  Discussions |

  Jul 25, 2023 12:48 PM

  2195 views | 3 replies