JMP Wish List

☐ cool new feature ☐ could help many users! ☑ removes a „bug“ [~ lack of security] ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  If the Database driver doesn't allow the user to store the password in the ODBC settings, it is difficult to store database passwords in a secure and simple way.   Very insecure: store the database password as plain text in the JSL and table (!!!) script   With Jmp17 ,there is the new option to Hide ODBC Connection String which leads to the effect that  Database table scripts (Update from Database, Modify, etc.) or .jmpquery files stop working    Another option: Encrypt the code for the database connection:  JMP-and-Oracle-Tips-and-Tricks-for-a-Happy-Marriage But then it is essential to use a Run Password. Otherwise, everybody with access to the code has access to the data base. And the run password just shifts the problem - and makes it more difficult to automate it.   The best approach: Store the Password at a save location and give Jmp access  to the password: Set and get credentials in the Credential Manager via PowerShell on Windows  Unfortunately, this approach is not compatible with Query Builder.   What is the improvement you would like to see?  Include a credential manager / connection to Windows credential manager in the Query Builder to automatically store database passwords in a secure, well-defined and simple way. e.g. along the idea of @ih  Set and get credentials in the Credential Manager via PowerShell on Windows    Please add a functionality to Create Database Connection() and New SQL Query( Connection()) such that they can use the stored passwords as well.   Why is this idea important?  A secure, well-defined and simple way to manage credentials - this is where standardization can help a lot. The best: directly include it into the existing Query Builder ecosystem.         more wishes submitted by   ... 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 Query Builder in Jmp is nice to generate SQL queries via a GUI. But there are queries which cannot be generated via the GUI: Database access  With JMP 17, In the query builder, how can add "WITH UR" at the end of the SQL code?    The only solution at the moment: change to custom SQL - and at that moment lose all GUI options to make further changes to the query.   What is the improvement you would like to see?  Please improve the GUI to provide advanced SQL option: - add the functionality to "explode" entries and "index" column entries - allow the user to manually enter advanced SQL strings - which then can be added at specific positions of the main SQL query string.     Why is this idea important?  Users are not forced anymore to abandon the Query Builder when they have to add an expression to their query which is not supported by the Query Builder GUI.         more wishes submitted by   ... View more

☐ cool new feature ☐ could help many users! ☑ feels like a bug ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  In Jmp, there are 2 approaches to generate Transform Columns. 1) by talking to a data table: - the transform column is generated with Table Scope - so, the Transform Column "lives" outside the context of the platform it is generated for. - there is a Replace option: either a pre-existing Transform Column is replaced (setting: 1) or the name of the new Transform Column is adjusted (setting: 0) - The Transform Column is easily accessible, e.g. by using the return value of the command = handle for the generated transform column 2) by talking to a report 2b)  via platform << Transform Column() - this Transform column is generated in the scope of the platform - and will we deleted once the platform is closed -> very useful :) This is why this is the default approach how Transform Columns are used in Graph Builder, Summary and all the other platforms. - unfortunately, there is no replace option. If there is a Transform Column with the same name, the command is ignored (!) and the exiting Transform Column is used instead. -  unfortunately, Transform Columns which are generated by a platform are very hard to access: how to reference a Transform Column?  e.g. how to remove a Transform Column? What is the improvement you would like to see?  Although it works like designed, it definitely feels like a bug. It's hard for a user to understand that there are several tasks doable via the GUI which are not accessible via JSL.   Please improve the functionality of Transform Columns which are generated in the context of a Platform: return a handle for the column - - analogous to the one of the first kind of Transform columns add a replace option - analogous to the one of the first kind of Transform columns   Why is this idea important?  GraphBuilder has cool features to aggregate data via Summary Statistics - but important functions are missing, like CDF . Transform Columns provide a possibility to close such gaps - but the limited functionality of Transform Columns in the context of a platform make it difficult.   Example: If a user changes the selection in a Local Data Filter - how to update a Transform Column to account for the changes?         more wishes submitted by   ... View more

