JMP User Community

Latest Discussions

Filtering and plotting data

Hello, I would like to plot and identify outliers within say three different batches. Each batch contains about 80 values. What would be a good way to plot and highlight the outliers between these 3 batches? I thought maybe using the Animation feature in the local data filter to walk through the comparison would work, but I have a feeling that there's a better way. Here is an image that I was at...
ndowidar

Discussions |
Feb 11, 2022 10:28 PM

1563 views | 3 replies
File Saving and Overwriting

I have a JSL scripts that opens and closes serval sheets. While they're open, it merges the documents into a single file, then saves the file into a local folder. The script currently overwrites the existing file in the local folder. Is there a script that would populate a new file in a subfolder (ideally, distinguished by tagging the a timestamp of creation onto the title "Merged") every time the...
Arocha1

Discussions |
Feb 11, 2022 12:57 PM

3415 views | 5 replies
JSL Saving EXCEL format and Keeping Leading Zeroes

Greetings, I have a JMP file that has leading 0s in several of the columns that I want to keep. Data Type is Character... and Modeling Type is Nominal When I save the file into EXCEL format using the JSL code below, the leading 0s disappear. Is there anyway to keep them in?
du = Cust_join << Save( Concat("C:\file",Format( Today(), "yyyymmdd" ),".xlsx") );

I suppose script some code that puts an a...
fat_angus

Discussions |
Feb 11, 2022 7:09 AM

2199 views | 5 replies
Model 'locked' to first point value

I'm studying a decay process as shown for a number of samples below. The higher the starting point, the faster the decay. The idea is to predict the value at any timeopint from measured Initial value. I would like to 'lock' the model so that at timepoint zero, the predicted value is exactly the measured Initial value. If not, predictions as short time times can be very off for some samples, as in ...
Ake

Discussions |
Feb 11, 2022 5:43 AM

3014 views | 6 replies
How to merge multiple graphs to one?

Greetings from Japan, I'm Ryo and want to create merged graph like below image in JMP.I've just tried several settings but seems difficult for me...Does anyone can help me how to reach this? Thank you and kind regards,
ryotaro_seiren

Discussions |
Feb 10, 2022 1:34 PM

2537 views | 2 replies

Previous
Next

Latest Discussions

Filtering and plotting data

Hello, I would like to plot and identify outliers within say three different batches. Each batch contains about 80 values. What would be a good way to plot and highlight the outliers between these 3 batches? I thought maybe using the Animation feature in the local data filter to walk through the comparison would work, but I have a feeling that there's a better way. Here is an image that I was at...
ndowidar

Discussions |
Feb 11, 2022 10:28 PM

1563 views | 3 replies
JSL Saving EXCEL format and Keeping Leading Zeroes

Greetings, I have a JMP file that has leading 0s in several of the columns that I want to keep. Data Type is Character... and Modeling Type is Nominal When I save the file into EXCEL format using the JSL code below, the leading 0s disappear. Is there anyway to keep them in?
du = Cust_join << Save( Concat("C:\file",Format( Today(), "yyyymmdd" ),".xlsx") );

I suppose script some code that puts an a...
fat_angus

Discussions |
Feb 11, 2022 7:09 AM

2199 views | 5 replies
Model 'locked' to first point value

I'm studying a decay process as shown for a number of samples below. The higher the starting point, the faster the decay. The idea is to predict the value at any timeopint from measured Initial value. I would like to 'lock' the model so that at timepoint zero, the predicted value is exactly the measured Initial value. If not, predictions as short time times can be very off for some samples, as in ...
Ake

Discussions |
Feb 11, 2022 5:43 AM

3014 views | 6 replies
How to merge multiple graphs to one?

Greetings from Japan, I'm Ryo and want to create merged graph like below image in JMP.I've just tried several settings but seems difficult for me...Does anyone can help me how to reach this? Thank you and kind regards,
ryotaro_seiren

Discussions |
Feb 10, 2022 1:34 PM

2537 views | 2 replies
Have a y function change with a local data filter.

I'm trying to draw on a graph some curve. But that curve is different for some set of variables. I'm wondering if anyone has a good way to make yfunction() change based off what's selected in a local data filter. For instance, if I change age from 12 to 13, below, I want a cosine wave instead of sin wave or something like that. Note: this is for JMP live, so I don't think filter change hand...
vince_faller

Discussions |
Feb 10, 2022 6:11 AM

1593 views | 4 replies

Previous
Next

Latest Discussions

No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

599 views | 0 replies
Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

770 views | 0 replies
How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

589 views | 0 replies
Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1391 views | 0 replies
M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

790 views | 0 replies