JMP Wish List

What inspired this wish list request?  Studying data modeling, trying to work with complicated datasets which have been (or rather could be...) divided into multiple data tables with virtual joins and working with PowerBI. JMP does have virtual-joins but trying to manage then is very difficult (at least in my opinion) and I would rather use full-joins which make the data tables unnecessarily large.   What is the improvement you would like to see? I would like to see a platform which I could easily use to work with Virtual-Joins (and maybe even with basic table operations). I'm fairly sure for this to work great, it would require its own larger platform like Below is a quick example built with Visio. in JMP if I want to do something like this, I think currently my best option is to use full-joins as virtual-joins are very very difficult to manage in my opinion. I will post a bit better demonstration in few weeks when I can share one data I have been working on, it has more tables and better model.   Why is this idea important?  Would make virtual-joins more useful, would make it possible to model data in JMP, would provide new platform which could be built on.     ... View more

What inspired this wish list request?  I quite commonly have to create labelling columns depending on the row values on one column. For example I might have ERROR_DESCRIPTION column and when it has a value it means error happened else test was ok. So I would like to have FAILURE labels formula :ERRORDESCRIPTION != "" -> "1" else "0".  And I would like to be able to do this with New Formula Colum and as Transform columns from Filter Col Selectors in different platforms.   What is the improvement you would like to see?  I would like to see possibility to create new formula column (and transform column) to create such labellings based on row values.   This example does combine two types into one, but idea would be that depending on the Data Type of column, different selections should be available. UI can be made more user friendly fairly easy (and should be), for example by disabling selections until Row Value has been selected. And maybe if column modelling type is continuous the combo box could be slider box and in this case created columns would be something like this: dt << New Column("Compare[age]", Character, Nominal, Formula( If(:age >= 14, 1, 0 ) )); dt << New Column("Compare[name]", Character, Nominal, Formula( If(:name == "ALFRED", "1", :name == "CAROL", "2", "0" ) )); Demo UI script: Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp"); Summarize(dt, col_options_num = By(:age)); Insert Into(col_options_num, "<SELECT>", 1); numeric_options = {"==", ">=", ">", "<=", "<"}; Summarize(dt, col_options_char = By(:name)); Insert Into(col_options_char, "<SELECT>", 1); character_options = {"==", "!="}; lub_expr_numeric = Expr(Lineup Box(N Col(3), Combo Box(col_options_num, << Set Function(function({this}, If(this << get selected != "<SELECT>", ((this << parent) << parent) << Append(lub_expr_numeric); ); ))), Combo Box(numeric_options), Number Edit Box(.) )); lub_expr_character = Expr(Lineup Box(N Col(3), Combo Box(col_options_char, << Set Function(function({this}, If(this << get selected != "<SELECT>", ((this << parent) << parent) << Append(lub_expr_character); ); ))), Combo Box(character_options), Text Edit Box("") )); // could also be built with Table Box nw = New Window("Demo", << modal, H List Box( Panel Box("Numeric - age", Lineup Ruler Box( Widths({100,70,50}), Lineup Box(N Col(3), Text Box("Row Value"), Text Box("Compare"), Text Box("Value") ), V List Box( lub_expr_numeric, ), Text Box("..."), Lineup Box(N Col(3), Text Box("Else"), Combo Box({""}, << Enabled(0)), Number Edit Box(.) ) ) ), Spacer Box(Size(50,0)), Panel Box("Character - name", Lineup Ruler Box( Widths({100,70,50}), Lineup Box(N Col(3), Text Box("Row Value"), Text Box("Compare"), Text Box("Value") ), V List Box( lub_expr_character, ), Text Box("..."), Lineup Box(N Col(3), Text Box("Else"), Combo Box({""}, << Enabled(0)), Text Edit Box("") ) ) ), Panel Box("Actions", Button Box("OK", num_vals = . ), Button Box("Cancel") ) ) ); Why is this idea important?  Would make it much faster to create transform labelling columns which are not dependent on selections but rather on row values in the column.     ... View more

