JMP Wish List

Hello, Can the functionality of Compare Data Tables be extended to allow comparison of more than two data tables at a time? In the interim, is there a workaround to enable this? In my current use case, I'd like to compare changes across three data tables. Thank you. Regards Mehul Shroff ... View more

Hello,   It would be helpful to add an option to the Tables -> Subset dialog to allow a user to include the row #s of the original dataset that are included in the subset.   Regards Mehul Shroff ... View more

What inspired this wish list request?  Data table with columns that are used in groups that are not mutually exclusive.   What is the improvement you would like to see?  In the columns pane, in addition to being able to group columns it would be nice to have virtual groups that are not mutually exclusive.    Why is this idea important?  This helps to make sure that the intended columns in a large table are used as planned.     ... View more

What inspired this wish list request?  I have many files that I need to merge them. They are all in excel and they have the same name columns if the comparison of the tables had a button this could facilitate the life to check if there are any mistakes or even the possibility to do a matching button for the ones that are not the same spelling...Also, the possibility to add more comparison tables instead of only 2.    This improvement could make it easier merging tables from different files and multiple ones. Helping researchers to do a bigger data bank.      ... View more

-What inspired this wish list request? We keep having a problem with imported data not matching JMP's default character set. The problem occurs when we manually create a table and then try to join to existing data and nothing matches.    What is the improvement you would like to see? To be fair, you could argue this is an issue with the source data. However, it is hard to detect as the names can look exactly the same. It would be good if JMP could alert to such a situation and ask which character set to use or automatically convert to JMP default on import, remember the character set, and give user option on which character set to use on export. And/or provide tool in compare data tables that can identify differing character sets, and/or provide function that change character sets.   Why is this idea important? The issue occurs too easily and is hard to detect because there is no visual difference in the characters.     ... 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? If a user clicks on column/right click/new formula column/Transform/Scale Offset, a GUI pops up and ask the user for the parameters.  After pressing OK, a new column is generated with the respective rescale parameters:   This is very useful. But there is no possibility to add user defined mini,GUI, like a   column/right click/new formula column/Transform/Modulo shortcut to calculate Modulo the same way.   What is the improvement you would like to see?  Please provide a functionality to gererate mini GUIs such that a user can add slightly more complex functions to the column/right click/new formula column menu which need a GUI.     Why is this idea important? There are many wishes for additional functions to be added to the Column/right click/new formula columns menu, e.g. add modulo to the NewFormulaColumn menu   @mia_stephens  suggested to generate the functionality on my own: https://community.jmp.com/t5/JMP-Wish-List/add-modulo-to-the-NewFormulaColumn-menu/idc-p/594368/highlight/true#M3734 (unfortunately, without a hint how to do so). There was also no feedback from the community how to do it: https://community.jmp.com/t5/JMP-Wish-List/add-modulo-to-the-NewFormulaColumn-menu/idc-p/596340/highlight/true#M3749  So, I think that the needed functionality is missing.   With the possibility to generate user-defined mini-GUIs, users can add the functionality on their own and don't have to convince Jmp Dev Team to add the function.         more wishes submitted by   ... View more

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

  When using Concatenate, it includes tables that are generated in reports. This is nice, but it can make for an overwhelming list if you all you want to do is join some tables together.   For example, I have these four tables open: I want to concatenate the two 'MONO' tables. But when I go to do it, Concatenate also includes all the tables in the process capability report for each table: It would be nice if there was a checkbox to filter only on data tables. ... View more

  Outlier Explorer has a nifty function for recognizing values that are a bunch of 9's, which is a common error code for a gauge (like a vision system) that cannot get a good measurement. However, many gauges use negative 9's, likes -99999. The current Nines option in Outlier Explorer only works for positive 9's. Please include negative 9's as well.     ... 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?  The right click new formula column menu is very helpful. Depending on the type of the selected column, the list of entries is restricted: *) for numeric columns:                       for character:         At fist sight,  the restriction seems to be along the line: this command is not possible for this data type - so remove it. But, unfortunately, the removal of entries goes beyond that.    e.g. If just numeric columns are selected, the character/concatenate options are missing. Why? One can concatenate numeric entries  ... if they are converted to strings before the concatenation. This sounds far-fetched - but actually it is implemented exactly like this if the user selects an column of type character in addition. Then the numeric values are wrapped with a char() and all values are concatenated. So, actually no reason to disable this option for the special case of just numeric columns. A respective wish can be found here: https://community.jmp.com/t5/JMP-Wish-List/make-NewFormulaColumn-Character-more-flexible/idc-p/560597/highlight/true#M2578    vice versa: If a column with type character is selected, some functions are disabled as well.   What is the improvement you would like to see?  Some of the removed functions actually work for columns with type character. Therefore, disabling these options just restricts the possibilities of Jmp and it's users - without actual need.   Examples are: Count from the Aggregate menu - which just counts the non-missing entries, independent if the column type is numeric or strings. In combination with GroupBy, this is an easy way to count entries per subgroup - also for columns of type character: https://community.jmp.com/t5/Discussions/Row-column/m-p/594830/highlight/true#M79874 so, please, don't disable this option for columns with type character. Distributional/Rank provides an easy way to give entries a well defined label. This also works for columns with type character. In combination with the groupBy option, one can easily "anonymize" data in a synchronous fashion. This also works for columns of type character. so, please, don't disable this option for columns with type character. Rank (reverse) and Cumulative Probability also work for columns with type character. Please don't disable them.   Why is this idea important? Application case for the count function: count non-missing entries.   Application case for the Rank function for columns with type character : With GroupX and GroupY enabled, often it happens that not every GroupX value shows up for every GroupY variable. Therefore there is plenty of white, wasted space. An easy trick to get rid of the space: synchronize the Y labels via rank. before: after:   edit: After finding Rank in the Character submenu, it's mainly Count and Cumulative Probability which are missing. Hm, I could live without them ... Open( "$SAMPLE_STIPS/Wafer Stacked Small.jmp" ); Data Table( "Wafer Stacked Small" ) << Delete Columns( :Wafer ); New Column( "Rank[Lot_Wafer_Label]", Formula( Col Rank( :Lot_Wafer Label, :Lot, <<tie( "minimum" ) ) ) ); Graph Builder( Variables( X( :X_Die ), Y( :Y_Die ), Group X( :Lot_Wafer Label ), Group Y( :Lot ), Color( :Defects ) ), Elements( Points( X, Y, Legend( 16 ) ) ) ); Graph Builder( Variables( X( :X_Die ), Y( :Y_Die ), Group X( :"Rank[Lot_Wafer_Label]"n ), Group Y( :Lot ), Color( :Defects ) ), Elements( Points( X, Y, Legend( 24 ) ) ) )   ... 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

