JMP Wish List

What inspired this wish list request?  Always writing more or less complicated scripts to "clean" my data tables (remove table scripts, table variables, column properties, ...)   What is the improvement you would like to see?  Provide easy platform to cleanup data table. This should give option to remove table scripts, table variables, column properties, row states and all different modifications. In best case user could decide which to remove. Some of these could be implemented to Subset but I feel like this should also be separate platform.   Why is this idea important?  Makes it easier to create new data tables from existing ones without they carrying over non-relevant information. ... View more

What inspired this wish list request?  Using JMP's Update platform and getting error messages.     What is the improvement you would like to see?  If user has defined columns to be added and chose NOT to replace any of those added columns, add them as new columns with index.   Error:   Names Default To Here(1); dt1 = Open("$SAMPLE_DATA/Big Class.jmp", Invisible); dt2 = Open("$SAMPLE_DATA/Big Class Families.jmp", Invisible); dt1 << Update( With(dt2), Match Columns(:name = :name), Add Columns from Update Table(:age), Replace Columns in Main Table(None) ); Close(dt1, no save); Close(dt2, no save); but I would like to end up with two age columns: original age and newly created age 2 from the dt2.       Why is this idea important?  Makes using Update more flexible without having to rely on renaming columns     ... View more

☐ cool new feature ☐ could help many users! - e.g. in Semiconductor Industry ☐ removes something that feels like a „bug“ ☑ nice to have ☐ nobody needs it   What inspired this wish list request?  Custom Binning is a very cool platform. It's super useful. Thanks @Jeff_Perkinson ! I have to admit - from all the binning schemes, 50% of the time I use Equal Width - and 49% of the time, I define the values manually.   Among the 49 percent, most of the time I want to process a column with spec limits and mark rows which are out of spec.   What is the improvement you would like to see?  If a column has a  property Spec Limit, in the Custom Binning Platform please add options for the two cases: 1) "in spec" and "out of spec". 2) < LSL in spec > USL   Why is this idea important?  The new feature will greatly facilitate the work of users in many industries, e.g. # semiconductor industry   other wishes from    ... View more

このウィッシュリストリクエストのきっかけは何ですか?   What I want to see improved is an issue with imported data when updating from JMP14 to JMP18 (some data becomes null). Specifically, place test data in c\temp, run scripts Source14a and Source14b in JMP14 and JMP18, and compare. Unlike JMP14, in JMP18, when importing data that contains a mixture of YYYY/MM/DD type and YYYY/MM/DD H/MM/SS type in one column, some of the data will be converted to null data.   改善してほしいことは何ですか?   Revert the data import method to the same as JMP14, or add an option to revert to the same as JMP14.   Data that contains a mixture of YYYY/MM/DD type and YYYY/MM/DD H/MM/SS type often occurs in manufacturing sites. If this data becomes null, analysis cannot be performed, so it is important to be able to read it without generating nulls like in JMP14.     この考え方がなぜ重要なのでしょうか?   Customer support also suggested using the Source14aREV script, but it is difficult to change to the proposed script for two reasons. 1) There are already hundreds of scripts running, and it is difficult to change all of them without making mistakes. 2) Even when creating a new script, Source14a format scripts are easily created when opening a file in JMP14. It is very time-consuming for users to convert all date and time data columns in the read data to Source14aREV format (for example, one file contains more than 1,000 rows of date and time data columns).   Therefore, it is very important for the manufacturing industry to improve data reading as a function of JMP, rather than modifying the script.   Apart from this defect, JMP18 is a stable and excellent product. Please eliminate the inconvenience of reading data. If you do so, fewer users will require older JMP versions when renewing their licenses.   ... View more

What inspired this wish list request?  Making small mistakes when launching JMP Platforms and I already have implemented this to my platforms.   What is the improvement you would like to see?  I would like to see "Keep dialog open" checkbox in all of the JMP platforms which have a launcher and close it when you press "OK". Other option would be to provide some sort of "Preview" for the platforms but this would be much more complicated to implement to not slow down platforms too much.     Why is this idea important?  Making very small mistake in JMP launcher forces you to find the launcher from menus again and pressing Recall or you can use View/Recall Last Platform (hidden inside menus and has very bad shortcut by default as it forces you to remove your hand from mouse). ... View more

What inspired this wish list request?  Removing all columns from quick columns can be unintuitive. Let's say you pick two columns to group by but then you wish to remove those. You will have to select EXACTLY those two columns to clear group by -> if you select any more those will be added to group by, if you select all columns old ones will be removed and new ones added. So you end up in this cycle where you are continuously right clicking on separate columns and checking which columns are still in group by.   What is the improvement you would like to see?  I would like to see few possible changes.   1. Add new option "Clear Group By". This would remove all columns from the group by   2. Figure out how to make adding/removing columns more intuitive (add new buttons Add to Group, Remove From Group? instead of just having a toggle). Example follows:   I have Semiconductor Capability table open and I wish to create grouping column. First I think I need to have lot_id and wafer as my group columns, I select then and make them into the group. Then I remember that I have to include SITE to my group. I still have my lot_id and wafer selected so I just add SITE to selection and click group by What I will end up with is just SITE in the group And it can get even messier when you try to add more columns and finally try to clear them...   Why is this idea important?  JMP is interactive tool and it should be easy to use as possible. Currently it feels like it is easier to just write formulas using JSL than interactive columns, especially if you happen to mess up with group by column selections even once. ... View more

