JMP User Community

Latest Discussions

Can I sort the X axis by wait time while keeping the axis display as it is ?

Hi, I have collected some measurement data on several unit IDs but instead of sorting it by unit ID (like the chart below), I would like to sort it by the wait time while keeping the unit IDs in the X axis display as it is. Is there a way to do so in JMP ? Regards,CD
XiangCD_MP_User

Discussions |
Sep 14, 2022 3:50 AM

1390 views | 2 replies
How copy/past factors from excel in design of experiments

Good morning everyone, As novice in JMP, i am looking for a way to copy/past a long list of factors from excel in Jump, optimal design, without having to manually write one by one. Is there a solution in Jump, or maybe with VBA or Python ?I put a screenshot in attachment if it's not clear.Version of JMP : 16.1.0Thanks
Padmé

Discussions |
Sep 14, 2022 1:47 AM

2406 views | 2 replies
how to change a series of numbers into time format

Hello! Can anybody help changing a series of numbers into time format [hh:mm:ss] here. Originally, the data type is character. So, I've tried changing the data type from character to numeric to set format as [hh:mm:ss] but I failed...I have no idea what to do now. What I'd like to see as a result is, taking an example of 000003, 00:00:03..It should not be that difficult, but I can't find a way......
SuperBigRabbit

Discussions |
Sep 13, 2022 10:45 PM

1762 views | 3 replies
Is Missing command- Scrippting

In this example, ;"Sum of A+B+C" calculates sum of :A + :B + :C in each row with this formula: If( Is Missing( :A ), 0, :A ) + If( Is Missing( :B ), 0, :B ) + If( Is Missing( :C ), 0, :C )If I change the specific column names to with column number, the script is not working anymore and generates an error If( Is Missing( Column( 1 ) ), 0, Column( 1 ) ) + If( Is Missing( Column( 2 ) ), 0, Column( 2 ...
GroupSquareWolf

Discussions |
Sep 13, 2022 7:54 PM

1578 views | 4 replies
Delete columns with for loop

Hi, I create a for loop script to delete empty column (column contains only N/A).It works ok except on one file, one column get deleted when it's not suppose to.Not sure what's wrong for (i= ncols (dt[d]),i>=1,i--, summarize(data table(dt[d]),temp = by(column(i))); if(nitems(temp) ==1 & temp[1]=="N/A", data table(dt[d])<< delete columns(column(i)); ); );

yanee

Discussions |
Sep 13, 2022 11:59 AM

1339 views | 1 replies

Previous
Next

Latest Discussions

Is Missing command- Scrippting

In this example, ;"Sum of A+B+C" calculates sum of :A + :B + :C in each row with this formula: If( Is Missing( :A ), 0, :A ) + If( Is Missing( :B ), 0, :B ) + If( Is Missing( :C ), 0, :C )If I change the specific column names to with column number, the script is not working anymore and generates an error If( Is Missing( Column( 1 ) ), 0, Column( 1 ) ) + If( Is Missing( Column( 2 ) ), 0, Column( 2 ...
GroupSquareWolf

Discussions |
Sep 13, 2022 7:54 PM

1578 views | 4 replies
Delete columns with for loop

Hi, I create a for loop script to delete empty column (column contains only N/A).It works ok except on one file, one column get deleted when it's not suppose to.Not sure what's wrong for (i= ncols (dt[d]),i>=1,i--, summarize(data table(dt[d]),temp = by(column(i))); if(nitems(temp) ==1 & temp[1]=="N/A", data table(dt[d])<< delete columns(column(i)); ); );

yanee

Discussions |
Sep 13, 2022 11:59 AM

1339 views | 1 replies
dynamic Y variable for oneway analysis

Hi everybody, I am trying to script a dynamic Y variable for oneway analysis, then output the mean into a combined table. Is this a correct way to do so ?dt = Data Table ("Analysis"); ColNamesList = d1 << get column names (string ); For( i = N Items( ColNamesList ), i >= 1, i--, OW = (dt << Oneway( Y( Column(ColNamesList) ), X(:SITE), Mean ( 1 ), Automatic Recalc( 0 ) )) << Report; )...
XiangCD_MP_User

Discussions |
Sep 13, 2022 11:23 AM

1858 views | 4 replies
Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

598 views | 0 replies
I did DOE for nanoparticle synthesis to estimate size, what do I put if no synthesis occurred? / Hice DOE para síntesis de NPs, ¿Qué pongo si no ocurrió síntesis?

I elaborated a 2^4 factorial design, in some conditions NPs were not formed and I have doubts about how to put this information: with 9 or eliminate the data./Elabore un diseño factorial 2^4 y en algunas condiciones no existió la formación de NPs y tengo duda de como poner esta información en JMP si con 0 o eliminar las condiciones.
OlyUASLP

Discussions |
Sep 13, 2022 1:49 AM

1006 views | 1 replies

Previous
Next

Latest Discussions

Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

598 views | 0 replies
wrap: hide sub-titles?

In GRaph Builder, "wrap" is a nice option to split a data set into small pieces and generate many sub-plots.
But sometimes, the window is just filles with the "titles" of the sub-plots an there is no space left for the plots.
Is there an option to hide the titles of the subplots?
In the "wrap" context menu, there is an option to remove the "title" (here: "data"), but not the sub-titles.
And in the red...
hogi

Discussions |
Sep 11, 2022 8:53 AM

634 views | 0 replies
How to transform least square means from Turkey table after box cox transformation

Hello Everyone, I am running a three-way ANOVA with data expressed in percentage, but the data set is not normal. Since I have zeros, I first add a constant 0.00001, then I fit the model, and in the least square fit window, I used the box cox transformation to do a better fit. I know if I ask to save the predicted values, it will save the back-transformed data, but is there an option for JMP to sa...
Viniaze

Discussions |
Aug 27, 2022 9:14 AM

677 views | 0 replies
XGBoost Add-In for JMP Pro no test set result in model screening

I'm using model screening and include XGBoost as a method. However the result from XGBoost are only shown in Train set and Validation set.Why the result of XGBoost for test set is not shown?
TasapornV

Discussions |
Aug 25, 2022 12:45 AM

745 views | 0 replies
JMP Pro, Dantzig selector: how do I improve computational time

Hello JMP community members. Concerning the use of the Dantzig selector on big and sparse datasets.I wondered what features would be at disposal to tune the computational time.Right now it takes about 40 minutes to get a result back for a problem with 380 rows and 149 non-singular parameters. This makes me wonder about the options available to tweak the computation time. I was thinking about redu...
Not_A_Student

Discussions |
Aug 12, 2022 7:49 AM

746 views | 0 replies