cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

  • JSL, Remove duplicate rows by looking at another column condition.

    Hello again,
    I am looking to remove duplicate rows by looking at another column condition.
    I want JSL to remove the duplicate "Roi" rows when they appear in the same Date and keep only the latest row by time (on Date and time column) so the end result will be table with only rows 1,2,3,4 and rows 5 and 6 that appear with same date as row 4 but the time is earlier will be deleted.  RowDate and timeNa...

    ileshem ileshem
    Discussions |
    Aug 23, 2020 2:18 PM
    2157 views | 1 replies
  • Adding DATE properties to a column in JSL

    Hi All,I know we can add DATE stamp to any column in JMP for a time trend as following:right click on any column-> choose column info->Column properties->Other->Type in "DATE" ->Insert the name of column including the dates Is there a script to do that automatically? Thanks a lot!Moe

    mjafari mjafari
    Discussions |
    Aug 23, 2020 1:44 PM
    1134 views | 1 replies
  • Rolling Sum in Formula Editor

    So I know that forms of this question have been asked before, but mostly the solutions has been JSL-based. One of my many failings in life is that I have not really learned JSL but instead rely on the formula editor (sorry). So I'm hoping there is a formula editor solution for this problem. My goal is to get a formula that will generate a rolling sum. That is, I need a formula in one column that w...

    scott1588 scott1588
    Discussions |
    Aug 23, 2020 1:20 PM
    3918 views | 4 replies
  • Which JMP function can generate a non-repeating integer between two values?

    I tried “Random Integer()”, but it produces duplicate integers. Thanks!

    lwx228 lwx228
    Discussions |
    Aug 23, 2020 7:58 AM
    2653 views | 3 replies
  • renew jmp14

     Time to renew my license.  Seems like every year I have this problem. (BTW this is a university license)My license has expired.  I click "open license" I (think) I open the SID file.  the system returns a message that says my license has been accepted, but when I check the renewal date, it still shows the old expired date.Help

    emeritus emeritus
    Discussions |
    Aug 22, 2020 10:12 AM
    3309 views | 4 replies

Latest Discussions

  • Adding DATE properties to a column in JSL

    Hi All,I know we can add DATE stamp to any column in JMP for a time trend as following:right click on any column-> choose column info->Column properties->Other->Type in "DATE" ->Insert the name of column including the dates Is there a script to do that automatically? Thanks a lot!Moe

    mjafari mjafari
    Discussions |
    Aug 23, 2020 1:44 PM
    1134 views | 1 replies
  • confusion matrix and performance meassures

    At present in JMPpro, the only performance meassure automatic calculated from the confusion matrix from a model is the misclassification rate and eventually the AUC of the ROC. Other meassures such as Fase positive and  False negative rates, sensitivity , specificity, negative and positive predictive value, precision/recall (= F1-score) and MCC are commonly described in ML literature and are very ...

    Lu Lu
    Discussions |
    Aug 22, 2020 9:55 AM
    3358 views | 1 replies
  • merge table from 2 csv files

    Hi, I have two csv files (round1.csv & round2.csv). How can I merge into a new table mergeRound.csv. I was trying to play around with the Last Name,First Name,Number combine should be the same. The rest of the columns should be merge. I was playing around the Tables menu but cannot figure it out before putting it to JSL. Thanks.

    sam_t sam_t
    Discussions |
    Aug 22, 2020 3:42 AM
    3866 views | 3 replies
  • Data labels and error bars overlapping

    Hey!Currently running the trial of JMP 15.1- so far it is awesome!!!I ran into a problem tho- I did ANOVA and Tukeys on my data. Due to the funcionality of JMP I wanted to make a graph of the stats+my data where the Tukeys would be shown, however, when trying to implement the connecting letters to my bar graph I noticed that the Row Labels are overlapping with the error bars... Any way that I coul...

    LKlavins LKlavins
    Discussions |
    Aug 20, 2020 8:32 AM
    3816 views | 3 replies
  • Background color

    Hi,I'm exporting JMP results to pdf, and I would like to change the usual background color of these output (so to be clear, the color behind "Distributions" for example in the attached image). In JMP preferences -> Styles, I can change some elements of the output, like the background color of the page, but not this element (at least I have not found how to do it). Can somebody help ? Thanks a lot....

    Fabrice_L Fabrice_L
    Discussions |
    Aug 19, 2020 1:23 PM
    3518 views | 2 replies

Latest Discussions

  • order statistic for DS Weibull ... maximum failure time for n fails out of N~n/p units

    this isn't a JMP question per se, but a reliability/survival statistics question ... see my post on Cross Validatedthanks in advance! https://stats.stackexchange.com/questions/483556/order-statistic-maximum-for-subpopulation-weibull-distribution 

    galactus3000 galactus3000
    Discussions |
    Aug 18, 2020 8:48 AM
    897 views | 0 replies
  • Custom Lat Long Contour Map

    Hi all,    Playing around with the Custom Map Creator add in and I ran into some trouble when trying to construct borders for a river system. When constructing a custom map border using a a background map the boundaries function does not let me to trace the river pattern as accurately as I would hope (see attached photo). Alternatively, when constructing a border from a background photo the bounda...

    MikeDereviankin MikeDereviankin
    Discussions |
    Aug 14, 2020 11:03 AM
    1003 views | 0 replies
  • XPath Query() and XML namespaces

    I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...

    john_madden john_madden
    Discussions |
    Jul 23, 2020 9:53 AM
    1309 views | 0 replies
  • Using JMP to Calculate Surface Flatness

     Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...

    jay_holavarri jay_holavarri
    Discussions |
    Jul 20, 2020 11:26 AM
    1558 views | 0 replies
  • Save all scripts and close reports by JSL

    Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...

    Georg Georg
    Discussions |
    Jul 20, 2020 7:48 AM
    1311 views | 0 replies
view all discussions