JMP Wish List

What inspired this wish list request? For many users JMP is the standard application for data analysis, and Sharepoint is the standard collaboration platform. That Sharepoint can not be used in a safe and convenient way to share JMP files is a substantial drawback for many companies. See earlier wish of @hogi for more details: Optimize Sharepoint Integration - JMP User Community The planned data connectors the way I understand will not fix this issue.   What is the improvement you would like to see?  I would like to see a builtin capability of JMP to: open a file from Sharepoint (and lock it in readwrite mode if not already locked, if already locked open it in readonly mode) possibility to work with that file like with files from other sources and close+save the file after making changes (and release file on Sharepoint for others to change)  Seemless integration (many users working together in one JMP file) is not possible in overseeable future, but above features are feasible and reasonable in my opinion.   Why is this idea important?  JMP's inability to work with SharePoint disrupts our company's workflows and requires additional ressources and opportunities for errors in dealing with it.     ... View more

What inspired this wish list request?  Trying to copy the script created by Recode and realizing that it is not even close what I could achieve with JSL and simple functions already provided by JMP.   What is the improvement you would like to see?  Update the methods used in Recode to utilize more modern methods. There are many examples of this but here is one using value codes (the "issue" generally happens when Recode starts relaying on the Map Values and you end up with all hard-coded values) Will create messy code   // Recode column: name Local({dt}, dt = Data Table("Big Class"); dt << Begin Data Update; dt << Recode Column( dt:name, {Num(_rcNow), Map Value( _rcOrig, {"ALFRED", 1, "ALICE", 2, "AMY", 3, "BARBARA", 4, "CAROL", 5, "CHRIS", 6, "CLAY", 7, "DANNY", 8, "DAVID", 9, "EDWARD", 10, "ELIZABETH", 11, "FREDERICK", 12, "HENRY", 13, "JACLYN", 14, "JAMES", 15, "JANE", 16, "JEFFREY", 17, "JOE", 18, "JOHN", 19, "JUDY", 20, "KATIE", 21, "KIRK", 22, "LAWRENCE", 23, "LESLIE", 24, "LEWIS", 25, "LILLIE", 26, "LINDA", 27, "LOUISE", 28, "MARION", 29, "MARK", 30, "MARTHA", 31, "MARY", 32, "MICHAEL", 33, "PATTY", 34, "PHILLIP", 35, "ROBERT", 36, "SUSAN", 37, "TIM", 38, "WILLIAM", 39}, Unmatched(_rcNow) )}, Update Properties(1), Target Column(:name) ); dt:name << Remove Value Labels; dt:name << Value Labels( {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39}, {"ALFRED", "ALICE", "AMY", "BARBARA", "CAROL", "CHRIS", "CLAY", "DANNY", "DAVID", "EDWARD", "ELIZABETH", "FREDERICK", "HENRY", "JACLYN", "JAMES", "JANE", "JEFFREY", "JOE", "JOHN", "JUDY", "KATIE", "KIRK", "LAWRENCE", "LESLIE", "LEWIS", "LILLIE", "LINDA", "LOUISE", "MARION", "MARK", "MARTHA", "MARY", "MICHAEL", "PATTY", "PHILLIP", "ROBERT", "SUSAN", "TIM", "WILLIAM"} ); dt << End Data Update; ); when it could be done with single line (since JMP17):           dt:name << Labels to Codes; Example of the methods which are difficult to utilize outside of recode are group similar values   And we will end up with Map Value instead of nice "grouping" script Names Default To Here(1); Local({dt}, dt = Data Table("Big Class"); dt << Begin Data Update; For Each Row( dt, dt:name[] = Map Value(dt:name, {"MARY", "MARK"}, Unmatched(dt:name)) ); dt << End Data Update; );   I can write script to do this myself (and I have done it) but would be great that it was easily exposed to users via JMP created script.   Why is this idea important?  Users are able to capture more efficient code with less hard-coded values     ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  Scripting Index - User defined examples    #myTop10_2025 What is the improvement you would like to see?  There are great examples in the community which could be added to the Scripting Index. Every user has its own interestes, so a nice trick: give the user the chance to add his / her preferred ones.   Why is this idea important?  Better link between Scripting Index and Community. other wishes from  ... View more

☐ cool new feature ☑ could help all Jmp users! ☑ removes something that feels like a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  In Jmp18, a warning message appears for EVERY user - EVERY day - EVERY time Jmp is started  ... unfortunately: already months before Jmp expires. Unlike a splash window, the pop-up window remains in place until the user closes it manually.   This is how it looks like:   What is the improvement you would like to see?  Please - remove the warning message [either: completely, or: after 3 seconds] - just show the warning message 1 - 2 x before it gets disabled [automatically] or: - add an option to disable the warning message (like for the startup splash window).   Why is this idea important?  less confusion for JMP users no annoyed license site managers   other wishes from    TS-00143027   ... View more