What inspired this wish list request? This is a feature I use all the time in Excel when I need to apply a constant transformation to a set of values     What is the improvement you would like to see? Please consider adding an option under the red triangle menu in the Recode utility for transforming numeric values. Perhaps I need to multiply or divide a few values by 100 because some people input a percent as 0.1 and others as 10. Currently I have to change each of those values one by one but this is very easy to do in Excel as shown by the attached screenshot.     Why is this idea important? Recode is an amazing utility but this seems like a minor gap in its functionality compared to Excel. There aren't many options for recoding numeric column so this would be helpful. The quick New Formula Column options are great for when you need to transform an entire column but often I only need to do this for a few values.   ... View more

Hello,   I would like to request that the Columns panel near the middle left of the data table be enhanced to support Columns menu commands such as Column Info, Pre-select Role, etc. This would allow faster manipulation of the data table than going back to the Columns menu at the top.   Thanks and regards Mehul Shroff ... View more

What inspired this wish list request?  The list of currency symbols are not complete, along with all the global currency 3 letter abbreviations, which is not great for countries not covered in JMP's currency list   What is the improvement you would like to see?  I really would like Vietnamese Dong symbol and VND abbreviation included in the currency format list. No doubt there are other currencies are not included. Why is this idea important?  I work with clients who are Multinationals and have sales from Vietnam and the local markets work in their local currency. ... 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"Initial Data" setting in the column menu is very useful. Constand values, sequences, random values and  ... today.   One can even specify if "today" is just the date - or date and time: amazing!   But sometimes, the user doesn't want to get the current date, just some "default" year or month ...   What is the improvement you would like to see?  Please combine the approach of "initial data" with the functionality of input format - to define "default" values which will be used if no other value is specified in the current input: With a setting like this one,  if the user enters 24.01., it will automatically be converted to 24.01.2024. If he enters 24., it will become 24.08.2024: Even more useful: Today as default setting - either via or via the Format Pattern:   then Jmp will behave like this:  if no value is specified, Jmp will enter the current date. if no year is specified, Jmp will use the entered date + the current year [like Excel does!] In 99% of the cases, if a user writes 24.02. he doesn't think of a day back in 1904. Why does Jmp think the user is thinking about a day in 1904? So, every time a user enters a date, he has to remember that Jmp thinks that he is thinking of a day in 1904 .. if no month/year is specified, Jmp will use the entered day + the current month and year with #3 Jmp an go beyond what is possible in Excel ... maybe useful: if just a month is specified, Jmp uses the current date, but replaces the month with the specified one. [does anybody need this?]   Same for date and time: if just a time is specified, the current date is added automatically. [for this case, time should be first in the input, date should be second]   Why is this idea important?  Just imagine that a user can write 24. to get 24.03.2024. This will facilitate entering data (dates & times) a lot!       other wishes from  ... View more

What inspired this wish list request?  Saw application which had great way of building "custom queries" to filter down your data and I think JMP could benefit from it.     What is the improvement you would like to see?  I would like to be able to filter down my JMP table data (in best case hide non-wanted data, so this would need something like Row Filtering and hiding ) based on simple queries.   I quickly created quick mockup of the idea. You could have (optional) search bar above your column headers in which you could write "queries". It should allow for wild cards, list of items, exact matches, less than/greater than and so on and you should be able to define if specific search should be AND or OR type (by default they should be AND). And when you right click on the column search bar it would open simplified version of Row Selection menu in which you could more easily build your query. the filter menu could also be something similar like Query Builder has Also if user right clicks on value from data table, it would be nice if they could add it to the search terms.   Why is this idea important?  Makes using just JMP data table easier and allows using it for exploratory analysis. Again something which I might write my own add-in for to support my usage of JMP, but I still would like to have this as native feature in JMP. ... View more

What inspired this wish list request? UNDO command is available/active but not when using "Replace All"     What is the improvement you would like to see?      Why is this idea important?    JMP17 ... View more

What inspired this wish list request?  Messing up my column selection in Variability platform launcher when I didn't remember the exact order (was it the first or last item in group which was considered "part").   What is the improvement you would like to see?  I would like to have Keep Dialog Open checkbox (disabled by default) in all of JMP platform launchers so I can enable it, run my platform, check I get I was expecting to get, if I didn't modify launcher settings, run again, ..., until I can close my launcher.   Why is this idea important?  Makes it easier to test different settings in JMP Platform launchers. We do have a recall but it is always a hassle to go and find the platform from menus. There is also the "Recall Last Platform" which kinda does what this check box would, but no one knows about it and it is behind menus (learning the shortcut would definitely help though, but it would force me to move my mouse hand to keyboard as by default it is Ctrl + L). Maybe adding that as a toolbar could be other option instead of adding keep dialog open check box. ... View more

