Welcome to the JMP User Community!

Latest Discussions

• JSL - Calculate Mean of Last 3 Rows Per Date

  I have a data set where I'd like to calculate the mean of the last 3 observations for each date and have that value be in its own column and paired with the last date as shown below. Names Default To Here( 1 ); // Create an example data table dt = New Table( "Date", Add Rows( 30 ), New Column( "Date", Numeric, "Continuous", Format( "m/d/y", 10 ), Set Values( [3713817600, 3713817600, 371...

  terapin

  Discussions |

  Oct 15, 2021 9:36 AM

  2451 views | 4 replies

• Index Linest Formula of Excel In JMP possible?

  Hi All,  I would like to know that possible to create the Index + Linest formula using JMP formula? Example of data table:TempMotor TempExchaust Temp135.635.2235.934.8334.934.2 With the index + Linest formula, i would like to get coef1,coef2 and coef3 results as attached in the excel file example.  Final result as shown in Result column (-2.7619,196.1429 and -3447.1581).  ResultExcel FormulaCoef1-...

  dexue

  Discussions |

  Oct 15, 2021 8:31 AM

  1593 views | 2 replies

• Help with adding chart/graphic exporting commands to JSL script: high resolution, vector format

  Hello, Is there relatively simple scripting language I can add to my bar chart JSL file as a novice JSL user that will export to a high resolution, vector format...preferably without all the "extra stuff" that comes with the selecting and copy/paste approach I currently use? I paste to Illustrator which works ok, but I still have to do a lot of clean up in Illustrator including (but not limited to...

  ReneeBay

  Discussions |

  Oct 15, 2021 8:18 AM

  1803 views | 5 replies

• Eliminating Empty Space in HTML when converting from Jmp Journal

  Hi -   I need some guidance to eliminate empty space observed between plots in HTML file when it is converted from a journal.   I am using the following JSL code. Journal looks as expected but HTML has spacing between plots and table. Names Default To Here( 1 ); bigClass = Open( "$SAMPLE_DATA/Big Class.JMP" ); dt = Current Data Table(); nw = New Window( "BigClass", <<journal, vlb = v List Box() );...

  uProf

  Discussions |

  Oct 15, 2021 7:53 AM

  1492 views | 4 replies

• Pass Command-Line Input Argument to OnOpen

  Hello,I would like to select rows in a table based on command-line input parameter/arguments when opening *.jmp files. For example, in a Windows environment, I would like to run "$SAMPLE_DATA/Big Class.jmp 2 5 9" and have OnOpen script to retrieve the "2 5 9" arguments and interpret them to be a matrix [2, 5, 9] for an input to the "Set Select Rows" function. Any thoughts or alternative ideas woul...

  Technician

  Discussions |

  Oct 15, 2021 4:52 AM

  1511 views | 2 replies