Hello,   I would like to request that the Find and Replace functionality be enhanced to allow users to make the changes across multiple open data tables or scripts. These can be stand-alone files or files within a project.   Regards Mehul Shroff ... View more

As a code editor JMP's Script Editor is lacking quite a many features, one of them are some fairly basic shortcuts which make writing scripts much faster (and easier when you get used to them) and the shortcuts should mostly work without using mouse. Below are just few of the suggestions that come quickly to my mind (the shortcuts for all of these should be easy for user to configure): Open search bar for Scripting Index This should open similar search window as Quick Open does Open scripting index for current function, this has already been suggested but closed as delivered, BUT this new shortcut requires usage of mouse. Cut Line Copy Line Move Line up/down Copy line up/down Auto-complete variable names (might be already suggested) Either in similar manner as valid commands works currently (Ctrl+Space) Or offer suggestions and user can fill them by pressing Enter This could be expanded to functions in a similar manner as SAS in which you can control how it works through preferences These kinda already exist but have been split into two different shortcuts instead of toggle. I have no idea though how to use these with my keyboard or how to set them in JMP Menu Editor as I don't know the Built-in command for these and they aren't visible (do I have to build them by using Main Menu("")?) Toggle line comment Toggle block comment More possible shortcuts can be found for example from Visual Studio Codes keyboard shortcut listing ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it #myTop10_2022   There is a set of posts with questions how to restrict the Col ... aggregation functions to a specific subset. Compute Column Mean while restricting observations used  JMP10: Col Max() and Col Min() functions returned the data from excluded row  Col Functions and Row States  How do I use the Col Maximum Formula with a "where" condition  Exclude data in formula    Application cases: excluded rows from the aggregation: Col Max(if(not(excluded()), :weight,.),: sex) or even shorter (if one doesn't need values in the excluded rows); Col Max(:weight, :sex, :excluded()) Benchmark some data with a reference data set (country A in this post)  :data / Col Maximum(if(:country="A", :data,.))   calculate relative performance over time (divide all values at time t>=t0  by values at t=t0) (here the Col Mean is actually to get the value for :time=0 to the other rows.:) : data / Col Mean(if(:time=0, :data, 0) :batch, :sampleID)   As one can see in the examples above, the easy solution is an If statement inside the Col xyz aggreagtion:   col Mean( if(:sex=="M", :weight,.), :age); col Mean( if(not(excluded()), :weight,.), :age)     The problem: The approach is EXTREMELY slow - if the subset if-condition contains a  string comparison: How-do-I-use-the-Col-Maximum-Formula-with-a-where/M78599 Then the time scales quadratically with the number of rows and even for small data sets with just a few 1000 entries the calculation takes seconds. For data sets with some million entries it would take months (!!!) - but will be stopped by a timeout and an error message pops up. Not nice!   My wish:  fix the bug   Even better: Provide an additonal where option for Col xyz aggreagtions which fixes the timing problem automatically: first restricts the data set, then applys the aggregation (--> much faster, even if the cool "col..." speedup has a  bug) which  make subset definitions easier, instead of (*), you just need:   col Mean(:weight, :age, where(:sex=="M")) col Mean(:weight, :age, where(not(excluded())))     timing examples, copied from here corrected version - in a prev. version the screenshot showed [ms] instead of [s]   more wishes submitted by   ... View more