What inspired this wish list request? Other user messaged me and told that they couldn't save a project and it did take some time to figure out why it couldn't be saved (most likely due me not using projects)     What is the improvement you would like to see? Improve the content management within JMP Projects: Provide easy way to move all files which aren't currently self-contained into the self-contained project Allow saving project as self-contained I think currently you have to first figure out which aren't currently self-contained and then save them all from Save As menu Allow user to see which file is self-contained and which is not Can you tell me which of these are self-contained and which are not?  Maybe even provide a preference where projects would make all content self-contained automatically   Why is this idea important? Improves one of the things JMP Projects are supposed to be used for and good at: content management.     ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it     What inspired this wish list request?  My recent files list gets longer and longer - and it gets hard to find the important files. It helps to use the pinning option - but now also the list with the pinned files continues to grow recent files - grouping?      What is the improvement you would like to see?  please add a grouping option  - similar to a folder structure to group files. This will add some structure - and many hundreds of files will find their place in the subgroups.     Why is this idea important?  After some moths and years, it's difficult for Jmp users to find their important files. A grouping option with > 1 level will fix the issue.   related wish: Add Favorite Files window pane to JMP Home Window    I'd prefer the "folder structure".           more wishes submitted by   ... View more

What inspired this wish list request? Having ever increasing list of scripts and tables in my Recent Files, both pinned and non-pinned.   What is the improvement you would like to see?  Provide more customization to JMP Home Window. In this request I would suggest adding some sort of "Favorite Files" type of view (similar to Recent Files) in which you can change which Favorite list to show. User should be able to easily move files from Recent Files to Favorite Files menu.   Why is this idea important?  Makes it easier to launch different JMP files directly from JMP Home Window ... View more

Hi.  I've been writing scripts to automate visualization of distributions, fitting distributions, and reporting cpk.  I just finished a long one, and really found a lot of disparities in how the names of some distributions must be used.  This required a significant amount of debugging.  My ask is not a small one, but I would love if JSL could make usage of distribution names more consistent in order to make writing scripts more efficient and less confusing.  I will provide examples below.   My script takes a list of distribution names {"Exponential", "Normal 2 Mixture", "Johnson SU", ...} and first generates a table of random data with one column for each distribution.  It then creates distribution plots, fits the data, extracts the fit parameters for each distribution.  It also uses the Process Capability platform to compute cpk.  I rely a lot on creating JSL Quotes then substitution of the desired distribution name to get the exact code I need.   Issues: When I want to generate matrices of random data initially, I need to use "Exp" instead of "Exponential" and "Normal Mixture" instead of "Normal 2 Mixture".  J(100, 1, RandomExp(...)); J(100, 1, RandomNormalMixture(...)); J(100, 1, RandomJohnsonSB(...)); On the other hand, to fit a distribution to my data, I need to use "Exponential" instead of "Exp", "Normal 2 Mixture" instead of "Normal Mixture" and "Johnson" instead of "Johnson  SB": dt << Distribution( Continuous Distribution( Column(:colname1), Fit Exponential, Fit Normal 2 Mixture, Fit Johnson ) )  And again another naming scheme for the Normal 2 Mixture in the Process Capability platform: pc = dt << Process Capability( Process Variables( :colname1 & Dist(Exponential), :colname2 & Dist(Mixture of 2 Normals), :colname3 & Dist(Johnson), ) ) I had initially hoped I could just provide my script a list of distribution names to try, then have a for loop cycle through the list, adding the specific name to a JSL Quote, and then executing.  Instead I found out the hard way that I needed to create several if clauses to fix the distribution names for each different operation prior to substitution.   It would be great if all of this could be simplified by just using one set of distribution names for all functions and platforms.  Thanks.   [Using JMP Pro 17.2.0] ... View more

What inspired this wish list request?  Currently, when I trying to chose some samples from a plot of graph, it can only select by drawing a rectangular.  However, a lot of times, I need to select samples by a circular or oval shape, it's very hard to cherry pick each sample by using current method.    What is the improvement you would like to see?  Add a shape chose for select arrow, so we can chose if we want to select samples by drawing a circle or rectangular.    Why is this idea important?  Many company working on wafer like products, it's naturally a circle shape.  In this case, a lot of times, there are circular or oval shape defects, uniformity issue that need to be selected.  The user group is huge, since most semiconductor or other circular products company or manufacture need such tool to help.  It will be greatly saving time to have such selection shape.     ... View more

In fit parametric survival platform only 2 options of equation can be saved: save probability formula save quantile formula In majority of cases users of fit parametric survival platform are interested in equations of upper or lower confidence intervals for probability or quantile case.   I propose to add following save formula options to fit parametric survival platform: save lower/upper confidence intervals probability formula save lower/upper confidence intervals quantile formula   P.S. The names in fit parametric survival platform are inconsistent: time in profilers and Estimates of Survival is called time, while in Estimates of Quantile it called quantile probability failure in Estimates of Survival and P in Estimates of Quantile In fit parametric survival platform I propose to change: name of quantile to time  in Estimates of Quantile name of parameter P to probability failure         ... View more