What inspired this wish list request? We currently use Statistica to send out emails when there is an out of control data point and we are able to embed the image of the control chart into the body of the email.  I also have daily reports I make in JMP that I save out a PDF and then have to manually grab each morning and email out to user groups.  If I am out unexpectedly this causes issues for user groups that rely on my reports.    What is the improvement you would like to see?  I would like to see the ability to have JMP Live allow embedding of Images and attaching of files.  This would be a feature to use for control chart alarming but also as a stand alone feature to send out a file to a user group from any analysis.   Why is this idea important?  Many users either only have access to their email (such as being on their phone way from a computer) or need to be able to print an output from JMP to post in their manufacturing areas.  By allowing automatic file generation AND Distibution this will greatly enhance the ability of Engineers to automate routine tasks as well as expand the use of JMP for enterprise systems and eliminate the need to use something like PowerBI for Manufactuing reports and SPC. ... View more

What inspired this wish list request? A change was noticed in upgrade from JMP 17 to JMP 18 where all table column names are automatically alphabetized rather than following programmed order.     What is the improvement you would like to see? Return to previous setting where the table column order is how the table was built.     Why is this idea important? Increased burden on large tables to reorder.      ... View more

☑ cool new feature ☐ could help many users! ☐ removes something that feels like a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  In JSL there are functions like  is control key() to get the current status of modifier keys,   unfortunately,  This function does not return the current state of the control key but rather the state of the control key at the start of another event like mouse click or key press.  Checking for modifier keys (ctrl, alt, shift) in script without mouse trapping      What is the improvement you would like to see?  As  JMP does have an internal function to get the modified key state at any time but this is not exposed via JSL. Checking for modifier keys (ctrl, alt, shift) in script without mouse trapping  ... could you please provide a JSL function to expose the current status of a modifier key :)     Why is this idea important?  This will allow JSL programmers to generate Toolbars and commands in the menu on a completely new level: depending on the status of a modifier key, different actions could be triggered (!!!)   similar add-on functionality could also boost standard platforms: - A user could specify a DEFAULT action in the preferences. If a user clicks on Subset, Summary, Tabulate, Graph Builder - holding SHIFT - the DEFAULT action is executed ... without any need to manually enter the settings. - with a control key, the action could be triggered with the RECALL settings.   other wishes from  ... View more

☐ cool new feature ☐ could help many users! ☐ removes something that feels like a „bug“ ☑ nice to have ☐ nobody needs it   What inspired this wish list request?  JMP can export animated gif files. but such files cannot be opened by jmp.   What is the improvement you would like to see?  Please provide a way to open and display animated gif files.     Why is this idea important?  Hm, important? It will allow the users to generate very fancy GUIs! other wishes from      ... View more

What inspired this wish list request?Managing a large number of jmp installations can be complicated when it comes to updating and /or harmonizing versions within a company.   What is the improvement you would like to see? On major release installation, it will be fine if InstallShield could ask this question: An older jmp version was detected, would you like to install the new version (and keep the old one) or update jmp?   and something that will be good too, keep the users preferences on major update from old to new release.     Why is this idea important? Facilitating the deployment of jmp in companies where the software is managed ... View more

☑ cool new feature ☑ could help a lot of Jmp users! ☐ removes something that feels like a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2024   What inspired this wish list request?  With the new seamless Python Integration in Jmp18 , it's now much easier to transfer small tasks to Python.   e.g.  - JSL: read a file - Python: compute new columns - JSL: make Principal Component Analysis - JSL: Plot Data in Graph builder - use Make into Data Table -> dt2 - process dt2 in Python ... - JSL: plot the result in Jmp   Such a ping pong between Jmp and Python was already possible before, option 1) Use inline Python code within the JSL code -> very hard to debug option 2) write the actual code in Python , 'import' is as a whole via JSL   new: write the main code in Python - with some JSL calls within the Python code. -> same issue as with option 1: hard to debug the inline code (slightly reduced issue as JSL is not as strict with the indentation as Python)   What is the improvement you would like to see?  Please allow Workflow Builder to accept JSL and Python code.   At the moment, the Workflow GUI asks for JSL code:   Just add an option to choose between JSL and Python (or any other code which is allowed ...)     Why is this idea important?  It will help in both directions::  - facilitates Python integration (Python can be included as an intermediate step without additional effort) - significant improvement for Workflow Builder (no limits)     more wishes from     ... View more

☐cool new feature ☐ could help many users! ☐ removes a „bug“ ☑ nice to have ☐ nobody needs it   What inspired this wish list request?  How does one perform Bitwise operations in JMP formulas?  How do I perform bitwise xor operations between columns with 44-bit binary data?    What is the improvement you would like to see?  Native function for bit operations like XOR, shift bits, split bits, get bit, set bit.   Why is this idea important?  could help users who want to do bit operations in Jmp.   more wishes submitted by       ... View more

