cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • Making a Bivariate chart with group by column with unknow number of categories ?

    Hello All I have a big list of columns which I loop through to create a Bivariate chart each of every column in my column list. My x-axis remains the same every time. I am grouping by the same categorical column as well. But the number of groups/categories in that column changes everytime. How can I use the "Fit Where" function in the bivariate plot so see all categories in one graph for each colu...

    ankitgssingh ankitgssingh
    Discussions |
    Sep 15, 2022 3:43 PM
    1627 views | 4 replies
  • Losing Power and Prediction Variance in Custom DOE constraints

    So I have to disallow certain combinations based on equipment capability, BUT it decreases the prediction variance and power significantly. Is there a way get around this? And if I can't, how will I be able to trust the results if power is low and the prediction variance high?   

    evtran evtran
    Discussions |
    Sep 15, 2022 3:33 PM
    1403 views | 3 replies
  • How to delete Filter Col Selector display box?

    I have a Filter Col Selector with filter text field (because of many columns in the data table): Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Bands Data.jmp" ); pb = Panel Box("Test", fcl = Filter Col Selector( dt, all ) ); New Window( "Filter Col Selector Example", pb ); I get the list of columns (red frame) and filter (green frame)Let's say I now want to delete the whole thing. I s...

    miguello miguello
    Discussions |
    Sep 15, 2022 12:33 PM
    1840 views | 7 replies
  • Get date and time out of a text in a cell

    Hi,I have a data set that reports the day and time within one cell in this format: "12.08.2022 15:46:43 GMT-0700" (the date format is dd.mm.yyyy).  I would like to create a column for the dates and a column for the time (I am going to assume that the time is the local time and the GMT-0700 is just indicating that is where the local time. So for each cell, I would like two columns: Column 1: In dat...

    rlangsner rlangsner
    Discussions |
    Sep 15, 2022 10:17 AM
    1055 views | 3 replies
  • In a script, return the selected table scripts as a list

    Hi, I am aware of using the code below to return all the table scriptsscriptNames = dt << Get Table Script Names;Is there a way to only return the scripts that I have selected (if any are selected, otherwise return all).So return [Bivariate,Logistic] in the case below 

    mvanderaa1 mvanderaa1
    Discussions |
    Sep 15, 2022 4:10 AM
    1848 views | 8 replies

Latest Discussions

  • Collapsing Table Variables/Scripts from Data Box

    Is there a way to collapse Table Variables/Scripts from Data Box / change height of Columns list to hide it? Or is there any other way of getting column listing from data table with same functionalities?  What I have: What I would like to have:   Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp", invisible); New Window("Big Class", H List Box( lb = List Box(dt << Get Column Na...

    jthi jthi
    Discussions |
    Sep 14, 2022 6:44 AM
    810 views | 2 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 GroupSquareWolf
    Discussions |
    Sep 13, 2022 7:54 PM
    1069 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 yanee
    Discussions |
    Sep 13, 2022 11:59 AM
    1022 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 XiangCD_MP_User
    Discussions |
    Sep 13, 2022 11:23 AM
    1349 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 Agustin
    Discussions |
    Sep 13, 2022 6:43 AM
    414 views | 0 replies

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 Agustin
    Discussions |
    Sep 13, 2022 6:43 AM
    414 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 hogi
    Discussions |
    Sep 11, 2022 8:53 AM
    485 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 Viniaze
    Discussions |
    Aug 27, 2022 9:14 AM
    517 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 TasapornV
    Discussions |
    Aug 25, 2022 12:45 AM
    565 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 Not_A_Student
    Discussions |
    Aug 12, 2022 7:49 AM
    573 views | 0 replies
view all discussions