What inspired this wish list request? We are using this as an introduction to JMP class. It would help if people can get completion certificate and send it to a contact when they complete the course.     What is the improvement you would like to see? It would help if people can get completion certificate and send it to a contact when they complete the course.     Why is this idea important? It would help if people can get completion certificate and send it to a contact when they complete the course.     ... View more

What inspired this wish list request?  I wanted to compute the uncertainty of prediction fastly and easily for predictive model without using bagging. Indeed, bagging is quite slow to compute with the profiler.   What is the improvement you would like to see?    I would like to save the all the trees formula when I use the Bootstrap Forest Plateform. Or at least the standard deviation of the distribution.     Why is this idea important?    This is very important for me to be able to compute acquisition function when I do Surrogate Model Optimization (Bayesian Optimization). I tried to use bagging with the partition plateform, but the result is not satisfactory. The gaussien process plateform do not deal with categorical variable.     ... View more

☐ cool new feature ☑ could help many users! ☑ removes a „bug“ (although it's mainly not a Jmp bug :) ☐ nice to have ☐ nobody needs it     What inspired this wish list request?    At the moment, when I want to share an interactive Jmp file via Teams or Sharepoint, my colleagues just see: ... and think that there is an issue with Jmp - or an issue with my Jmp file.   For them, it's hard to find out that actually it's a Teams / Sharepoint  issue with the interactive JavaScript code.   interactive html in Teams Channels    What is the improvement you would like to see?   for a future version of Jmp, would it be possible to slightly change the code of the interactive HTML? Instead of starting right-away with the start animation,  the HTML code could check if Java Code can be executed and if not: show a warning that it's actually the browser or the site which prevents the page to be loaded correctly. Then it could show a suggestion to download the file and open it from the hard drive.   Why is this idea important?  MS Teams, Sharepoint and Onedrive is used in many companies. Not every Company with Jmp licenses has a Jmp Live Server.   Therefore, users share interactive HTML files via Teams and Sharepoint - more and more in the future ....   If there are non-functional files, which were generated by Jmp,  this will "fall back" to Jmp. The new functionality will make sure that users understand the ussue and that they know how to make the files work.   Alternative solution: - Use in interactive HTML a code that is accepted by Teams/Sharepoint - align with MS how to solve the issue         more wishes submitted by   ... View more

What inspired this wish list request? When using this platform, if one or more variables are continuous, the analysis gives you a message to change the variable.     What is the improvement you would like to see? Since the platform knows the problem, it should offer me a way to temporarily or permanently make the change to the variables(s) without having to stop thew analysis. Make the change, then come back.     Why is this idea important? Will make the analysis more efficient.     ... View more

    Say you do the following, slightly modified from the scripting index: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); obj = dt << Process Screening( Grouping( :Site, :lot_id ), Process Variables( Eval( 5 :: 132 ) ), automaticrecalc(1) ); You'll get a report like this with rows for the different combinations of values from the Grouping() columns: And those rows act as a gateway to various plots.  For example,  you can get Process Capability or Control Charts that are pretty much as if you had used these grouping() columns as a By() on those platforms.  But you won't get a row for a grouping where any of the Grouping column values were missing or, if character, whitespace.  So if you replace a lot_id value with blank or a SITE with missing you don't see that appear on the report so you don't know there was some data that was like that, maybe needing attention.   When I discussed this with JMP support I was told that this is consistent with other JMP platforms, for example how X values that are blank don't show up on the X axis of a Oneway.  But my perspective is that Grouping() is a lot more like a By() in this case (which does make plots for the by groups with values of missing or blank).  The situation with Grouping() is also similar to summary/summarize which would recognize those groups and produce a row. I appreciate that Process Screening has a By() and Grouping() is not it, but I think there would be value in showing up these groups and providing access to the same plots you'd see from a by()  (ie if you ran Control Chart() with a by() on the same columns you would see a report for a missing SITE):     The upshot is that I was encouraged to after all make a Wish List item on this so this perspective could be considered.    I think it would at least be worthwhile as an option.   Why is this idea important?  The main issue/value is how starting from Process Screening as your gateway to the various other reports lets you miss some of your data or problems in your data.  This came to my attention while working with a customer with a large amount of data in many groupings with many levels per grouping and with data that comes from machine sources.  To some degree the Process Screening is advertised at letting you sift through lots and lots of processes and so it's a situation where the possibility that some data is defective - and that that could go unnoticed - is heightened.  This platform could even go so far as to highlight such groupings, let alone include them. ... View more

