JMP Wish List

It would be great if you added in SVM modelling capability to the JMP Pro predictive analytics platform.  I would prefer to run this directly in JMP rather than having to use R add ins, etc.  Even a JSL scripted add in would be helpful. ... View more

With omics datasets becoming the norm, JMP needs a straightforward way to visualize high-dimensional data... Tsne and UMAP are becoming the norm for this purpose, PC analysis just won't cut it for publication. The availability of Tsne and UMAP as native tools in JMP would make a world of difference for those of us who don't want/know how to work with R or Python!!!  Thank you for your attention L.   ... 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 Query Builder in Jmp is nice to generate SQL queries via a GUI. But there are queries which cannot be generated via the GUI: Database access  With JMP 17, In the query builder, how can add "WITH UR" at the end of the SQL code?    The only solution at the moment: change to custom SQL - and at that moment lose all GUI options to make further changes to the query.   What is the improvement you would like to see?  Please improve the GUI to provide advanced SQL option: - add the functionality to "explode" entries and "index" column entries - allow the user to manually enter advanced SQL strings - which then can be added at specific positions of the main SQL query string.     Why is this idea important?  Users are not forced anymore to abandon the Query Builder when they have to add an expression to their query which is not supported by the Query Builder GUI.         more wishes submitted by   ... View more

All our data is generated in the form of stdf files.  This is a type of binary file used in the semiconductor industry.  We currently must rely on a third party add-in to convert the stdf into a JMP table.  It would be nice to have this capability integrated into JMP. ... View more

have an input where you tell JMP what your factors and responses are and it looks at all of the data and suggests which models would be best to look at first. I've put AI in the title but it also incorporates pattern learning machine and deep learning techniques.    This is essentially joining the neural network, model comparison and all other analysis methods into one interface. It could learn which methods & algorithms are best for the work an individual usually does and how the data is displayed as plots/ graphs.  SAS uses Machine learning so the knowledge is already within the company https://www.sas.com/en_gb/insights/analytics/machine-learning.html   David ... View more

What inspired this wish list request?  Unnecessarily removed feature in JMP18 when compared to earlier versions...     What is the improvement you would like to see?  Bring back Clear Row States when you right click on Rows. I don't want to always Select all -> Clear Select row states. That item is still found from Rows menu, but not from right click menu   JMP18   JMP17   Why is this idea important?  Makes it easier to clear all row states like it was in earlier JMP versions     ... View more

What inspired this wish list request? https://community.jmp.com/t5/Discussions/csv-file-Day-Month-Year/m-p/746980#M92639   What is the improvement you would like to see? add preference and option to CSV import to prevent guessing the date format   Why is this idea important? it is hard to tell it is wrong; dates may get corrupted   @julian - the open(...csv) uses a guess that can get the wrong answer if there are no dates in a column that are unambiguously DMY, 14/3/2024 is unambiguous but 12/3/2024 is not. The guess will be MDY if there is no date with a month>12. ... View more

Using JMP 17 we have been a bit surprised to see what happens in detail with the above preference set, i.e. when performing a SQL Query, the connection string is removed (and not hidden like JMP16) in the result table. When starting the table script "Modify Query", the query builder opens, and we can look at the query, but pressing the "Execute Query" leads only to a generic "Error running SQL Query". I understand, that removing the connection string is a security feature to not distribute passwords, server names etc. And the good thing is, that the query definition (SQL) is still available.   This is my proposal: "Hide ODBC Connection Strings" should be renamed into "Remove ..." it should be made more transparent, that the Query will not be functional with this preference set, i.e. making visible that the SQL-Query object is not connected to any database, and throwing a more distinct error accordingly maybe there could be implemented a way to again connect that query to a database under the red triangle, i.e. "Connect to Database" to make it working again Thanks!           ... View more

I would like for JMP to be able to open Apache Parquet files and handle them in the same way that HDF5, JSON etc...can be handled. Thanks a million. ... View more