What inspired this wish list request? Use of a custom script may be required for standard analysis workflow and these are not included in the action recorder.  Also would be nice to be able to use this to demonstrate and record testing scenarios that was performed on these custom scripts for GxP documentation.   What is the improvement you would like to see?  Add custom script to the action recorder.   Why is this idea important?  We use a lot of custom scripts in routine work, this would streamline the process of automating the analysis.  It would also give us a way to document testing performed on our custom scripts.   ... View more

What inspired this wish list request? I use the data table filter often (especially as a selection tool vs a filter) so I will minimize it.  To find it again I have to go to the home window or window list table as it does not show up in the Windows taskbar (it does show up if not minimized) or on the bottom of the data table window list panel.     What is the improvement you would like to see?  I would like to see data the table filter window to show up the same way as all windows do on the task bar and the data tables.   Why is this idea important? It will improve the user experience as there will be less searching for the filter window and will improve user efficiency. ... View more

Hello,   The Fit Group platform has an option for Redo Analysis but not for Relaunch Analysis. Can the latter be added as well?   (Images below added courtesy of JMP-TS using Big Class.jmp available in the JMP Sample Data Directory):      Regards Mehul Shroff   cc: @PatrickGiuliano ... 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

Hello,   Can the Redo / ReLaunch Analysis (including the ByGroup options) be enhanced to use locally set preferences instead of the global defaults where the two differ? I've noticed that within projects, when one of these commands is invoked, it uses the global preferences even though the previous analysis had locally changed preferences.   Regards Mehul Shroff ... View more

Hello, When saving / closing a JMP project, it would be helpful to allow using locally set preferences instead of the global ones (where the two sets are different). Subsequently, when the project is re-opened, it should open with the local preferences.   Thanks and regards Mehul Shroff ... View more

I need to control the access level of each individual tables, so most people can open and copy the table but cannot change anything in the table. But "read-access" status should not prevent the automatic update from the database, or scripts that uses those tables. I just want to secure the structure in the tables. ... View more

As the title says,JMP really needs the possibility to superscript text in the graph titles and axis labels. The current workarounds unfortunately are cumbersome and do not meet the needs of users coming in chemistry and physics.   Worth noting that this is a standard function in most other competitors of JMP ... View more

https://community.jmp.com/t5/Discussions/linked-data-table-how-to-cut-the-quot-link-quot/m-p/573180#M78213   Summary Tables and Subsets have an option to "link" the new table to the original data table. "Data views" have such a link enabled by default.   Cool: Row Selections and changes to the values are automatically linked between the tables.   But sometimes one needs to remove such a link  - to add additional rows to the main table - edit entries in the columns which were used for summary grouping - to rename columns of the linked table ...   my wish:  remove the link via right click on  and click on a command like "cut the link".   workarounds: - generate a (100%) subset of the linked table and delete the linked table itself - a Links cannot be saved, so, one can save the tables, close both tables and open the "linked" table again - without the link.   more wishes submitted by   ... View more

Hello,   I've encountered significant performance issues with large datasets and complex analysis in JMP and I'd like to suggest the following:   1. Can JMP be enhanced to run on GPUs and/or workstations (Windows or Linux) with multi-threading? 2. When a project is saved, the analyses are stored as scripts, which are rerun each time the project is reopened. With large datasets and complex analyses, this can take considerable amounts of time (hours). I have a number of saved projects that I doubt I can ever realistically open again. Is there a way to speeden this up? For example, can the user be given the option to save the project in a different mode where the reports are stored "live" (i.e., can be modified) but without having to regenerate them each time the project is re-opened? This may perhaps increase the file size on disk but in this day and age, that's not as significant of a concern.   Thanks and regards Mehul Shroff ... View more

Hello,   When working in Projects, it would be helpful to highlight the data table or analysis report that's currently open in the workspace. Similarly - while it is possible to get to a particular table or report by double-clicking (in Windows) the file in the workspace, the highlighting isn't great and it might help to show that file in bold or with a slightly stronger highlight color.   Thanks and regards Mehul Shroff ... View more