Our company is now using automated scripts in JMP connecting to our Laboratory management system, LIMS, to pull data for SQC reports.  These need to be reviewed for 'bad data' prior to sending to customers.  Samples undergo multiple tests which need to be arranged in columns - 1 row per sample.  Most of the 'bad data' relates to a single test (maybe a typo or a measurement special cause) so we don't want to exclude the whole suite of testing just to remove that single point. JMP's row structure to data currently means the only way this is possible is to exclude values in column properties or delete the value from the cell.   ... View more

☑ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  The Group By concept in Jmp is sooo useful! You can find it everywhere. e.g. in Graph builder one can use X/Y groups to generate split graphs - and summary statistics will automatically give the correct results for every single graph. In Platform menus, there is a By option - which splits the data into groups and every group is analyzed separately. Under the porcellain layer, there are more group by options, like the Col aggregation functions (e.g. Col Median(:height, :sex)) which automatically return separate aggregated values for groups of rows.   What is the improvement you would like to see?  Please use such Group By options wherever it is possible. let's see if other users find more places where Group By could be useful ...   here I want to focus on a Col Grouped Interpolate function which can be used in a Column Formula like New Column("interpolated", Formula(Col Interpolate(:newX, :height, :weight, by(:sex)))) It should generate an interpolation for :weight by :height - split by subgroups M/F in :sex - and use the interpolation to calculate values @ x values :newX.   In a similar way, the existing Interpolate function could be lifted to a new level by providing an argument  BY() which can be used to interpolate subgroups [for this case, I think an additional argument for()is needed to specify the groups of interest and their order] Grouped Interpolate    Interpolate(myheight, :height, :weight, by(:sex), for({"F","M"}))   Definitely worth to have it - which can be seen by the fact that users invested the time to program their own grouped Interpolate to get the results: https://community.jmp.com/t5/Discussions/Grouped-Interpolate/m-p/692358/highlight/true#M87807    Why is this idea important?  Group By is one of the concepts which makes Jmp a million times more useful for exploratory data analysis  than Excel . use this concept at as many locations in the program as possible.         more wishes submitted by   ... View more

What inspired this wish list request?  Accessing the Text to Columns utility from the main Cols menu is cumbersome and inefficient.   What is the improvement you would like to see?  Enable Text to Columns Utility to be accessed by riht-clicking the column and from the Column manager. Potentially also allow the utility to be simultaneously operated on multiple columns.     Why is this idea important?  Increased efficiency and ease of use.   ... View more

☐ cool new feature ☑ could help many users! ☑ removes something that feels like a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  A task that puzzles many new Jmp user at some point: how to create a formula column with a column reference (or a constant) that is pre-defined and stored in a variable. Use for loop variable in a formula  Use expr() to replace variable column names in a formula  JSL: How to pass a variable to a column formula  New Column Formula with JSL  How to use a variable value in a formula  Need help with expressions, column references, formulas and column renaming  Creating Formula Columns in a For Loop  Apply a formula from a list  Adding Formula Columns based on Column Name List    The good news is that an experience user can choose from a range of solutions: Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute   On the other hand, before a user gets aware of the issue, reads the manual, finds a community post or asking for help in the community, ...  he will just start with the most simple approach: use the bare column reference (or constant) within the formula.   Then Jmp will display an error, the column formula will not work - or the formula will not work anymore after a restart of JMP.   What is the improvement you would like to see?  For an experienced user, it's very easy to identify the issue and to correct it.   So, maybe, a Jmp "Copilot" could detect the issue as well and guide the user to a solution, e.g. by providing a link to Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute   Is it possible to automatically correct the code? via right click, maybe Jmp could automatically add an  Eval(Substitute(...)) which replaces a placeholder with the variable that was defined outside of the column formula.   Why is this idea important?  New users will lose less time identifying the error + searching for a solution.   The application case of a column reference in a column formula is the most common use case, but in principle, the same Copilot could also detect and fix similar issues where variables are not evaluated before handing them over or where variables are evaluated too early before they are handed over to the next function.   more wishes by   ... View more

