cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

Latest Discussions

  • Count Sum of Repeat Occurrences By Specified Variable?

    I would like to create a count sum formula which sums the number of occurrences of a value by a specified column variable.I want to know by a specified column variable value (i.e. Month) how many times did the same value appear in the column of interest.Example:  Sum Type of Fruit By MonthNew Column ( "Count_Fruit_Mo",                        numeric,                         continuous,            ...

    aandw aandw
    Discussions |
    Oct 21, 2020 11:48 AM
    15415 views | 6 replies
  • How to close database connection after running a New Sql Query?

    Steps to reproduce: Run any new sql query: query << Run Foreground( OnRunComplete( Write( "Number of rows in query result: ", N Rows( queryResult ) ) ) ); MyRunCompleteFunc = Function( {dt}, {Default Local}, Write( "Number of rows in query result: ", N Rows( dt ) ) ); query << Run Foreground( OnRunComplete( MyRunCompleteFunc ) );Next, if you try to delete the database, it will say that jmp ...

    douglaschong douglaschong
    Discussions |
    Oct 21, 2020 11:30 AM
    2250 views | 1 replies
  • How to multiply user input by a constant number?

    All, I'm trying to multiply user input number by a constant. I need to use the final number (hoursBack) as a part of a web address.  local( {Name= "ABCD", daysBack = "7", formError = 1, rv}, While( formError > 0, formError = 0; rv = Dialog( Title( "Select Extract criteria" ), VList( HList( "Name:", Name= EditText( Name) ), HList( "Days Back", daysBack = EditText( ...

    shilpa shilpa
    Discussions |
    Oct 21, 2020 9:42 AM
    4110 views | 5 replies
  • Calculate Cpk for Last 50 results

    Hi, is there a simple way to calculate Cpk for only a selected number of the most recent rows by using scripts. I am looking at machine capability and although the overall Cpk is a very useful metric to identify overall process capability, once improvements have been made to the manufacturing process, I want a way to easily track if the process is improving by only looking at the Cpk for the last ...

    Vicki36 Vicki36
    Discussions |
    Oct 21, 2020 8:36 AM
    3184 views | 3 replies
  • Select a Group of Columns based on the Group Name in JSL

    Hello all,I am writing a script that fits a neural net to the currently selected column of a data table.  I am currently hard coding the input columns in the JSL script, but to make it more easily transferable, I would like to have it use a group of columns that the user would name in the data table as the inputs.To do this, I need to be able to select a group of columns based on the name given to...

    spartans5143 spartans5143
    Discussions |
    Oct 21, 2020 8:07 AM
    11177 views | 3 replies

Latest Discussions

  • How to close database connection after running a New Sql Query?

    Steps to reproduce: Run any new sql query: query << Run Foreground( OnRunComplete( Write( "Number of rows in query result: ", N Rows( queryResult ) ) ) ); MyRunCompleteFunc = Function( {dt}, {Default Local}, Write( "Number of rows in query result: ", N Rows( dt ) ) ); query << Run Foreground( OnRunComplete( MyRunCompleteFunc ) );Next, if you try to delete the database, it will say that jmp ...

    douglaschong douglaschong
    Discussions |
    Oct 21, 2020 11:30 AM
    2250 views | 1 replies
  • moving labels on GraphBuilder

    I feel like this should be Graphbuilder 101, but I am stumped. So, I just want to make a couple of pie graphs and add the percentages as labels. But the labels are put in weird places, sometimes to where they can't be read. I thought you could actually manually drag text in some instances, but I failed there. I attached two scripts in the uploaded table ("test graphs"). Normally, you could just ad...

    abmayfield abmayfield
    Discussions |
    Oct 21, 2020 6:40 AM
    4113 views | 3 replies
  • Subset data after filter

    hello Everybody !I have a problem in my script.I have a big data table and i would like to subset some lines.I did a data filter and then subset or show subset, but i don't have "time" to select the filter in the window....how can i say in the script i have select first my filter and then subset the data tablei tried with a wait but it's not the best waythis is my script and i link my data basetha...

    MargauxR MargauxR
    Discussions |
    Oct 20, 2020 5:56 AM
    1643 views | 1 replies
  • Problem specifying model for a partly nested ANOVA design

    My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D).  I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality.  I'm also able to add the random factor (B[A]), but things go...

    wpsousa wpsousa
    Discussions |
    Oct 19, 2020 10:39 PM
    1151 views | 0 replies
  • Prior mean and prior variance matrix in choice design

    Hi to all,I am just reading the article Optimal Design of the Choice Experiment - JMP BlogHere the author writes "When there are three levels in increasing utility order, enter negative, then 0." So far so good. But what if I have e. g. 5 prices like 5, 10, 15, 20, 25 and 30 euros. Which prior means would I take in that case?30 = -425 = -320 = -215 = -110 = 05 = 1And is the prior mean variance sti...

    herberthinterbe herberthinterbe
    Discussions |
    Oct 19, 2020 6:05 PM
    16963 views | 6 replies

Latest Discussions

  • Problem specifying model for a partly nested ANOVA design

    My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D).  I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality.  I'm also able to add the random factor (B[A]), but things go...

    wpsousa wpsousa
    Discussions |
    Oct 19, 2020 10:39 PM
    1151 views | 0 replies
  • Default encoding on JMP - EUC-KR

    Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...

    joelahn joelahn
    Discussions |
    Sep 10, 2020 1:26 AM
    1398 views | 0 replies
  • 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
    985 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
    1095 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
    1485 views | 0 replies
view all discussions