JMP Wish List

In JMP 14, GraphBuilder Bars with a patten have an outline.  Bars with no pattern or solid, have no outline.  I typically use a white graph background. But whatever the background color, if a bar has the same color as the background color, it is indistinguishable from the the background.   Having a white background, means I cannot have a  solid, white bar. ... View more

☐ cool new feature ☑ could help many users! ☑ feels like a „bug“ ☐ nice to have ☐ nobody needs it   Short: Remove this "bug": ... and this one:             Long: What inspired this wish list request?  If reports are open, Jmp is not able to sort a data table: https://community.jmp.com/t5/Discussions/How-to-update-table-after-sorting/m-p/659014/highlight/true#M84836    Same issue for data tables with linked subsets: sorting and concatenating data to the data table doesn't work. Similar issue if a user wants to add rows to a data table .   linked subset: sort → no add rows → no concatenate → no   open report: sort → no add rows → yes concatenate → yes   What is the improvement you would like to see?  Please remove the restrictions.   e.g. "cut the link", like it's done for linked summary tables: sort → no [why does SORT not "cut the link"?!?] add rows → yes² concatenate → yes²   ² JMP automatically cuts the link:     Why is this idea important?  It's very likely that a user opened a linked subset, a linked summary table or a report before he tries to sort a table or add new rows. Therefore, JMP users face this issue very often.       more wishes by     ... View more

DUPLICATE OF Allow secondary or alternate column names  ☑ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it #myTop10_2024   What inspired this wish list request?  Often incoming data is quite cryptic and some data curation is needed. Jmp already provides nice solutions, which help the user to curate the data "on the fly", like recode.   Many of the curation steps are "persistent" - such that no further curation is needed when the data table gets updated with the latest data: - formula columns - column property: Value Label - ...   A special issue are column names: Ho to handle cryptic Column names?  Here there is a clear trade-off between human-readability and compatibility to incoming data.   - The user might rename a column -  but then the data table cannot be updated anymore. - the user might add an additional column with the correct name and link it to the original column by a column formula - but this approach is just useful for a few column names. - possibility to give columns different names in different languages - save the alternative name as a new column parameter + Script to toggle between original and alternative column names.   https://community.jmp.com/t5/Discussions/Ho-to-handle-cryptic-Column-names/m-p/722751/highlight/true#M90501    I guess everyone has found their own workaround to deal with the problem. Surprisingly, there is no "official" solution, like column alias   What is the improvement you would like to see?  Please add a new column property: Column alias If a column alias is defined, - the alias column name replaces the column name in the table header, all lists, reports, plots and views. - the alias column name can be used alternatively in filters (so the user can search with the original and the alternative name) - it can be used in Table operations like update and concatenate - as an alternative to the original column name     Why is this idea important?  Significant simplification of data curation :) more wishes submitted by   ... 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?  Some functions in Jmp take a very long time to get finished. There is a request toSpeed up Tables/Update , because it can take hours to be executed. "Get rows where" is taking way to long  Another issue: Life Distribution. Depending on the size of the data table, the user has to wait for hours: https://community.jmp.com/t5/Discussions/how-to-make-cumulative-probability-plots-in-JMP/m-p/717879/highlight/true#M89957 another application case: Database queries. They can be executed in the background. But then the query cannot be included in a script. The next part of the script has to wait for the data to arrive. Would be great if there was an option to interrupt the query if it takes too long.   For all these cases, it could help to cancel the activity after a specified Timeout interval:   What is the improvement you would like to see?  Option: For Try(), please add a possibility to specify a timeout interval. If the execution of the code takes longer, the script is stopped and the table is reverted to the initial state.Timeout of the try function   Please add a timeout parameter in the preferences. if the user specifies a timeout of 10 minutes, If starting a platform or executing an action takes longer than 10 minutes, the execution is stopped. For actions which alter the data table, the table is restored to the point before starting executing the action. This should be possible because most actions in Jmp have an undo function. I guess a recovery point is stored before starting the action?   Why is this idea important?  There is a Wish from 2020 with 79 Kudos:Kill process without killing JMP ! So, it seems that there is an extreme demand here, but it also seems to be extremely complicated to fulfill the users' wish.   The Timeout concept could be an easy solution. Every user will accept to wait 10 minutes (and get a coffee - or two) instead of losing the results of many hours because an action in Jmp takes orders of magnitude longer than the user expected. more wishes 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?  It's great that there is a list of "builtin" presets in the Format Pattern dialog. Unfortunately, some of our files use  2-3 additional formats which are not in the list.   What is the improvement you would like to see?  Please provide an option to store the current pattern to  "user defined" in the list of presets.   Why is this idea important?  Once a user encountered a format pattern that is not in the list  it is very likely that he will see it again and again - especially when loading the same type of data. Then it could help a lot if the user could specify the special patterns on the first encounter and all the other times: just pick the stored pattern from the list. more wishes by   ... View more

