cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

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: Iterate through columns

    Hi, I have 2 questions (very new to this!) First, I have multple columns of like data, and I need to apply the same formula to all of them. For example, if I had to find the mean of each column, can I automate that through some sort of iteration? Second, how do I go about saving an operation as a list and not as a new column? For exmaple, if I had the following operation creating a new column in m...

    matt7109 matt7109
    Discussions |
    Jun 12, 2017 2:29 PM
    11844 views | 1 replies
  • How to export JMP graph to PPT by JSL?

    Hello, I am a new starter of JSL. I have managed to build box plots with local data filter (filted by dimension type) by JSL. And I want to export the box plots one dimension type by one dimension type (from the top of data filter to the bottom) to a powerpoint file. But I can not find the functions in JMP help file to make it happen. Appreciate if someone can grant help. I just want to know what...

    srwhill srwhill
    Discussions |
    Jun 12, 2017 10:33 AM
    32897 views | 7 replies
  • How do I use an if statement and a by variable correctly in a column mean formula?

    I'm trying to use the columne mean formula to show the Time 0 average value for a columen of test samples, grouped by the test sample types.  I found this topic from 2012, that looked like it would work:https://community.jmp.com/t5/Discussions/Determine-column-mean-by-day-and-within-certain-hours/m-p/5477/highlight/true The recommended syntax there is:Col Mean( If( 1 <= :Hour <= 10, :x, Empty() ),...

    rperkins rperkins
    Discussions |
    Jun 12, 2017 8:51 AM
    7584 views | 2 replies
  • check if excel worksheet exsists

    I would like to write JMP script which try to open specific worksheet from excel.The problem is if one of my excel files not including the requested worksheet, then the JMP script crush .I need advice how can I prevent it? (I mean, check before open the excel, if it including the requested worksheet..) this si my code:add_to_DB = function({file_path, sheet, header_line, data_line},

    new_dt = Open(
    fi...

    Amir_y Amir_y
    Discussions |
    Jun 12, 2017 5:37 AM
    7861 views | 3 replies
  • I/O Problem

    Suddenly i started getting I/O Problem. though it still reads the file by opening and closing. but its very annoying to get the pop-up when i am opening excel sheets using jsl. I/O problem.
    Unable to open in ReadWrite mode.
    The system cannot find the file specified.

    ram ram
    Discussions |
    Jun 11, 2017 7:33 AM
    10049 views | 1 replies

Latest Discussions

  • How to use a color scheme in "Graphic script"?

    HI All,is there a way to use default color scheme for "add graphic script" when adding multiple lines and text?e.g in below code i want to use default color scheme for lines and text instead of hard coded.Motivation: I have to match the color of data to the lines and text, where my data is colored by a group.Line Style( 0 );
    Pen Color( 6 );
    Pen Size( 2 );
    Text Size( 10 );
    Try( X Function( 315.4, y, Ma...

    ram ram
    Discussions |
    Jun 10, 2017 7:27 PM
    5450 views | 5 replies
  • how to analyse automaticly?

    dear all: i have to monito abnomal ratio every day, but now everyday i open the JMP and then put excel data in JMP to analyse, that is trouble。 if i open jmp and then analyse automaticly how i write JSL to realize?

    TONYMA TONYMA
    Discussions |
    Jun 7, 2017 8:40 AM
    4401 views | 3 replies
  • Function for back button

    Hi, everyoneI can create a button named as "Back". But may I know is there any function that can back to the previous interface when i click the back button?
    Thanks.

    jade jade
    Discussions |
    Jun 2, 2017 4:50 AM
    3422 views | 2 replies
  • Parallel Processing in Scripting

    In the process of putting togother a lengthy script that makes some calls to ODBC/SQL databases that can each take several minutes to run. In an ideal world I could be waiting for multiple servers to get back to me at the same time. From what I am gathering I have to stick with just running one database request after another?I am running JMP 9.

    firemandan9 firemandan9
    Discussions |
    May 31, 2017 12:46 PM
    6667 views | 4 replies
  • Disabling all or individual check boxes not able to be re-enabled with opposite method

    I have two sets of check boxes and one is being used to control which options are enabled on the other. I seem to have run into an issue using Enable and Enable Item. If I have previously disabled all the checkboxes I am unable to enable them individually unless I enable them all first. Conversly, if I disable individual check boxes, it appears I am unable to enable them all at once. As it is curr...

    SG SG
    Discussions |
    May 30, 2017 12:14 PM
    3577 views | 1 replies

Latest Discussions

  • Printing worksheet with cell colors

    Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors.  Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

    Thanks.

    ferdt58 ferdt58
    Discussions |
    May 16, 2017 9:14 AM
    2152 views | 0 replies
  • Linearity and Bias Report

    In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%.  We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.

    Aravindan Aravindan
    Discussions |
    Apr 18, 2017 12:54 AM
    4247 views | 0 replies
  • CCC Optimal

    Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,

    Lamine Lamine
    Discussions |
    Mar 17, 2017 5:25 AM
    3305 views | 0 replies
  • Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

    My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...

    kevinwtbolger kevinwtbolger
    Discussions |
    Feb 26, 2017 9:30 AM
    3327 views | 0 replies
  • Data Binding Associative Arrays

    I recently had need to create some slightly complex data structures and started to play with associative arrays a little more.  These are similar to dictionaries in other languages.  Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding.  Essentially it makes it so both the dictionary and the variable refer to the s...

    msharp msharp
    Discussions |
    Feb 14, 2017 1:53 PM
    4385 views | 0 replies
view all discussions