What inspired this wish list request?  I often find myself with new data tables that are almost identical to old ones.  I need to pull the plotting scripts from the old tables into the new ones.   What is the improvement you would like to see?  When I drag a script from the top-left pane of a data table window to another window, it looks like it's accepting it, but then nothing happens.  I would like to be able to copy a bunch of scripts from one data table into another via drag-and-drop.   Why is this idea important?   The script drag-and-drop is an intuitive action that seems to work, and it's frustrating that it doesn't.   (JMP v17, Windows and Mac)   ... View more

What inspired this wish list request?  The feature in Graph builder to stack multiple information to a hierarchical structure is very useful.   But the way how it is implemented is just good enough to generate data on work level. For publication or management meetings, it's way too complicated to analyze the axis title and convert the information to labels for the different levels of the hierarchy. Hierarchical X labels    Especially if the labels of the variants don't give a clear hint for the used column:   What is the improvement you would like to see?  Please improve the way how the graph is generated! e.g.: move the labels to the left add some lines   Why is this idea important?  After the proposed optimization of GraphBuilder Plots with hierarchical levels on the axes, no further postprocessing will be necessary anymore to use them for Publications and Management meetings :)       more wishes submitted by   ... View more

What inspired this wish list request? I was at the Greater Philadelphia Area Pharma JMP Users Group Meeting today and learned about the existence of the wish list from the JMP staff. I had requested this to a JMP representative at a different event a few years ago who told me to call JMP Tech support to make the request, but I never did.   I have "Box Plots" and "Plot Actual by Quantile" on by default due to my Platform Preferences for Fit Y by X with a continuous Y and nominal X. (This side-by-side plot is my favorite graph in JMP.) The red default is confusing because it does not match the legend color.   So, I usually change it by right clicking, selecting Customize...Customize Graph... then repeating Box Plot, Box Plot Line Color, and changing the color for each level of X.   Default red boxes misaligned with the legend   Color scheme aligned with the legend that comes with the Q-Q plot.     To make things worse there is a bug in JMP that I have not reported before, which I will report separately to JMP Technical Support. After I change all the boxes to black and save the graph to a script Window or a script in the data table my color customization does not stick. So, I have to redo my customization every time I make the graph. I am using v17.0 now, but I think this has happened as long as I can remember (>15 years). Today is the first day I figured out that changing the color to anything but black sticks in the script because I generally use black. (I know I could add the command lines to the script manually and resave it.)   All black boxes (not saved properly in a script):   What is the improvement you would like to see?  In Fit Y by X...Oneway, Box Plot, the box color should have an option to be other than red in the Platform Preferences. One choice could be black. Another could be the same color scheme used by "Plot Actual by Quantile".   Why is this idea important? Red is confusing for side-by-side box plots when the legend for the normal quantile plot has red to indicated the group with the first level of X. Red is confusing when the dot plots under the box plots have different colored symbols, and one of them is red. Black would work because other elements of the graph are in black.  The same color scheme used by "Plot Actual by Quantile" would work, especially when the Q-Q plot is part of the same graph to the right of the box plots and using the same Y-axis as the box plots.   ... View more

☐ cool new feature ☐ could help many users! ☑ removes a „bug“ ☐ nice to have ☐ nobody needs it What inspired this wish list request?  from @ https://community.jmp.com/t5/Discussions/How-to-know-if-a-table-is-a-linked-subset/m-p/655280/highlight/true#M84437  If I try to concatenate tables with the option Append to first table, the script stops with the message:   Cannot append to table: Big Class. Possible reasons for this include: the table is locked, the table is in a platform with a by group, or there is a linked subset of the table. in access or evaluation of 'Concatenate' , Concatenate(/*###*/Data Table( "Subset of Big Class" ), Append to first table)     The error message was very helpful to identify the issue. But how to make the script robust against linked subsets?   What is the improvement you would like to see?  An addition function: dt << get list of linked subsets() will help. Then I can close the subsets via JSL.     Why is this idea important?  code won't crash if there are linked subsets. Alternatives: Jmp updates the linked data tables Jmp cuts the link automatically concatenate get a new option: Jmp_is_allowed_to_close_linked_data_tables_if_this_is_needed_to_run_this_concatenate(1)        more wishes submitted by   ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ (either 1 &2 or 3) ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  Color by Theme in Graph builder is very cool! It can save the users a lot of manual fiddling around with the colors: Color by Theme -> cool feature!  The person who implemented this features deserves an award!   Unfortunately, this feature is missing for Point Plots   What is the improvement you would like to see?    Color by Theme for Point plots   Why is this idea important?  It will save many Jmp user N x some minutes of work - every day. ... View more