JMP User Community

Latest Discussions

How do I join data from multiple data loggers by time axis (without using scripts)?

Hello, this may be a simple question. I am trying to join data downloaded from several data loggers. The data from each datalogger comes as a table - Time Stamp vs Measurement 1, 2, 3, etc. I need to merge the data from all the data loggers into one table with a common time axis. Sometimes the timestamps match exactly, so multiple measurements can be on the same row (with the same timestamp) in th...
Tim_K

Discussions |
Sep 22, 2021 9:13 AM

1838 views | 3 replies
How to Add reference lines on Graph Builder script loop

I'm trying to automate graph generation which looks good but when adding the reference lines they're not plotted. How this can be accomplished through the loop?As test I've also tried to give a number or the index to the Scalebox but nothing appear.Data Table( "NC119_1" ) << Graph Builder( Page Gap Size( 1 ), Variables( X( :timeTrace ), Y( :VI2, Side( "Right" ) ), Y( :VI1, Position( 1 )...
Buttinoni7

Discussions |
Sep 22, 2021 8:44 AM

1395 views | 1 replies
Linking Data Filters to New Summary Tables

I have a dataset with many continuous columns of data and two categorical factors that I filter on within my dashboard, and an additional Categorical variable (Group) that I use to split all the plots/analyses by. I also have a primary column switcher that means users can cycle through a summary table of each continuous variable. The primary column switcher is linked to all the other column switch...
EB101

Discussions |
Sep 22, 2021 8:01 AM

1731 views | 2 replies
Applying quantiles and wilcox test to all graphs

Hello, I am a new JMP 15 user and need help with what is probably an easy task. I successfully imported my excel database and created a sheet with many graphs by doing Fit Y by X. I can click on the red arrow next to OneWay Analysis for each graph to enable the quantiles and Wilcoxon each pair, but there must be a way to quickly apply this to all graphs rather than click one at a time. Any help wi...
vgiacalone

Discussions |
Sep 22, 2021 6:35 AM

1054 views | 2 replies
Summarizing & Exporting All Value Labels Data From a Table

Is there an easy way in JMP to summarize and export all Value labels information contained in a table (where multiple columns may have different Value Labels, but not all columns will have Value Labels)? Currently doing this manually by doing Recode on every Column with a Value Label, and doing Make Into Data Table. I then combine all the generated data tables together to get a stacked table (see ...
Nats

Discussions |
Sep 22, 2021 1:45 AM

1501 views | 2 replies

Previous
Next

Latest Discussions

How to Add reference lines on Graph Builder script loop

I'm trying to automate graph generation which looks good but when adding the reference lines they're not plotted. How this can be accomplished through the loop?As test I've also tried to give a number or the index to the Scalebox but nothing appear.Data Table( "NC119_1" ) << Graph Builder( Page Gap Size( 1 ), Variables( X( :timeTrace ), Y( :VI2, Side( "Right" ) ), Y( :VI1, Position( 1 )...
Buttinoni7

Discussions |
Sep 22, 2021 8:44 AM

1395 views | 1 replies
Linking Data Filters to New Summary Tables

I have a dataset with many continuous columns of data and two categorical factors that I filter on within my dashboard, and an additional Categorical variable (Group) that I use to split all the plots/analyses by. I also have a primary column switcher that means users can cycle through a summary table of each continuous variable. The primary column switcher is linked to all the other column switch...
EB101

Discussions |
Sep 22, 2021 8:01 AM

1731 views | 2 replies
DoE with fixed sum volume

I am working in formulation team and a very new to DoE. Need guidance for a DoE with below conditions:
there are 5 factors : P1 (%), P2 (%), P3 (%), P4 (%) and P5 (ppm)P4 is used for volume make up & the equation is P4 = 100 - (P1+P2+P3)P4 also has effect on Y (response).P1, P2 and P3 have 2 level discrete values while P5 has 3 level discrete value.Please see the image for reference: My queries:1....
SIBH

Discussions |
Sep 21, 2021 11:15 PM

1752 views | 3 replies
Significant Two Sample Test for Proportion but not significant Chi-square

Hi all I'm working with data from some pass-fail testing, where a difference in performance has been observed for some samples grouped into left and right. I'm trying to analyse whether this is a real difference or rather variation due to statistical variance. I'm doing this by using the Contingency analysis (Fit X by Y) framework in JMP. The issue is that I'm a bit confused by the results, whic...
Forrest

Discussions |
Sep 21, 2021 6:03 AM

3275 views | 3 replies
Table Join Troubleshooting

I frequently run into issues when attempting to join multiple data tables, and I am not sure what I am missing. Most commonly, I am looking to join tables by matching a date. Sometimes this works no problem, sometimes I struggle significantly and have to try a large number of different options within the join dialogue. Typically, I have Table A with thousands of rows logging machine data. Each r...
rickr135

Discussions |
Sep 20, 2021 1:47 PM

3087 views | 4 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

948 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

946 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

661 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

1217 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

611 views | 0 replies