cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Find courses, tutorials, and lots of other methods of learning JMP.

view all learning resources

Latest Discussions

  • Can I get a "rolling standard deviation" as a formula a table?

    I have a time series data set, and what I'd like to do is see if the value of one column (a key performance indicator, KPI) is related to the variability in another column (a process variable, PV).  I think what I'd like to do is to calculate the standard deviation across the n previous and m future data points to get an estimate of how much the PV is moving about and then plot that as x vs. the K...

    CSSanderson CSSanderson
    Discussions |
    Sep 27, 2023 11:16 PM
    5656 views | 7 replies

  • script to select all cols that contain a list of values?

    I've got a large dt (70k cols, character) that I'm digging through. Most cols have a wide range of values, but a noticeable population of them have only two nuisance values. I want to identify all these cols and then dump them.

    Any advice? These nuisance cols will contain ONLY the terms "**skipped**" or "dne".I've already dumped all cols that contain a single record value.  

    LambdaMarmoset7 LambdaMarmoset7
    Discussions |
    Sep 27, 2023 10:49 PM
    965 views | 2 replies

  • JSL: how to group all columns by common initial term?

    I've got a dt (70k cols) that I'd like to group into common bundles, based on the initial delineated terms. For example, 10K cols each that all start with "ChamberID", or "RecipeID", or "SlotNo". How can I script this to churn through the dt to find all common cols, group them into a collapsible bundle?  

    LambdaMarmoset7 LambdaMarmoset7
    Discussions |
    Sep 27, 2023 10:43 PM
    1089 views | 2 replies

  • Python error in automated powerpoint creation

    Hi everyone, I have a JSL script that outputs about 10 graphs in individual windows. I am working on a way to input each graph into its own slide in a powerpoint. Due to the complexities of the pictures I saw there was a way to use python's python-pptx package to accomplish this and I am able to create all the slides with a title but am unable to get the picture into the powerpoint at all. Below i...

    neelsrejan neelsrejan
    Discussions |
    Sep 27, 2023 9:15 PM
    4840 views | 7 replies

  • Scripting: Save SQL Query Results in Project

    Hi, probably a newbie question, but I couldn't find a solution myself: I want to save the table generated by an SQL Query via a JSL into a project. The code is below; labels, etc. were omitted. Unfortunately, the dt seems to be deleted after running the query in background. Is it a timing issue? Thanks for any help.   query = New SQL Query( Connection(""), QueryName(""), Select(Column("", "t1...

    UEJ UEJ
    Discussions |
    Sep 27, 2023 5:22 AM
    1390 views | 2 replies

Latest Discussions

  • script to select all cols that contain a list of values?

    I've got a large dt (70k cols, character) that I'm digging through. Most cols have a wide range of values, but a noticeable population of them have only two nuisance values. I want to identify all these cols and then dump them.

    Any advice? These nuisance cols will contain ONLY the terms "**skipped**" or "dne".I've already dumped all cols that contain a single record value.  

    LambdaMarmoset7 LambdaMarmoset7
    Discussions |
    Sep 27, 2023 10:49 PM
    965 views | 2 replies

  • JSL: how to group all columns by common initial term?

    I've got a dt (70k cols) that I'd like to group into common bundles, based on the initial delineated terms. For example, 10K cols each that all start with "ChamberID", or "RecipeID", or "SlotNo". How can I script this to churn through the dt to find all common cols, group them into a collapsible bundle?  

    LambdaMarmoset7 LambdaMarmoset7
    Discussions |
    Sep 27, 2023 10:43 PM
    1089 views | 2 replies

  • Control Charts--Cartes de contrôle: problème d'affichage

    bonjour,   avec la version 17.2: j'ai des cartes de contrôle qui dépassent l'affichage dans l'écran.  je constate que dans le script de la carte de contrôle, vient s'ajouter une ligne (voir en bleu) que je n'avais pas dans les versions précédentes.   existe-til une solution pour avoir la carte s'afficher à l'intérieur de l'écran?   cordialement

    Françoise Françoise
    Discussions |
    Sep 27, 2023 2:28 AM
    1000 views | 1 replies

  • Prediction profiler with nominal variables

    Hi all!I have 6 continuous variables (N0 to N5) and one nominal variable (named "recode") that I would like to analyze with the prediction profiler. The nominal variable "recode" has 4 values (1,2,3,4).When I initiate the prediction profiler, the nominal variable is "broken" into three sections (see image below).How do I interpret it? for example, how to I set the profiler to show the predicted va...

    Lavik17 Lavik17
    Discussions |
    Sep 27, 2023 12:15 AM
    1854 views | 4 replies

  • How do I change the number of decimals shown in a formula in a graph?

    Hi all
    I want to change the format of the decimals in a linear formula, shows on a graph, I want only two digits after the decimalI attached here a picture of the graph that I prepared and the arrow shows the number I want to change
    thank you

    Efrat_Schwartz Efrat_Schwartz
    Discussions |
    Sep 26, 2023 4:43 PM
    2096 views | 3 replies

Latest Discussions

  • What determines which data table is seen as "Associated Data" for New Window?

    What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)?   This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...

    jthi jthi
    Discussions |
    Sep 21, 2023 9:44 AM
    729 views | 0 replies

  • Using R - File path problem

    I have difficult to get the filepath correct. 
    Error message says "Cannot open table in access or evaluation of ....(Filepath)"   

    Prometheus Prometheus
    Discussions |
    Sep 17, 2023 10:46 PM
    840 views | 0 replies

  • Data Access Handler

    How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties.  But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...

    hogi hogi
    Discussions |
    Sep 16, 2023 12:21 AM
    556 views | 0 replies

  • Use JMP Locale Settings( 0 ) not working on macOS

    It seems the following command does not work for JMP MacOS.   Use JMP Locale Settings( 0 )   Is there a general script to deal with the following scenario? Or do we need to put conditionals depending on the OS of the user? // Configuring JMP to save CSV as commas and not If( (Num( "3.14" ) == 3.14), is_EN_num_format = 1, //"English numeric format" is_EN_num_format = 0 //"Non-english"); )...

    FN FN
    Discussions |
    Sep 15, 2023 10:21 AM
    669 views | 0 replies

  • Inherited Plot settings

    Hi,
    I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like

    One example:
    If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...

    hogi hogi
    Discussions |
    Sep 14, 2023 11:11 PM
    648 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

More on the many advantages of structural equation models

 view all blog articles

Learn more about JMP's premier analytics conference