What inspired this wish list request?  Right now we need to manually assign people to groups (or spaces) in JMP Live, mirroring permissions that are already available and actively managed in active directory.   What is the improvement you would like to see?  Sync or read groups from active directory into JMP Live.   Why is this idea important?  Managing these permissions separatelly from active directory is a lot of work and will likely lead to some users have access to content they shouldn't, and some users not having access to things they should.  We already have processes to administer and audit these permissions in active directory.   ... View more

On a few occasions I had to extract tables from pdf files. Now, I used online converters of pdf tables to Excel, and then went from Excel to JMP. It is probably not too complex to allow users to open pdf files containing tables staight away in JMP? If free online website can offer that service, I'd expect that JMP should be capable as well! ... View more

I would like to be able to add a factor to a previously ran Custom DOE. So an extension of the augment DOE platform that allows me to add a new factor where I could tell you what that factors was set to for the runs that are already done. ... View more

I wish JMP could easily open data from or save data to Google Sheets, including passing credentials and scriptably.  I recently did learn how to do this by using JSL to call R and use the package googlesheets but would be nice to have a built-in solution for this ... View more

For Excel tables like shown in the attached jpg I would like to be able to specify in the Excel Import Wizard "Units are in row 2" (similar to how it works with "Column headers start on row 1"). Those imported Units would then be stored in the respective Column Properties.   The same would be possible for Limits, e.g. "Lower Limits are in row 3", "Targets are in row 4", "Upper Limits are in row 5". Being able to access Limits stored in a separate worksheet of the same Excel file would be even more comfortable.   For Units another scenario would be to specify that Units are stored in brackets [ ] or parentheses ( ) at the end of the column header.     ... View more

Usually I notice in Graph Builder or Distribution that certain Column Properties need to be set or adjusted: Value Ordering, Units, Limits, Value Colors, ... It would save time and make working with JMP more dynamic if those Column Properties were accessible with a right-click on the respective variable within Graph Builder, may it be on the x-Axis, y-Axis or in the Columns box on the left. Having to go through the data table, into Column Properties and then back into Graph Builder interrupts the analysis procedure more than is necessary.   The same goes for Recode. ... View more

At this time I need to call R to do this. ... View more

It would be extremely helpful to have a built in function to convert a time stamp between time zones using the tz database (more info: https://data.iana.org/time-zones/tz-link.html and https://en.wikipedia.org/wiki/Tz_database).  I regularly need to convert time stamps from one time zone to another, but can't simply apply an offset, but it is time consuming to have to look up the offsets to convert the time stamp.  Additionally, there is extra work required since certain locations have daylight saving time and others don't, and daylight saving time start/end dates are location specific.   This function could be something like this:   ConvertTimeZone( ts, tzFrom, tzTo ) //ts is the time stamp will be converted from tzFrom to tzTo //example ConvertTimeZone( 05May2022:19:31:07, "UTC", "America/Los_Angeles" ) //result: 05May2022:12:31:07     Ideally, all datetime values would be changed to contain the time zone, and be set to default of UTC, if not specified.   Each time zone should use the TZ database name (https://en.wikipedia.org/wiki/List_of_tz_database_time_zones), as is used in other programming languages (e.g.: Python).   Here is a question about this issue: https://community.jmp.com/t5/Discussions/Time-zone-conversion/m-p/331514#M58032   For a very humorous description of the time zone issue, watch this video: https://www.youtube.com/watch?v=-5wpm-gesOY&t=3s. It is 10 minutes long, but well worth the *time* (pardon the pun). ... View more

I would love if the JMP table format were open.  As in I could build a jmp table from pwsh/python (or whatever) from scratch.  I have two use cases   make my pipeline more efficient so that I don't have to wait for a JMP machine to open up to do some backend pre-processing while still having all of the wonderful features of JMP when I'm ready for it.     I am currently doing this by having JMP run some stuff on a machine that just preprocesses, but JSL isn't built to handle this.  interactive html isn't up to what I need it to do for everything so being able to read a jmp table to make some custom web frontend stuff would be useful   Obviously I could just use a csv for data, or switch everything over to another language.  But being able to read/write the jmp data format directly would make a world of difference.  ... View more