☐ cool new feature ☐ could help many users! ☑ removes a „bug“ ☐ nice to have ☐ nobody needs it     heatmaps get built without local filter applying and after it is ready local data filter is applied If a large data set is used which can just be displayed with a local data filter applied, the generation of the Heatmap Plot will take minutes.   Please solve this issue.     clever/dirty workaround: start with points and switch to Heatmap after jmps applied the data filter. speeding up heatmap graphs?      more wishes submitted by   ... View more

I really like the flexibility with many of the New Formula Column features. When there are very wide tables it is more helpful to navigate using the Columns Panel. It would be good to highlight columns of interest through the Columns Panel and be able to right-click and use New Formula Column features as it could be much faster than needing to go to the column headers manually and doing the right-click on the exact header. Right now some features are shared such as Column Info, but that would be a nice improvement in terms of matching up functionalities. ... View more

Tabulate cannot handle columns with modeling type "multiple response": https://community.jmp.com/t5/Discussions/tabulate-and-multiple-response/m-p/557674/highlight/true#M77131 With version 17 of jmp, Graph Builder will support culumns with modeling type "multiple response". So people will start to use this feature more and more often. The problem: Columns, for which modeling type "multiple response" will be enabled, will "disapear"  in tabulate.   So, there users will feel some pain when deciding which way to go: - cool new Graphbuilder features? - column still useable in tabulate   alternative to "enabling support for multiple response" mode:  just show the columns as if they were "nominal" mode.       ... View more

Bioequivalence testing is an essential step during the development of generic drugs. Different methodologies are used depending on the requirement. For e.g, in the EU, EMA recommends using average bio equivalence test (ABE), while in the USA, FDA recommends using population bio equivalence (PBE) test. Both methods present some limitations. alternatively Bodin et. al., AAPS journal 2020 proposed method to evaluate bio equivalence: between-batch bio equivalence (BBE). It is based on the comparison between the mean difference (Reference − Test) and the Reference between-batch variability. ... View more

☑ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2022   If a user changes the name of a column, references to the column in table scrips are (sometimes) automatically corrected, references in user scrips unfortunately not: Column() vs As Column() vs datable:column vs dt:As name("column")    So, column name changes are very dangerous: there is always the risk that a jsl code doesn't work anymore after the change - like illustrated in the example below. JMP detects that a noc-existing column is requested and throws an error:   My wish: Instead of throwing an error, JMP could open a window and provide a list of column names. Then the user can select a replacement column. There should also be a toggle box, allowing the user to decide if the JSL code should be automatically adjusted wit the new column name. The new behaviour could be enabled/disabled in the preferences menu such that users which got used to error message still have the choice to get it.     NamesDefaultToHere(1); dt = Open("$SAMPLE_DATA/Big Class.JMP"); Data Table( "Big Class" ):age << Set Name( "age_" ); s = dt << runScript("Distribution"); // column names automatcally adjusted wait(2); s = dt << runScript("Set Age Value Labels"); // this script throws an error   more wishes submitted by   ... View more

☐ cool new feature ☐ could help many users! ☐ removes a „bug“ ☑ nice to have ☐ nobody needs it     Enabling the option "conditional" makes a data filter extremely user friendly. By consecutive selection of items in the filter lists, the user defines a hierarchical order how filters react on each other. The selection in the fist filter determines the subset that is displayed in the next filter and so on ...   There are some limitations which could be fixed in a future release of jmp: - conditional data filters are not possible for columns with propery multiple response: https://community.jmp.com/t5/Discussions/Data-Filter-you-have-to-choose-between-quot-conditional-quot-amp/m-p/555435/highlight/true#M76974  - same for text filters: https://community.jmp.com/t5/Discussions/Data-Filter-you-have-to-choose-between-quot-conditional-quot-amp/m-p/556116/highlight/true#M77008 - with the option "conditional" enabled, multiple data filter groups are not possible  https://community.jmp.com/t5/Discussions/Data-Filter-you-have-to-choose-between-quot-conditional-quot-amp/m-p/555435/highlight/true#M76974    more wishes submitted by   ... View more