☑ cool new feature ☑ could help many users! ☑ removes something that feels like a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2024   Short:  Let JSL Editor show which function evaluates it's arguments and which function doesn't!   Long:   What inspired this wish list request?  There is a very powerful behavior in JSL which, on the other hand, makes it difficult for new users to get started without hiccups: Some Functions evaluate their arguments and others don't.   This is very important for functions which are used for expression handling. There is a wonderful lecture by @joseph_morgan : Using JSL to Develop Efficient, Robust Applications (EU 2018 415) on the differences, how to live with them and how to use them to develop efficient and robust applications.   ...  describing the status at that time: Jmp 14 [2018]: This doesn't exist in the documentation. This is something I figured out [ ] by reverse engineering the behavior of expression handling functions. Trust me, [ ] if you do not think of these functions in this you will never get them right.   Besides the expression handling functions listed here, the same holds for all function: if you do not think of these functions in this you will never get them right: It's highly important to know if an argument gets evaluated before the function call of not.   Does this code work or doesn't it?!? dt = Expr(current data table()); myscript = Expr(get script()); dt << myscript   Unfortunately, for the JSL scripter there is no hint how the function behaves - does it evaluate its arguments or not? Maybe it just evaluates one of the arguments? Who knows? The user has to know! ... or: reverse engineering the behavior of the respective functions.   What is the improvement you would like to see?  Please implement some syntax highlighting to indicate the different ways a function evaluates - or doesn't evaluate its arguments. Add-On: Please also indicate the difference in the Scripting index.      In JSL editor, the highlighting can be activated/deactivated via a keyboard shortcut.   The Expr(_x_^2) show kind of dilemma: the argument of Expr () doesn't get evaluated. But the two arguments of ^ would get evaluated. Maybe the highlighting reacts on the position of the mouse or cursor -  just the arguments below the branch are highlighted where the mouse/cursor is currently located.   Why is this idea important?  With the new syntax highlighting, JMP will guide the user automatically to generate the right code. The user doesn't have to run the code to get an error message - or to see the wrong result ... or to reverse engineer the function - like @JosephMorgan had to do to prepare his paper.   other wishes from  ... View more

☑ cool new feature ☐ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  edit: first part shifted to Expression Indexing: How to climb the Expression Tree?  Thanks @jthi for providing a solution: Via  Extract expr a user has the possibility to search and extract parts of Expressions. The function provides a pattern search and returns the first match.   Even Wildcards are possible :)   What is the improvement you would like to see?    A mixture of Display Tree Indexing and Data Table Indexing - just for expressions:   A more precise read access via: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myExpr=Expr(gb = dt << Graph Builder( Size( 437, 413 ), Graph Spacing( 4 ), Variables( X( :height ), Y( :weight ), Y(:height), Overlay( :sex ) ), Elements( Points( X, Y, Legend( 1 ) ), Smoother( X, Y, Legend( 2 ) ) ) )); //instead of: Arg(Arg(Arg(Arg(Arg(myExpr,2),2),3),3),1) // I want to use: myExpr[2][2]["Variables"]["Y"(2)][1] //assign // send // Graph Builder // Variables // or like it's possible for Display Trees: myExpr["Variables"]["Y"(2)][1]   Where it gets really cool: write access similar to what's is possible via Data Table Indexing: myExpr["Variables"]["Y"(2)][1] = Expr(:height); Like Substitute - but in a different dimension! [edit] And maybe the best application of Expression Indexing:  Insert Into , e.g.: Insert Into ( myExpr["Variables"], Expr(Y(:age))) Why is this idea important?  With the Power of Expression Indexing, Expression Handling in Jmp will get easier :)         more wishes submitted by   ... View more

What inspired this wish list request?  Developing Python code to run in JMP typically involves cloning a Github repository and pointing JMP to the local copy of the code as so: jmputils.jpip('install','myrepo c:\\pathto\\myrepo')     What is the improvement you would like to see?  Provide a mechanism (button, API, ??) for the user to restart the Python kernel, without having to close and re-open JMP.   Why is this idea important?  During code development, there are numerous changes to the local code, each requiring the new code to be loaded into the Python kernel.  Currently, the only way to get new local code loaded into the Python kernel is to close and restart JMP.  This slows down development significantly and could be a blocker for some developers.      ... View more

The main data source for new JMP users will always be Excel. These can be messy, and probably used as database with manual input for KPI tracking, for example. However, neither the Excel add-in, nor the Excel wizard provide a simple way to update file from its source. This is a common request that can be found in this forum, multiple times, and all of them require scripting (see examples below). You can see the understandable response of beginners, that are drag into a complex solution to a simple request. Updating columns, adding new rows, adding new columns, all of these are complex concepts that require several steps and getting into automation via JSL or Automation Builder. JMP needs to include a wizard to automatically generate a script that reads and updates the current data table in place. https://community.jmp.com/t5/Discussions/Automatically-update-quot-source-quot-file/td-p/324299 https://community.jmp.com/t5/Virtual-JMP-Users-Group/How-to-update-a-JMP-data-table-to-reflect-Excel-updates/td-p/228625 https://community.jmp.com/t5/Discussions/How-do-I-automatically-update-JMP-data-table-while-populating/td-p/247303 ... View more