Welcome to the JMP User Community!

Latest Discussions

• 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

• 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

  3860 views | 3 replies

• Is there a way for to users to work on the same JMP file?

  Hi,Is there a way for me and a collegue to work on the same JMP file in real time?We have JMP 17.  Thanks! 

  nbhagroo

  Discussions |

  Jul 25, 2023 12:28 PM

  1038 views | 0 replies

• How do I remove the "SQL" variable from the script section of my table?

  This table is created automatically by concatenating many subsets together. Each time I concatenate, an "SQL" variable shows up. I am able to delete the other scripts that come up, but I have not been able to delete this one so far. Any help is much appreciated.

  waraulston

  Discussions |

  Jul 25, 2023 11:48 AM

  1703 views | 1 replies