What inspired this wish list request? Need to be able to match background color in Graph Builder to certain value in gradient legend.     What is the improvement you would like to see? Add ability to use an eyedropper to sample a color from within or outside of JMP and be able to set that color for lines or background.     Why is this idea important? Further flexibility in visualization capabilities.   ... View more

  JMP for PC allows users to create new toolbar buttons, but JMP for Mac does not. It would be great to enable the PC feature set for Mac in a way that one Mac user's custom toolbars can be ported to both PC and Mac users in his org.     ... View more

What inspired this wish list request? After contacting JMP support regarding Bug when using combination of set each value, tables with same column name(s) and col statistical functions within a loop (00049239) I got to know that the way I have been using << Set Each Value and Col statistical functions (such as Col Rank() and Col Sum()) successfully for many years are unintended. The inspiration here is that the way they currently work make scripting in JMP much much faster and easier when creating new columns and if the behaviours were to change, I would have to rewrite all my scripts (most likely I will just start using something like Python at that point for all my data manipulation scripting needs).   What is the improvement you would like to see? Change the behaviour where user can use << Set Each Value with formula expression as  supported behaviour. Change the behaviour where expressions can be used as first argument (or any argument?) in Col statistical functions  as supported behaviour. Or at least provide confirmation that the behaviour won't be changing.   Why is this idea important? There are hundreds or thousands of examples in JMP community where these functions/messages are being used wrong. I use them wrong in almost all of my scripts as those behaviours are so powerful and much faster than any other options I know of in JMP. If these are to change without any notice (or even with notice) I will have to stay with some older version of JMP which still support these behaviours or start using other means for my data manipulation tasks.   Some examples from community: First Value for a Unique ID , How to calculate relativ values based on a position of a base value? , Special Formula Columns , Searching Maximum value of each row across several column and name of source column , Fill column with values based on another column with keys and associative array , JSL Companion 2nd Edition Applications of the JMP Scripting Language, Second Edition contains examples of using << Set Each value (for example 3_CreateDeleteColumns.jsl) ... View more

What inspired this wish list request?  Parallel plot (Sankey Plot) in GraphBuilder is a wonderful tool for exploratory data analysis. It helps to detect trends and outliers in multi-dimensional data. e.g. Enhanced Sankey Plot (ESP)  The user can even display nominal data - which makes it very helpful for bin flip analysis: For multiple repeated measurements, parallel plot can nicely display, which kind of flips are in the data. There is a feature of Parallel Plot  (= the default way to generate a Sankey plot) which is a drawback for this special application case: To get rid of white space, Jmp "squeezes" the graph and shifts individual values up and down. Therefore, identical values are not on the same height for all measurements. So, besides bin flips, there are additional wiggles in the curves. To distinguish between bin flips and such additional wiggles, the user has to include the label information - a tedious job which lets you remember the talk  All Graphs are Wrong, But Some Are Useful by @XanGregg . A graph which needs labels to tell the story and cannot speak but its own ... needs some optimization.   There are already some options to synchronize the scales in Parallel Plot: Parallel Plot in Graph Builder - how to get the same scale for all values  but the one needed here seems to be missing.   Please add an option to synchronize the scales in Parallel Plot - such that identical values get on the same height. This will lead to white spaces in the plot - but it will make a bin flip analysis    Why is this idea important?  Without question, the current way a Parallel Plot is generated fits to most application cases. But there are application cases which could benefit tremendously from an additional option to "synchronize" the axes.         more wishes submitted by   ... View more

☑ cool new feature ☑ could help many users! ☐ removes a "feels like bug“ ☐ nice to have ☐ nobody needs it     What inspired this wish list request?  A GraphBuilder plot with a categorical value on the X axis and another categorical value used as X Group generates a lot of white space: every X category shows up for every X Group.A wish to fix this issue is already under investigation: X group: restrict the values on the axis to the respective group  A proposal to get rid of the white space even without an optimized Graph builder: use categorical columns on the X axis and generate a hierarchical pattern. Indeed one gets rid of the unnecessary white space - but it's really hard to distinguish between 1st and 2nd order items (names and ages): It helps a bit to use different colors for the different grid lines, but the contrast could still be better ... Unfortunately, it's not possible to adjust the line width of the grid lines - this is just possible for the Tick marks. Nor is it possible to apply different colors to the backgrounds of the individual top-level blocks.   What is the improvement you would like to see? 1) In the  Properties menu, please add an option to specify the line width of the grid lines.   2) Please provide an option to apply different background colors to top-level blocks, or alternatively, automatically apply alternatingly  two different colors to the top-level X-Axis categories.   Why is this idea important?  The improvement will help the user to generate graphs in Jmp which are easier to understand.         more wishes submitted by   ... View more

