JMP User Community

Latest Discussions

Send chart to journal using window name, not by using handle to chart?

Consider the following example script (a simplified version of my actual problem)Names Default To Here(1); dt = open("$SAMPLE_DATA/Big Class.jmp"); //Scatt3D = dt << Scatterplot 3D( Y( :age, :height ), X Axis( :age ), Y Axis( :height ) ); include ("plotScatterPlot.jsl"); Window ("Big Class - Scatterplot 3D of age, height")<< journal; //Scatt3D << journalwhere plotScatterPlot.jsl containsScatt...
Neo

Discussions |
Sep 29, 2021 12:04 AM

1630 views | 4 replies
Using DOE to optimize a process

Dear JMP-Community, I want to optimize a process. I have 5 factors (X1 –X5), whereof one is a hard-to-change factor (X3) and 10 response variables (Y1-Y10). Responses are measured with a trained sensory panel (8 – 11 assessors). Each assessor can evaluate 3 samples per whole plot (=day). The assessors evaluate the intensities of the defined attributes (=responses) using an unstructured line scale ...
kjl

Discussions |
Sep 28, 2021 11:01 PM

2104 views | 2 replies
Cumulative Insect-Days

Hello, I need help calculating something called Cumulative Insect-Days per treatment. I don't know how to do that as it involves calculating the mean of specific rows and the difference between two specific rows. Cumulative insect-days = [ (Xi + Xi+1) * average(Y+Yi+1) ] + (Yi+1)Xi and Xi+1 are adjacent points in timeYi and Yi+1 are corresponding insect numbers I have done these calculations in Ex...
bordini

Discussions |
Sep 28, 2021 5:22 PM

39785 views | 2 replies
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

2420 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

2418 views | 5 replies

Previous
Next

Latest Discussions

Using DOE to optimize a process

Dear JMP-Community, I want to optimize a process. I have 5 factors (X1 –X5), whereof one is a hard-to-change factor (X3) and 10 response variables (Y1-Y10). Responses are measured with a trained sensory panel (8 – 11 assessors). Each assessor can evaluate 3 samples per whole plot (=day). The assessors evaluate the intensities of the defined attributes (=responses) using an unstructured line scale ...
kjl

Discussions |
Sep 28, 2021 11:01 PM

2104 views | 2 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

2334 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

902 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

3744 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

3135 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

974 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

962 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

689 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

1238 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

624 views | 0 replies