Hello, I'd like to request that the Rows -> Color or Mark by Column command be made available in the menu that shows up when a column is selected and right-clicked (in Windows). Regards Mehul Shroff ... View more

Hello,   In Table Join (and other associated platforms, as applicable), it would be helpful to provide a check box to automatically include the matched columns in the output table. This way, they don't have to be selected again for the set of columns that are to be included in the output table.   Thanks and regards Mehul Shroff ... View more

HeatMap in Graph builder is a great way to visualize data: https://community.jmp.com/t5/Learning-Center/Creating-Heat-Maps/ta-p/271828   Individual "tiles" can represent several rows of the data table (geographic region: data of many countries). Then the values of the rows are averaged automatically. This is very convenient   - but "averaging" (mean) is just one option ... If the user wants to do different aggregations, he has to generate a summary table or use a formula column with exactly the same grouping settings as the desired heat map: https://community.jmp.com/t5/Discussions/Heat-Map-Aggregate-Function/td-p/269522   A more straight-forward and flexible approach: In GraphBuilder/Heat Map, please provide a menu to select the aggregation method: - median - any item from the summary table menu:     dt =Open( "$SAMPLE_DATA/Big Class.jmp" ); dt:height[32]=500; Data Table( "Big Class" ) << Graph Builder( Size( 336, 478 ), Graph Spacing( 4 ), Variables( X( :sex ), Y( :age ), Color( :height ) ), Elements( Heatmap( X, Y, Legend( 4 ) ) ) ); ... 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

☐ cool new feature ☐ could help many users! ☑ removes a „bug“ ☐ nice to have ☐ nobody needs it     The code in the formula editor can be either constructed by clicking on variables, columns or function in the menu on the left, by dragging items into the formula window - or directly by typing in the code. In the latter case, after typing in the first character, a small jsl code editor pops up and the user can continue to enter the code. There is even syntax highlighting :) Unfortunately, it happens very often that the second - or even third - character is lost: Do other users experence the same issue? What's the benchmark typing speed? 3 missed characters? I hope, the issue can be fixed in a future release of jmp :)   ... View more