Welcome to the JMP User Community!

Latest Discussions

• Preserving JMP Data Table Hyperlinks when Tables are Saved in Excel Format

  At the risk of blasphemy, I am trying to figure out how to save a table that has hyperlinks for all data in a column in an Excel file, where the hyperlinks are still functional. I pull a lot of Excel data into JMP for faster data analysis and can add hyperlinks to entries in JMP columns. I can save the resulting charts as picture files and raw data files that can be read in Excel, but would also l...

  JensRiege

  Discussions |

  Oct 15, 2021 3:39 PM

  746 views | 0 replies

• 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