What inspired this wish list request?  Other wish list item created by meMake column properties usable with Filter Col Selector and Col List Selector and   tool which I have written which adds column properties based on the REST API returned values.   What is the improvement you would like to see?  When creating new tables with Summary, provide option to add Notes (or some other) column property to generated table which tells which options were used for that specific column. This would be especially useful when using "statistics column name format" option "column". The most simple implementation could be something like this   Why is this idea important? I like using Summary with "statistics column name format" option as "column" but from time to time I might forget which Statistic I used, this way I could quickly check what the statistic was. This also moves JMP a bit towards an idea where you could use column properties to store metadata (I will write my own add-in for this when I have time).   ... View more

☐ cool new feature ☐ could help many users! ☑ removes a „bug“ ☐ nice to have ☐ nobody needs it   Text to Columns is a cool tool to split data from a single column to multiple columns - with a user define separator.   The tool has a neat feature - which (in manny cases) acts more like a bug:   If there  are consecutive separator characters, they are automatically treated like a single character (!) Definitely, this makes sense for spaces.    But let's assume that the data is from a data table. Then two consecutive separator characters indicate that there is an entry with a missing value in-between. And Text to Column interprets it as a single character, this leads to shifted entries, like illustrated here: https://community.jmp.com/t5/Discussions/Cols-utilities-how-to-let-lt-text-to-columns-gt-take-care-of/td-p/254339   My wish: please add a checkbox to enable/disable the "use multiple separators as a single one"  feature. Out of historic reasons, one could enable the feature by default.   It's clear that there are workarounds like: - write your own Text to Columns tool. - add additional characters between adjacent separator characters. - export the data set and use the txt import (which fortunately doesn't have this bug/feature) - use Excel (which has the checkbox) ... View more

I regularly need to export some JMP tables into CSV or TSV format. My computer/Windows uses the typical German locale settings, e.g. comma as decimal separator instead of period. If I do not explicitly select "Use JMP language rather than System locale settings..." and settings the Display Language to "English", the CSV/TSV file will export numerical values as "3,14159" (including the quotation marks). This sort of export makes it difficult to import the file into other tools that prefer the typical format 3.14159 (period as decimal separator and not quotation marks). It would be really helpful, if I could continue to use JMP with e.g. German user interface and also numbers expressed in the operating system's locale setting within JMP but having more options on exporting the data to avoid the above issues.   Björn ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   The rows summary table on the bottom left of a table is very useful to get DataViews (subsets) for selected rows, excluded rows and so on. The Data View    Unfortuntely, in my daily work it's much more often that I need a subset of non-excluded rows than of excluded rows. So, I go: 1)   2)    3)      my wish: an additional entry for non-excluded rows, like this and by this: the opportunity to generate a DataView for non-excluded rows.   Additional benefit: One can directly see the number of actually used (= non-excluded) rows and doesn't have to calculate it (all rows - excluded)   more wishes submitted by   ... View more

Every day we have new data that need to add/update to the existing data table  I need a simple operation that will be able to concatenate new row(s) and/or new column(s) to the existing table and also update the existing table if the new table show a change in the data value by matching columns criteria. ... View more

I would like to suggest a feature to be added for validation runs of your DoE model. Usually when I have the data for my DoE model I run an additional 3-5 runs to validate the model and compare the outcome of the runs to what the model predicted. It would be very useful to have this as a feature in JMP to augment the design with additional runs and compare the results to the model predictions by a test of equivalence.  ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it     In the NewFormulaColumn/Transform menu there are many useful functions, but "modulo" is missing:     more wishes submitted by   ... View more

It would be nice to have an option that Clopper-Pearson ("Exact") Intervals (and Bounds) be reported in the Distribution Platform, additionally to Score Confidence Intervals. This could be a setting in the Platform Preferences or an option under the red triangle menu for "Confidence Intervals" or additional Columns in "Confidence Intervals".   This is not a matter of arguing that one interval is better than the other (it is known that Clopper-Pearson Intervals are overly conservative) but rather a matter of offering a method that many people (and regulatory bodies) are familiar with.   There is a JMP "Calculators" Skript (under Help -> Sample Data -> Calculators -> Confidence Interval for One Proportion) that offers this type of interval, but it's not editable, e.g. if one is interested in the proportion of "Fails", these can only be labelled "Successes", and when working with raw data it doesn't recognise hidden and excluded rows.    There is a Discussion in the Community about this topic where one user provided a formula solution (from the Hahn & Meeker book on Statistical Intervals):  clopper-pearson confidence interval for proportion    It is nice to have at least these options, but for reporting purposes both workarounds are not a good option.   The following picture shows the Distribution Platform output on the left and the Calculators-tool (Clopper-Pearson) output on the right: ... View more

Currently we can use "open multiple" to open multiple .csv Excel files with same format and combine to 1 single file, however, this function seems not applicable for other Excel format (xlsm, xlsx, xls, etc.). Besides, the import settings is also only applicable for .csv document. Can JMP make changes to support for all Excel document format?     ... View more