JMP User Community

Latest Discussions

53 Time columns, some empty and some filled. How do I write a formula ensuring the highest filled column is > than next filled column etc.

If I have hundreds of rows, each row is a separate work ticket, each row can have up to 53 time columns filled in, but most only have some of these columns filled in and ones in between are blank.So say for Row #1: I have column 1, column 23 and column 36 are the only columns containing a time stamp, I will need know that 36>23 and 23>1.For Row #2 all columns have time stamps so I will need to kno...
fionaweston

Discussions |
Sep 28, 2021 3:35 PM

2408 views | 5 replies
Plot 2 different X and Ys over each other.

Hey Folks,Im trying to overlay 2 different x and Y coordinates over each other.one has 109pts and the other has 25pts.I am using the scatter plot matrix but it doesn't look so tidy or clear.Is there an easier way to graph this so I can see where the 27pts are on the 109pt map?
jearls11

Discussions |
Sep 28, 2021 11:11 AM

2387 views | 5 replies
How can I calculate with formula and create such a bar graph in JMP?

How can I calculate adherence in % see example in attachment and create such a bar graph in JMP?
Laetisten

Discussions |
Sep 28, 2021 7:44 AM

2296 views | 5 replies
Variability Chart - Cannot Add Line For Each Data Point In Each Group

I plot variability chart and want to add line to connect each data point for each group to show the trend.However, the line cannot be added.Could you take a look if I missing anything in my code?dt= Current Data Table(); Rp = dt << Variability Chart( Y( :Qty ), X( :Product, :Lot, :Defect, :Sublot, :workweek ), Max Iter( 100 ), Conv Limit( 0.00000001 ), Number Integration Abscissas( 128 ), N...
bzanos

Discussions |
Sep 28, 2021 5:50 AM

887 views | 1 replies
accounting for individual sample error when training a regression model for future predictions

Hi - I am doing a multiple linear regression to predict ecoli. My independent variables are turbidity and streamflow. My dependent variable is ecoli. I am training the regression model based on 188 values of turbidity, streamflow, and ecoli. I will then use future turbidity and streamflow values to predict the expected ecoli value. My question is this. How do I account for the fact that eac...
learning_JSL

Discussions |
Sep 28, 2021 5:21 AM

1274 views | 2 replies

Previous
Next

Latest Discussions

How can I calculate with formula and create such a bar graph in JMP?

How can I calculate adherence in % see example in attachment and create such a bar graph in JMP?
Laetisten

Discussions |
Sep 28, 2021 7:44 AM

2296 views | 5 replies
Variability Chart - Cannot Add Line For Each Data Point In Each Group

I plot variability chart and want to add line to connect each data point for each group to show the trend.However, the line cannot be added.Could you take a look if I missing anything in my code?dt= Current Data Table(); Rp = dt << Variability Chart( Y( :Qty ), X( :Product, :Lot, :Defect, :Sublot, :workweek ), Max Iter( 100 ), Conv Limit( 0.00000001 ), Number Integration Abscissas( 128 ), N...
bzanos

Discussions |
Sep 28, 2021 5:50 AM

887 views | 1 replies
How do I script for sending charts and analysis data to the journal without manually running existing scripts for charts/analysis?

Hi,I have bunch of scripts which I use to analyse the product test data in JMP.The scripts generally call multiple columns in the test data file.Each test run is tagged by an ID and only this ID changes for pulling the new test run data into JMP - the scripts used for data analysis remain same. For sharing my analysis I (currently) manually create a PPT slide pack with the charts and analysis data...
Neo

Discussions |
Sep 27, 2021 3:42 PM

3701 views | 9 replies
Script to select columns from a list in clipboard

Follow up....still problem. I need to convert a list of strings copied from row values which, when pasted here looks like thisTcea1 Atp6v1h Oprk1 Rb1cc1 Fam150aWhen pasted in the script window it looks like this Tcea1Atp6v1hOprk1Rb1cc1 I need code to convert the clipboard contents to this {Tcea1, Atp6v1h, Oprk1, Rb1cc1, Fam150a} and this does not work .... {"Tcea1, Atp6v1h, Oprk1, Rb1cc1, Fam15...
EugeneB

Discussions |
Sep 27, 2021 2:10 PM

3107 views | 7 replies
3D Hazard Ratio Graph

Hello everyone. Does anyone know how to make a 3D hazard ratio graph? Where the covariables would be the x/z axis and the hazard ratio would be the y-axis. Thanks!
jmpquestions123

Discussions |
Sep 27, 2021 11:20 AM

2469 views | 7 replies

Previous
Next

Latest Discussions

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

958 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

952 views | 0 replies
Error while using Azure MFA to connect with JMP

I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Password option must not be specified, if Authentication option is 'ActiveDirectoryInteractive'.
hariharan249

Discussions |
Sep 3, 2021 7:14 AM

669 views | 0 replies
Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along. I f...
caseylott

Discussions |
Aug 17, 2021 11:15 AM

1222 views | 0 replies
Projects Window List in JMP 15 for Mac -- Reorder?

I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I can click into to see/show my findings for various analyses. There is a flow to the findings which I'd like to order in that Window List. Is this possible? I can't click and drag an entry for a window up or d...
datanaut

Discussions |
Aug 16, 2021 6:38 AM

615 views | 0 replies