Welcome to the JMP User Community!

Latest Discussions

• How to properly use LAG function in Conditional Statements?

  I have this formula but it is adding the value on the same row. If( :Column 2 != Lag( :Column 2 ) | Row() == 1, :Column 1, Row() == 2 | Lag( :Column...

  UserID16644

  Discussions |

  Feb 22, 2024 5:36 AM

  1514 views | 6 replies

• How to subtract values from previous row values?

  Hi all Can someone help me how to formulate a formula that would subtract Column 2 to the previous value in Column 1? It should look like this. The co...

  UserID16644

  Discussions |

  Feb 22, 2024 4:15 AM

  2170 views | 7 replies

• Date Difference calculation referencing grouping columns

  I am trying to calculate a Date Difference in Days between the current row and the last row where a comment is non-missing. Any help greatly appreciat...

  ktbrickey

  Discussions |

  Feb 22, 2024 2:56 AM

  2824 views | 7 replies

• How to pass parameters to the specified JSL in the graph fetch?

  Examples in the index of softwaredt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); gb = dt << Graph Builder( Show Control Panel( 0 ), Variables( X( ...

  lala

  Discussions |

  Feb 22, 2024 12:55 AM

  2194 views | 11 replies

• group file name and set lable by JSL looping, work fine but slowly

  I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. ...

  BayesRabbit7133

  Discussions |

  Feb 22, 2024 12:24 AM

  470 views | 0 replies