What inspired this wish list request? We are working a lot with Tables menu (join, update, concatenate...) and we need to write some jsl to do what we have to do and we are thinking that performances will be better if these features could be jmp natives.     What is the improvement you would like to see?  Update (data type): when we want to update table01 with table02 data, we have to check the data type. If the targeted column on table01 is defined as  numeric, this one can not be update if source column of table02 is defined as character. Update (insert new row) : Could it be possible to add an option in the update plateform to have a way to make a concatenate operation only on rows thats are in the table02 but not in table01 (based on matching column key).     Why is this idea important?  time saving better performance easier data handling operation   Thanks Guillaume   ... View more

What inspired this wish list request? We produce extensive excel datatables with data. some of that data is trended in excel, and other is used specifically for analysis. For this we only use a few columns.     What is the improvement you would like to see? Exclude option on the JMP import wizard to ommit or delete columns from the final JMP datatable. OR, an "select columns to import" function     Why is this idea important? it is not critical since the columns can be deleted later or selected in excel and then use the excel add-in to import. It would make the work more intuitive and streamlined. I also noticed that the "datatable" JMP add-in in excel does not record to Workflow builder. So if I wanted to create a script for deleting columns, I would do it by selecting by hand since it is not possible to use the excel add in.     ... View more

What inspired this wish list request? I, like many others, use a laptop that I usually have connected to an external monitor, but not always.  When switching between monitor and builtin, Windows will change the display scaling     What is the improvement you would like to see? I would like to see JMP update its graphical display scaling when Windows does     Why is this idea important? Not only does JMP become blurry (having a different logical pixel size as compared to Windows DM), but things like Copy Picture no longer work properly, as the bounding boxes are calculated incorrectly   Please, it is quite literally 2023 -- how is it that JMP is still single-threaded and doesn't update its display scaling?!   ... View more

What inspired this wish list request?  New Formula Column from the right click context menu is a very fast and elegant way to generate new columns with formulas.     What is the improvement you would like to see?  Please add a function "match" which generates a column with formula "col1==col2. If more than 2 columns are selected, the result is 1if the values in all selected columns of the respective row are equal.     Why is this idea important? Not , but definitely could help many users e.g. if they want to check - if a generated code gives the correct result - if merged values fit to the original ones - ...     ... View more

What inspired this wish list request?  Tables/Update has a significant speed issue if there are multiple matching rows in the update table: Speed up Tables/Update . Jmp can get stuck for minutes or hours while the entries from all matching rows are "added" to the main table - overwriting the previous ones - till the last one "sticks".   This comes with another disadvantage of Tables/Update: from the many rows just the last entry actually gets into the main table.    What is the improvement you would like to see?  Please add an aggregation option to Tables/Update - like the one which is already available in the Tables Query Builder Menu. To keep Tables/Update slim, one could add just a single GUI entry (which will define the action for all added rows) . Additionally or alternatively one can put the setting into Jmp preferences. Default option (to reproduce the current behavior): last entry alternative options (for non-numeric-values): mode, first entry, ...? alternative options (for numeric values) : Median, Mean, Max, Min, ...   Why is this idea important?  With the new aggregation option, one can easily fix the speed issue of Tables/Update - and lift the possibilities of Tables/Update close to those of Tables Query Builder.   please note: a similar aggregation option was already proposed for virtual Joins: aggregation option for virtual joins      ... View more

What inspired this wish list request? Imagine you have a list of credit card transactions from all your daily expenses and you want to recode those individual transactions into a new column of categories (Groceries, Dinning, Shopping, Public transportation...). Each of the transactions has a piece of the string that is recognizable and another piece which changes for every transaction (Walmart 637746556, Walmart 784767663, Target 6778356, FavRestaurant 736654, PizzaPlace 76354, PizzaPlace 78294...). To use the recode platform for this task, you currently can: - Manually group the transactions - Use Replace String with the "Replace entire string" option to replace all the "Walmart" containing strings with "Groceries". You would need to do this for each string manually and open the Replace string window every single time. What is the improvement you would like to see?  I would like to have a hybrid between the Replace String function and the Apply Mapping From Table function. This would consist on a table selection dialog where I can select a table that contains a column with my desired "Replace String" value I want to match and a second column with the value I want to replace the full string with. If I had the following two check boxes in the existing Apply Mapping From Table function: - A checkbox to tell the platform to "Find string" instead of "Matching the value" - A checkbox to tell the platform to "Replace full string" instead of replacing the "matched substring" That would meet the need. Ideally, this recode would be saved as a formula in the shape of regex or something similar so when new data is added, it can auto update the recodes. Why is this idea important?  This would be a big improvement in the speed of recoding using the recode platform for non-coders.   ... View more