JMP User Community

Latest Discussions

Joining two tables based on dates

Hi,I want to accomplish something which I think is very simple: Joining tables based on dates.Let's say I have the following tables:Table1 - which has the following columns: Group1, event_date.Table2 - which has the following columns: Group2, start_date, end_date.I want the join to work as follows: (Group1 == Group2) AND (start_date < date < end_date)How can I accomplish this using a JSL code?Than...
Yotam

Discussions |
Feb 22, 2022 12:05 PM

3400 views | 3 replies
Filtering and row selections

I have data where each row is data from a certain day of a cell culture batch. Only the rows for the last day of each cell culture has the information for product quality. Now I am trying to filter out batches based on product quality at the end of the culture but I want to select all the days of those cultures so that I can compare them throughout the culture time. In the example the filter gets ...
lara90

Discussions |
Feb 22, 2022 7:38 AM

1598 views | 2 replies
Problem with copying graph to word

Hi.I am having an odd problem that I have not encountered before when I try to copy a graph from the graph builder to MS Word. Basically a big part of the picture crops off, and I am left with an unfulfilling graph. See pictures below. I used the selection (S) to choose which part of the graph to copy.Has anyone encountered this? It has never happened to me before. First picture is what I select, ...
Vvvv

Discussions |
Feb 22, 2022 1:14 AM

1286 views | 1 replies
N Col using textbox value

Hi all,I am trying to create a user input box that will determine the N Col for my line up box. I tried this script User_Input = New Window( "N Col", << modal(), hlistbox( Text Box( "Enter Column No: " ), Col_Num_teb = Text Edit Box( "", <<set width( 200 ) ), ), Button Box( "OK", col_num = col_num_teb << get(); ), ); lb = LineUpBox( N Col(col_num) );I tried entering 4 but ends up havi...
UserID16644

Discussions |
Feb 21, 2022 10:22 PM

1399 views | 2 replies
How do you remove this random line from a graph?

When I am in graph builder working on a line graph, sometimes a random black line appears and I am not sure where it is coming from or what it's for. How do I get rid of it?

[Note: Variables in the column box are redacted out in this post, but there are items there.]
EdgeCurved

Discussions |
Feb 21, 2022 12:13 PM

2023 views | 2 replies

Previous
Next

Latest Discussions

Filtering and row selections

I have data where each row is data from a certain day of a cell culture batch. Only the rows for the last day of each cell culture has the information for product quality. Now I am trying to filter out batches based on product quality at the end of the culture but I want to select all the days of those cultures so that I can compare them throughout the culture time. In the example the filter gets ...
lara90

Discussions |
Feb 22, 2022 7:38 AM

1598 views | 2 replies
How do you remove this random line from a graph?

When I am in graph builder working on a line graph, sometimes a random black line appears and I am not sure where it is coming from or what it's for. How do I get rid of it?

[Note: Variables in the column box are redacted out in this post, but there are items there.]
EdgeCurved

Discussions |
Feb 21, 2022 12:13 PM

2023 views | 2 replies
How do you change the font color of the data table headers?

I can't for the life of me figure out how the change the color of the font on the data table headers. I had to change the background color to white in order to get the tan border off of my graphs, but the text color was already set to white before I did that. This means the headers of my tables look like this because it's white-on-white and I can't see anything unless I am actively clicking on th...
EdgeCurved

Discussions |
Feb 21, 2022 12:11 PM

1958 views | 2 replies
Comparing sensitivity and specificity of two diagnostic tests

Hi,I have two test done on the same indeviduals, hence dependent, which I calculated the sensitivity and specifity related to the "golden standard". I would like to compare them to test if the difference is significant. I believe the test is mcnamar test. How to perform this in JMP?TIA
eliyahu100

Discussions |
Feb 21, 2022 10:24 AM

3713 views | 3 replies
How to insert a column with specified column index with JMP script?

I met a problem when writting my JMP script, I want to add the new column with a formula Y/X but there are serveal colunms and I want to add the new colunm after specified column,For example:A Table like:A B C D1 2 3 42 4 6 8 and I want to add a new column after B column(like below), but the B/A column will always after D when I use New Column function, and I cannot fi...
Jiaxiang

Discussions |
Feb 21, 2022 12:10 AM

1582 views | 1 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

752 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

946 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

722 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

1607 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

958 views | 0 replies