JMP User Community

Latest Discussions

Deleting cell values based on condition

Hi! I'm currently working on a project using JMP/JSL and on my data, I need to delete or clear values from multiple cells based on a condition. See sample raw data and required output below. Raw data: Test1P/F 1Test2P/F 2Test3P/F 3Test4P/F 4Test5P/F 51P2P4P9F3P5P8F4P6F2P7P1P6F5F6F4P1P9F9F9F6F4P 10F10F8F Required Output:Test1P/F 1Test2P/F 2Test3P/F 3Test4P/F 4Test5P/F 51P2P4P9F**5P8F******7P1P6F***...
fsanjuan

Discussions |
Sep 6, 2019 3:46 PM

3946 views | 2 replies
A cumulative sum that resets based on an event?

I'm trying to find a relationship between uses and part lifetime. This is a part that runs constantly when in use. I need a running total that resets when the part is replaced. In my case, I have the first four columns, I want to know how to create the "Jobs Part has Done" column that resets when a Repair event is detected.DateTime StartedDateTime EndedJobsEventJobs Part has Done1/1/2019 8:00 AM1/...
Bearcat

Discussions |
Sep 5, 2019 2:21 PM

2991 views | 1 replies
Which feature to use to analyze material changes over time?

I have a material property that is measured at some irregular time intervals, usually whenever a new batch of material arrives. The measurement process gauge is known. I want to look at this property and identify changes in material performance and flag the vendor for improvements. Which feature in JMP will help me do this? Thanks,Siva
jsrk2084

Discussions |
Sep 5, 2019 11:52 AM

2032 views | 1 replies
How to check if "Create Database Connection" is successful?

Many of my scripts connect to a DB as soon as they are started. DB is in intranet, so users need to:1. Be connected to internal network OR have VPN on2. Have ODBC source set up correctly Sometimes they don't. I want to warn users that the DB is not available instead of script erroring on them. What would be a correct way of checking if "Create Database Connection" was successful and returned a val...
miguello

Discussions |
Sep 5, 2019 8:40 AM

2522 views | 2 replies
How to plot a normal curve on a histogram

Back in 2017, txnelson posted a nice snippet of code to do this:Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA\Big Class.jmp" ); Dis = dt << Distribution( Continuous Distribution( Column( :height ), Vertical( 0 ), Density Axis( 1 ) ) ); Report( Dis )[Frame Box( 2 )] << Add Graphics Script( mu = 63; sigma = 3.2; Pen Color( "Red" ); Y Function( Normal Density( (x - mu) / sigma ) / (40 /...
speleogen

Discussions |
Sep 5, 2019 8:21 AM

2146 views | 1 replies

Previous
Next

Latest Discussions

Which feature to use to analyze material changes over time?

I have a material property that is measured at some irregular time intervals, usually whenever a new batch of material arrives. The measurement process gauge is known. I want to look at this property and identify changes in material performance and flag the vendor for improvements. Which feature in JMP will help me do this? Thanks,Siva
jsrk2084

Discussions |
Sep 5, 2019 11:52 AM

2032 views | 1 replies
How to check if "Create Database Connection" is successful?

Many of my scripts connect to a DB as soon as they are started. DB is in intranet, so users need to:1. Be connected to internal network OR have VPN on2. Have ODBC source set up correctly Sometimes they don't. I want to warn users that the DB is not available instead of script erroring on them. What would be a correct way of checking if "Create Database Connection" was successful and returned a val...
miguello

Discussions |
Sep 5, 2019 8:40 AM

2522 views | 2 replies
How to plot a normal curve on a histogram

Back in 2017, txnelson posted a nice snippet of code to do this:Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA\Big Class.jmp" ); Dis = dt << Distribution( Continuous Distribution( Column( :height ), Vertical( 0 ), Density Axis( 1 ) ) ); Report( Dis )[Frame Box( 2 )] << Add Graphics Script( mu = 63; sigma = 3.2; Pen Color( "Red" ); Y Function( Normal Density( (x - mu) / sigma ) / (40 /...
speleogen

Discussions |
Sep 5, 2019 8:21 AM

2146 views | 1 replies
1E+05 to 100000

Hi guys, Why the JSL didn't change the 1E+05 to 100000 when I tabulate the data? What can I do?
almighty22

Discussions |
Sep 3, 2019 11:31 PM

4152 views | 4 replies
In JSL, can I tell a modal window where to be?

For an ordinary window I can do this... nw = New Window( "test window", Text Box( "just trying out this window" ) ); nw << move window( 100, 500 ); But for a modal window that doesn't work - I get that, the window is busy waiting for inputs so doesn't get any message sent afterwards. I tried sending this message when creating the window. But if I do it after the <<modal message it does...
hardner

Discussions |
Sep 3, 2019 12:36 PM

9739 views | 7 replies

Previous
Next

Latest Discussions

How to Add Profit Matrix to Neural Net Confusion Matrix

Hi all, I'm using a neural net to predict whether or not a customer will prefer to buy retail items at a markdown or if they are likely to buy full-price (i.e., "bargain buyers" vs. traditional shoppers). I'd like to incoporate the opportunity cost of a false positive (giving discounts to what would otherwise be a full-price shopper) using a profit matrix, but changing values on the matrix in the ...
GhostBen

Discussions |
Aug 5, 2019 8:00 PM

1509 views | 0 replies
Capability Animation - How to see the LSL/USL Value?

I just discovered this nifty tool called the Capability Animation, where you can play around, dragging the spec limits and mean shifts, and it simulates your capability indices. But, I cannot see the actual LSL/USL values as I drag them! Does anyone know how to make this happen?
Antonio80

Discussions |
Jul 9, 2019 1:31 AM

1482 views | 0 replies
Unable to allocate enough memory in access or evaluation

Hi,I'm trying to use the Multivariate platform to perform a correlation between 6 time points (rows) across 73500 columns. My final goal is to output a 73500x73500 correlation matrix. When I try to run it, I immediately receive this pop out message:Unable to allocate enough memory in access or evaluation of 'List' , {/*###*/Estimation Method( 0 ), Matrix Format( 2 )} What's the issue? I'm using J...
ns

Discussions |
Jul 8, 2019 9:04 AM

1552 views | 0 replies
How to Post JSON data to a site via API functionality: "Unsupported Media Type"

Hi There, I am trying to perform a POST request to post some JSON data to a server, but unfortunately as of now I keep getting a 415 error. The goal of this script is to upload a JSON formatted file (or something of the like) to the server for other users to download/read. I noticed that there are very few POST examples with JSL, but quite the abundance with GET, which I have no problems with. I w...
liqinglei419

Discussions |
Jul 2, 2019 6:33 AM

1886 views | 0 replies
How to analyze crossover design data in JMP

I had crossover design data from one of my experiment, and I want to analyze it according to the rules of crossover design. Can someone please help me with this?
sharmachetan

Discussions |
Jun 14, 2019 2:34 PM

1436 views | 0 replies