JMP Wish List

Currently depending on the size of data / data structure which I want to get the uniques from I use following: Data table column values Associative Array (if I'm lazy, but gets slow with lots of values) Summarize (a bit better, also slows down) Summary table and get values (I can get counts this way if I want to) Distribution platform and get values from Report layer (nice thing with this, is that I can get other statistics at the same time and it is fast) Lists Associative Array Insert values to table and use methods mentioned above My suggestion is to add specific function to get unique values from from data tables and lists in a list/matrix. It could be also data structure like Python's Set (and if were to be data structure  A set is an unordered collection with no duplicate elements. Basic uses include membership testing and eliminating duplicate entries. Set objects also support mathematical operations like union, intersection, difference, and symmetric difference. ... View more

What inspired this wish list request?  A Community Discussion item came in that had the need to separate into columns, each individual character in found in one of the columns in a data table.      What is the improvement you would like to see?  I would like to enhance the Text to Columns function to be able to specify an empty delimiter, which would indicate to the function to use each individual character as a new column   Why is this idea important?  It adds nice functionality to the function and it also makes the function more consistent with other JLS functions, such as the Words function.   ... View more

What inspired this wish list request?  JMP has multiple different ways to indicate if values are empty, missing or null and functions/operations might return different types when they have no values when compared to when they do have (and in Python the "pythonic" way would be just to check value in If-statement as the objects will be false Built-in Types/Truth Value Testing).   What is the improvement you would like to see? More universal JSL function to check if value is empty/missing/null/has no value. Below is one example for the function (hopefully others have additional ideas): Names Default To Here(1); Is None = function({obj, keep_zero = 1}, {Default Local}, /*"""Attempt to check if object is None (Empty(), ., 0, "", {}, [], [=>], [](0,1)... Args: obj: object to check Returns: int: 0 if non-zero and 1 if zero Examples: >> show(Is None([1 => 2])); Is None([1 => 2]) = 0; >> show(Is None(Associative Array())); Is None(Associative Array()) = 1; """*/ cur_type = Type(obj); return( If(Contains({"List", "Matrix", "Associative Array"}, cur_type), // check items in list, matrix and associative array !N Items(obj); , cur_type == "String", !Length(obj); // check string length, Is Missing() should also work , Contains({"Integer", "Number"}, cur_type), If(IsMissing(obj), 1 , keep_zero & obj == 0, 1 , 0 ); , cur_type == "Empty", 1; , 0; ); ); ); Print("Zeros:"); show(Is None([1 => 2])); show(Is None({"a"})); show(Is None([1])); show(Is None(1)); show(Is None("a")); Write("\!N"); Print("Ones:"); show(Is None(Associative Array())); show(Is None({})); show(Is None([])); show(Is None(0)); show(Is None("")); show(Is None(.)); show(Is None(Empty()));   Why is this idea important? Makes it easier to build comparisons without guessing which check should be implemented this time (IsMissing(), Is Empty(), N Items() > 0, Zero Or Missing()...) ... View more

What inspired this wish list request?  Participating in JMP Lab during JMP Discovery Summit Europe 2023 where I did use Projects (I don't really use them, but I do see that there could be potential) with multiple data tables and reports at the same time.    What is the improvement you would like to see?  One of the biggest reasons why I don't use JMP projects at all, is that it will contain all (non-modal) windows to the project. What I would like to see is to somehow limit which will be added to project (check box selector for different window types for example, JMP17 provides quite a few of different window types for example). Below is an example where Fit Y by X platform is contained in the Project but I would like it to open as the normal Launcher window like it would open from data table and then add the report to project when I click Run.   Why is this idea important? Improves the user experience of using JMP Project's by not containing everything inside the project.   ... View more

What inspired this wish list request? JMP is a great tool to help engineers and scientists use statistical methods with the best recommended options/choices. I have learned a lot with JMP about statistical methods and available method choices, and I'm very satisfied by the recommended options in some platforms (for example REML method for models involving random effects).  The "Augment design" platform is excellent. The different augmentation choices make the platform very powerful and convenient in a lot of use cases. However, I'm surprised to see that the option "Group new runs into separate block" is not checked by default, as this is a safe (and good) practice to check if there are any shift in the mean response between the first set of experiments and the next ones.    What is the improvement you would like to see?  I would like the option "Group new runs into separate block" checked by default, so that new users benefit from this safe practice when modeling the augmented DoE dataset. I wanted to change this in platforms preferences, but I wasn't able to find it ? I know this option makes the Space-Filling augmentation unavailable, but an information message just below the Space-Filling panel ("not available when using block") or below the "Group new runs..." option could help and inform the user why this option is greyed out.   Why is this idea important? As JMP promotes good and safe practices in statistics/modeling, I think it is important to recommend by default a safe and good practice in DoE augmentation. It can also help prevent any "bad surprises" when analyzing results for new DoE practicioners/beginners.     ... View more

What inspired this wish list request? In my work I paste large amounts of data from excel into an existing JMP file, and I sometime receive this error: "Data types of destination columns and source columns are different" due to a conflict in format between Excel and JMP. It is an easy but time-consuming fix, because I have to track down which specific column is causing the error.     What is the improvement you would like to see? In the JMP error, it would be nice to see the name of the destination column(s) which are triggering the alert, so I can change the data type of the column if needed.     Why is this idea important? This idea would help save time when aggregating data, and would solve users' problems of having to through their worksheet column-by-column in order to find the cause of the error.     ... View more

Hi everyone,   I'm using the functional DoE Platform and have to admit that it works really great. However, I miss the possibility to visualize the uncertainty of my models in the profiler. I think a lot of people could benefit from a feature which allows to add confidence intervals or CI's based on a bootstrapping approach. I would really apricate some upvotes for my idea ;)   All the best! /Marco ... View more

The PLS platform shows the percent variation explained for cumulative X and Y but it does not have the summary of fit or crossvalidation tables like other model platforms do.   Often times I wish to check the R^2 or RMSE of the training set versus my validation and test sets.   The only way I know to do this right now is to save the prediction formula and then put that prediction formula in to another platform such as Model Comparison.   It would be helpful to me to have the option to view those statistics within that very platform. ... View more

1) What inspired this wish list request?  ☑ cool new feature ☐ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2023   In GraphBuilder, one can drag a column onto the Color drop zone to use different colors for the individual items in the column - or to apply a color gradient depending on the values of this column.   By dragging 2 columns into the color drop zone, one can provide 2 columns -and then later specify via the variables list which of the two columns to choose. This makes it possible to apply independent color settings to different subplots, like in Graph Builder - subplot with different color settings?    Unfortunately, it's not possible to use more than 2 colors :(   2) What is the improvement you would like to see?  Please allow Jmp to use more than 2 columns in the Color drop zone.   3) Why is this idea important? It's possible to get up to 3 colors into the color drop zone, but the 3rd color doesn't work. It's there, it seems to work, but it doesn't do what it should do. The below code intentionally uses sex twice as color (1. and 3. entry). This is not the reason why it doesn't work - it just helps to illustrate the issue.   A comparison of the top and bottom plot shows that the top plot (which uses the third color column) has wrong colors (no blue points, the points are red) :( In different examples, the second color column was used instead of the third one.           Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); Graph Builder( Show Control Panel( 0 ), Variables( X( :height ), Y( :weight ), Y( :weight ), Y( :weight ), Color( :sex ), Color( :weight ), Color( :sex ) ), Elements( Position( 1, 1 ), Points( X, Y, Color( 3 ) ) ), Elements( Position( 1, 2 ), Points( X, Y, Color( 2 ) ) ), Elements( Position( 1, 3 ), Points( X, Y, Color( 1 ) ) ) )         more wishes submitted by   ... View more

As far as I can tell, the discussion here is still accurate for how to include a hyperlink in displayed text in a New Window to the user. None of the solutions presented are, in my opinion, intuitive, and often require hacking the UI together piece by piece just to include a hyperlink somewhere in the text.   It would be great if JMP would automatically find URLs in Text Boxes via regex and convert them to clickable links, preferably with a scriptable property on the Text Box to turn this behavior off. Alternatively, support for <a> tags when the Markup option is enabled would also work. ... View more

Highly regulated fields such as medical devices or pharmaceutical require that a statistical rationale for any design verification and validation activity is used. If a variable is continuous, the sample size for tolerance interval is a calculation based on the type of interval (1 vs. 2 tails), confidence, population coverage and margin of error. If a variable is an attribute, typically a count of conforming items, the calculation's output is an acceptance number (maximum number of non-conforming items that can be accepted in the experiment) and a sample size, based on confidence and population coverage.   Sometimes even the conformity of a product is defined on a such statistical basis, sometimes with numbers which are impossible to find in tables: Les contrôles des leucocytes résiduels dans les PSL sont effectués dans un délai maximal de 24 heures après la déleucocytation. De plus, les contrôles de chaque type de PSL, dans chaque établissement de transfusion sanguine (ETS), doivent montrer que, pour un calcul fait avec un degré de confiance de 95 % et en utilisant un plan d'échantillonnage adapté, les contenus ci-dessus doivent être respectés au minimum dans : 97 % de la production des PSL cellulaires déleucocytés ; 95 % de la production des plasmas à usage thérapeutique déleucocytés. (e.g. allowed white blood cells post filtration in France, 97% conformity with 95% confidence see link https://www.legifrance.gouv.fr/affichTexte.do?cidTexte=JORFTEXT000023140529 ) So these tools are common also in PCMF (post market clinical follow-up) activities or market monitoring.   It would be nice to see this topic covered in JMP.   Some links: http://reliabilityanalyticstoolkit.appspot.com/sample_size https://support.minitab.com/en-us/minitab/18/help-and-how-to/statistics/power-and-sample-size/how-to/sample-size/sample-size-for-tolerance-intervals/before-you-start/example/ https://www.qualitymag.com/articles/91991-sample-sizes-how-many-do-i-need http://www.cbinet.com/sites/default/files/files/Session12_Golden_Alan_pres.pdf https://www.mddionline.com/sample-size-selection-using-margin-error-approach   ... View more

When I write code, I try to make it easy to read, understand, and maintain.  I write comments.  I indent code blocks.  I use line breaks to spread the code out over multiple lines.  I try to write code with a consistent style.  However, I frequently find that JMP reformats my code without asking.  It simply decides to obliterate all the effort that I put into good coding practices.   For example, I write a script and attach it to a data table.  Then I right-click on the script and press "Copy" and then right-click in the script window and press "Paste".  The copy of the script does not contain any of the comments or code block indentions that were in the original script.   Another example:  I create a formula column on a data table.  Inside of the formula editor block, I write some JSL code to perform an iterative calculation (this is really cool. I just figured out you could do this!).  Of course I want to use comments and whitespace in this code, like I would in literally any code that I write anywhere.  Well, after I hit enter, the comments are invisible until I double-click on the formula editor block.  But they do exist.  Until I click OK and JMP evaluates the formula.  Next time I open the formula, comments and whitespace are gone.   It gets worse.  I have multiple scripts attached to my table that all reference a certain column.  Then I rename that column.  All of these scripts are updated with the new column name.  But in doing so, they are all "reformatted" by the JSL parser and all of my comments and whitespace are destroyed.  ಠ_ಠ   What is the point of even having comments in the JSL language if JMP is going to immediately wipe them out at the first opportunity?  Am I supposed to edit my JSL scripts in a less-hostile text editor (i.e. Notepad++) and store the readable versions as separate files?  I just don't understand why it has to be this way.  Please leave my comments alone!   Note: @Cwalla reported the same issue in the forums here  ... View more

I'm currently working on some larger JMP-scripting projects where version control is a must. With JMP14 I started to work with projects.    Committing & pushing my code to github manually is a bit of a pain. It would be great to have some very basic functionality like commit/push/pull integrated in JMP projects. ... View more

What inspired this wish list request? We have seen many instances where a JMP data table on a shared location has been opened by a user A and then by another user B (while it is still opened by A). Then both users modify the data table and want to save their changes. However, given that only user A has full read and write rights, user B will not be able to save his/her changes in the same data table and will recognize this issue only when trying to save the data table. Consequently, either all changes of B are getting lost (undesirable) or B changes his/her modified version as a new data table and needs to merge the A-modified and B-modified data table afterwards. Also this latter option is error prone, time consuming and undesirable. What is the improvement you would like to see? We do currently see two options with different complexities: (a) Simpler option: When opening the respective data table, each user gets informed if the table is already in use by another person and thus knows if/that they only have read but no write rights at this point in time. Ideally, in case the data table is already utilized by another user (say A), then user B gets informed which user is currently ‘blocking’ the data table. (b) Advanced option: Similar to documents in the MS Office environment, a multi-user interaction on the same document without any interference/issues would be most desirable.   Why is this idea important? This feature is helpful to all JMP users who work collaboratively on shared JMP data tables and thus run from time to time into the issues described above. Ultimately, it enables ‘true’ collaboration on JMP data tables and a vivid exchange of ideas, analyses, etc. that are all hosted within the same JMP data table as well as reduces frustration when trying to do so by e.g. removing the need to merge data table versions manually as well as data loss.   @martindemel ... View more

Could you please provide a function which takes as input: A jsl script The jsl version in which the script was written An provides a list of changes to all used functions as output  ... View more

☐ cool new feature ☑ could help many users! ☑ removes a „bug“ ☐ nice to have ☐ nobody needs it   The scripting index is a great source of knowledge and the examples are very useful to understand what the functions do and how they can be used (with some code context around the actual function).   On the other hand, for a user who wants to find a function for a specific application, the functionality of Scripting Index feels a bit like: If you don't know the correct function name, I cannot give you the correct info. https://community.jmp.com/t5/Discussions/Collection-of-quot-funny-quot-JSL-newbie-questions/m-p/559302/highlight/true#M77281    With some more "links" between the entries, a user can be guided through the Scripting Index and finally get to the function that he wants.   -> Please add fill "see also" with more alternatives along the idea: What possible confusions could have led users to search this function? e.g. there should be a link between Length/NItems  and  NRow/Dim   examples: https://www.mathworks.com/help/matlab/ref/length.html https://reference.wolfram.com/language/ref/Length.html compare: https://www.jmp.com/support/help/en/16.2/index.shtml#search/length    more wishes submitted by   ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   Indexing/Slicing of Matrices just works with indices which count from the start of the matrix: What is the JSL Matrix?    counting from the back or leaving the start or end open doesn't seem to work: Collection of "funny" Jmp newbie questions    my wish: add the missing functionality such that indexing like this is also possible: mat[1::-1]; mat[1::]; mat[::-1]; mat[::]; mat[::, x] is already possible as mat[0,x]   more wishes submitted by     ... View more

What inspired this wish list request?  While crosshair tool is useful to read the approximate values around the curves it would be good to snap on a smoother-ed curve that is closest to the crosshair.   What is the improvement you would like to see?  Snap feature on the graph.   Why is this idea important?  This will enable quicker and more accurate look at the curve values compared to going into the table.   ... View more

Some built in column formulas like Col Mean() are very fast because they only calculate expensive values once and return or modify them for each row.  With custom formulas this is harder to achieve because each row is evaluated separately.  Sometimes using a separate column to store intermediate values can speed things up (for example storing the row indexes that meet a certain criteria, instead of re-calculating them every row), but that gets messy and hard to follow. If there were some concept of a column context such that the evaluation of one row could access intermediate values calculated in the previous row, then a script could calculate results for all rows at once and then quickly return them and pass the intermediate results to the next row. The formula would also need access to the whole column instead of just the current row, so the column reference should be passed unevaluated. ... View more