JMP User Community

Latest Discussions

Script to Delete Columns Not Containing a Certain Word

Hi, how do I write a script to delete columns not containing a certain word? I would like to delete column names that do not have the word "4C4QC30.0" in them My script below unfortunately does not work: For( i = 11, i <= N Cols( dt1_new ), i++, // set number of columns to start looking atIf( (Column( dt1_new, i ) << Get Name) != "4C4QC30.0.Cv", // dt1_new << Delete Column ; )); thanks!
ShahirahLoqman

Discussions |
Dec 15, 2018 10:29 AM

4846 views | 1 replies
Row State select and color

Okay I've tried various things to try and get this to work, but all I've got so far is a not quite functionally useable script. The deletion script works beautifully, but while the row state script -works- it doesn't quite work the way I want it to, and I'm hoping there's a way to clean it up a bit.dt << New Column ( "Row State 1", Row State, Set Formula ( If( :Alarm ID == "'00000D06", Color Sta...
DamionSparhawk

Discussions |
Dec 14, 2018 9:58 PM

8725 views | 5 replies
how to compare the shape of curves vs a baseline in JMP?

Hi there We are trying to evaluate the differences between measured data against an ideal baseline; in this case we're comparing the shape / magnitdue / quality of force displacement curves. We've in the past compared the various slopes, peaks and valleys to do this, but are finding this doesnt capture all the variation we are seeing. Is there a way to compare the entire "shape" of one curve a...
abdulj

Discussions |
Dec 14, 2018 10:03 AM

13576 views | 9 replies
Tips to improve control chart visualization

Hello,I created several control charts out of a JMP data table and saved everything as a report, I would like to do the following:how can I modify the script in order to get plotted only the last 30 datapoints from the data table?how can I modify the script in order to set the correct size of the chart? Right now every time I open it the graph is compressed on the left sideThanks for your support!
js1985

Discussions |
Dec 14, 2018 8:01 AM

7442 views | 11 replies
JSL create a Query dialog

hello. my project is to create a Query dialog with JSL. i would like to make a dialog box where i can put a certain number of Lots and put this values in a variable so.. i found the option "COL SPAN BOX"... seems useful.....but work only if i put one lot Number. here the rudimental script i builted: test = New Window( "lots query", <<Modal, <<Return Result, Table Box( Col Span...
gianpaolo

Discussions |
Dec 14, 2018 7:55 AM

5646 views | 3 replies

Previous
Next

Latest Discussions

how to compare the shape of curves vs a baseline in JMP?

Hi there We are trying to evaluate the differences between measured data against an ideal baseline; in this case we're comparing the shape / magnitdue / quality of force displacement curves. We've in the past compared the various slopes, peaks and valleys to do this, but are finding this doesnt capture all the variation we are seeing. Is there a way to compare the entire "shape" of one curve a...
abdulj

Discussions |
Dec 14, 2018 10:03 AM

13576 views | 9 replies
Tips to improve control chart visualization

Hello,I created several control charts out of a JMP data table and saved everything as a report, I would like to do the following:how can I modify the script in order to get plotted only the last 30 datapoints from the data table?how can I modify the script in order to set the correct size of the chart? Right now every time I open it the graph is compressed on the left sideThanks for your support!
js1985

Discussions |
Dec 14, 2018 8:01 AM

7442 views | 11 replies
Creating webpage for html output

How do I create webpage where I can post jsl html output so that people without jmp can view html?
ENTHU

Discussions |
Dec 13, 2018 12:04 PM

7157 views | 4 replies
Combining scatter plot and broken line graph with the graph builder

Hi guys, I needs some idea for the graph builder.
I got problem after making a scatter plot which has several data on the Y axis. After that I recognized I have to build in a broken line graph which has the avg data.
I'm trying this by 2 methods but none works.

1. Adding a column that has the avg of the data to my data sheet and use the graph builder again -> Doesnt work because I dont know how to co...
sojun1218

Discussions |
Dec 13, 2018 6:55 AM

2657 views | 1 replies
[Script] Get rid of Moving Range chart in control chart builder

Hello~ all~Is there a way to get rid of Moving Range chartin the 'Control chart builder' platformby using JMP script? : )Here is the script for the 'control chart builder' sample.dt = Open( "$SAMPLE_DATA/Quality Control/Coating.jmp" );dt << Control Chart Builder(
Show Control Panel( 0 ),
Variables( Subgroup( :Pin ), Y( :Weight ) ),
Chart( Position( 1 ), Limits( Spec Limits( 1 ) ), Warnings( Test 1...
Steve_Kim

Discussions |
Dec 12, 2018 11:43 AM

18276 views | 12 replies

Previous
Next

Latest Discussions

I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2557 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3234 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3636 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2459 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3434 views | 0 replies