JMP User Community

Latest Discussions

Remove Duplicate rows using Timestamp

Hello, I have a sample data table attached wherein I am looking to remove duplicate rows within the data set using the TimeStamp,Tool columns.Criteria for duplication:Timestamp that are within 6mins on the same tool are considered as duplicates and those rows have to be removed.Can someone help how this can be achieved in JSL? Thanks! @txnelson
psundar6

Discussions |
Oct 17, 2021 3:52 PM

3823 views | 5 replies
How to Get Consistent Font Size on Y axis scale

Hi - I am using Graph Builder to plot the following using JSL. Given the data is dynamic, I am not hard coding any axis/scale settings. Percentage value is set to 3 digits after decimal point though. Is there a way to fix the font size in the example below? I would like to have same font size on Y axis scale. Thanks!
uProf

Discussions |
Oct 17, 2021 11:54 AM

1448 views | 1 replies
How to convert a numeric column to a date column correctly?

Hi,I have a date column in the format "yyyymmdd". An example date looks like this: 20000111. When I import data from a csv into JMP, this column is treated as numeric, continuous. I set its format to be date-yyyymmdd and realized that it was treated as 20000111 seconds past 1904/1/1. I changed the column to character, nominal and tried to use informat() to convert it but just cannot get it to work...
jieli

Discussions |
Oct 16, 2021 8:38 PM

6819 views | 4 replies
Looping x,y locations over time

Hello, I'm fairly new to jmp (currently using jmp 16) and have a question about the following scenario. I have a csv file that has the following columns for each imperfection: - Timestamp, serial ID, x location, y location, size of imperfection (in mm) I work with a cleaning process and the inspection tool gives information for every single imperfection in the day. There are a couple of things I...
SEG

Discussions |
Oct 16, 2021 5:38 PM

5769 views | 9 replies
Identifying Titles of Graph Builder Page Titles

In the following graph, I want to be able to identify the page titles: i.e. "sex = F" and "sex = M". Looking at the display tree it would appear that the titles are associated with a display box of type GraphBuilderGroupBox: I have the following script: Open("$SAMPLE_DATA/Big Class.jmp"); gb = Graph Builder( Size( 378, 714 ), Show Control Panel( 0 ), Show Legend( 0 ), Variables( X( :hei...
David_Burnham

Discussions |
Oct 16, 2021 5:13 AM

3669 views | 5 replies

Previous
Next

Latest Discussions

How to convert a numeric column to a date column correctly?

Hi,I have a date column in the format "yyyymmdd". An example date looks like this: 20000111. When I import data from a csv into JMP, this column is treated as numeric, continuous. I set its format to be date-yyyymmdd and realized that it was treated as 20000111 seconds past 1904/1/1. I changed the column to character, nominal and tried to use informat() to convert it but just cannot get it to work...
jieli

Discussions |
Oct 16, 2021 8:38 PM

6819 views | 4 replies
Looping x,y locations over time

Hello, I'm fairly new to jmp (currently using jmp 16) and have a question about the following scenario. I have a csv file that has the following columns for each imperfection: - Timestamp, serial ID, x location, y location, size of imperfection (in mm) I work with a cleaning process and the inspection tool gives information for every single imperfection in the day. There are a couple of things I...
SEG

Discussions |
Oct 16, 2021 5:38 PM

5769 views | 9 replies
A time series (seasonal ARIMA) model for varying variability in different seasons

Is there a time series ARIMA model that can represents increased variation (expand confidence intervals) in values during one season? As an example, attached is a data set showing the number of deaths in the United States. A time series analysis of deaths prior to March of 2020 (settings below) gives a reasonable prediction of deaths, however its accuracy is reduced during Dec - Feb (flu season...
ih

Discussions |
Oct 15, 2021 6:13 PM

3117 views | 4 replies
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

940 views | 0 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

2098 views | 2 replies

Previous
Next

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

940 views | 0 replies
non-parametric response screening

I love the response screening platform. Is there a way to choose the fit y-by-x model to be non parametric, so i can compare non-normal distributions? is that the Huber/cauchy options?thanks
ezorlo

Discussions |
Oct 11, 2021 1:03 AM

824 views | 0 replies
JSL: Saving multiple chart and auto fit each of them into 1 page

I have created a Window with V List Box which contained multiple Variability Charts and tried to save them into 1 pdf. What i want to achieve is saving and auto scale each of the Variability Charts into 1 single page of pdf. Can anyone help to advise how to do that? Much appreciated!nw = New Window( "taskQueryCharzCurrent - Variability Chart of current", V List Box( Variability Chart( Y( :cu...
giin

Discussions |
Oct 7, 2021 6:42 AM

1043 views | 0 replies
Skip Lot Sampling Plan

Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam
AT

Discussions |
Sep 10, 2021 10:38 AM

1238 views | 0 replies
Time values in xls or xlsx, csv, and JMP

Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...
fliew0410

Discussions |
Sep 7, 2021 7:25 AM

1188 views | 0 replies