JMP Wish List

For Categorical Variables it would be nice if Histograms in the Distribution Platform (Bar Charts in that case) could have bars with different colors (e.g. determined by Column Property Value Colors). Maybe there could be an option in the Distribution Platform to say "Use Value Colors for Categorical Variables".   At the moment the choice of color affects the entire Histogram. For continuous variables it's probably difficult or even not a good idea to allow Value Colors as bar widths are kind of floating. But for categorical variables I think this would add value. At the moment I use "Chart" in the Graph menu for this, but there I don't get the info of the Distribution Platform, like Frequencies.             ... View more

For a categorical variable in Graph Builder (e.g. displayed in a Bar Chart) I want to be able to select a number of categories (e.g. out of categories "A", "B", "C", "D", "E"  I select "C", "D", "E") and on right-click on those selected I can choose "Combine". I then have to enter a name for the new combined category, say "CDE", and this creates a new local variable in Graph Builder with 3 categories "A", "B" and "CDE" which are displayed in the Bar Chart (this would use Recode in the background). On a right-click, the new local variable could be added permanently to the Data Table like with other transformed variables.   This would be quicker than going from Graph Builder into the Data Table, into Recode, back into Graph Builder and using the new variable. And it would have a more dynamic feel to it.   Maybe this could be applied to the Distribution Platform as well, only there it would have to create a new Data Table variable directly as there are no local variables there. The new "Histogram" would be displayed next to the original one. ... View more

Similar to posts in the Discussions 1. https://community.jmp.com/t5/Discussions/How-to-force-datatype-of-columns-when-importing-Excel-file/m-p/41418#M24172 2. https://community.jmp.com/t5/Discussions/Import-Excel-table-with-columns-that-have-bad-data-types/m-p/48132#M27407   Yes, I appreciate that JMP respects what is in Excel's "Format Cells" screen. Unfortunately, some people (and some machines that create Excel files of data) submit formatting requests that are simply wrong. I would like some way to override Excel when a user has done something stupid like format a column of letters as numeric.   As it stands I have to tell users to collect the data and let the machine create the Excel file, then open Excel and fix the file, then go to JMP. I would rather my users skip Excel so they aren't tempted to assume Excel could do their analysis, too. The consequence is that I am going to be asked to write a VBA macro to do the analysis instead so the users don't have to use two separate programs to make an analysis.   And no, the machine can't create a CSV file. It writes a multi-tabbed Excel. ... View more

Recommend adding "rss()" (root-sum-squared) function in JMP.  This is very useful for calculating the magnitude of vectors, hypotenuse of 2-d and 3-d triangles, etc.   Basically it would take the square-root of the sum of the squared terms. ... View more

The JMP Wish list seems like a good idea and has existed more than half a year by now. According to the stats ZERO ideas have been approved for implementation. I suggest you start using the JMP Wish list actively. ... View more

I am a big fan of the Event Handler functionality in data tables. It can be used to create popups attached to table cells. My problem is that there is no capacity to format these popups -- or to add rich text or other elements. By comparison, the Hover Label functionality for graphs and reports has a lot of customization functionality. Could you extend the capabilities of hover labels to table cell popups invoked by column Event Handlers? My particular use case is that I want to be able to pop up a little "mini-table" when I hover over a cell. This "mini-table" would show information from multiple rows in the same or a different table that had a one-to-many relation to the cell I'm hovering over. I've attached a pair of tables that illustrate how this could work, and also why the existing formatting capabilities of Event Handler popups don't provide a visually satisfying popup appearance. Event Handler links in a column in Table A pop-up a "mini-table" showing data from multiple rows in Table B.   (I put this same request through as a beta request, and I'm attaching the tracking number to that here.)   ... View more

I know it is possible to do bootstrapped CI in JMP. But, when we build and test complicated mediation model, the indirect effects need to be calculated and then a bootstrapped CI is needed to build on that indirect effect. I am sure some smart JMP user has figured it out. I hope that person may write a script or a step-by-step procedure for doing this in JMP. Otherwise JMP developers, please take a note of this wish list. ... View more

Hello JMP team, I'd like to suggest two options for speeding up the usage of JMP.  While JMP is extremely flexible having to dive into drop down menus can be a slowdown in the use of JMP. Add a custom ribbon for actions and script for analysis windows.  These buttons in the platform specific toolbar would be set up in the preference menu. There should also be a scroll lock for them so they are always visible.  See example 1 pict. Add in when a shortcut button on the keyboard is presses that a floating menu box would appear next to your mouse that would have actions and script buttons you selected.  These buttons in the toolbox would be set up in the preference menu.  The box could be set up to disappear after a single click or by pressing the close icon/shortcut button again. Thanks for considering this. Steve   Right now the only option is to add action buttons to the toolbar at the top of a window which depending on your screen size can slow you down a bit and they can't be customized by platform. ... View more

Two improvements to linked tables: Provide a method to automatically open linked tables when a data table opens.  Include some way to disable it (for large or missing linked tables). Remember which referenced columns are visible and unhide them automatically if the linked table is available. Inspired by this post.     ... View more

Hi,   Would be nice to have an API to convert csv to jmp format without opening jmp software.   Regards, Guillaume ... View more

Excel import wizard is very useful, but if your first row is blank it will sometimes treat the column as numeric and empty the data. Changing the column type in the wizard (JMP 17EA) doesn't cause a re-import, and running the table macro with the column specified as character doesn't solve the problem (appears it imports and then changes).   Suggestion:  either allow 'import all columns as text' (or perhaps 'preserve all cell contents'), or something that allows you to restart the import process after assigning data types to columns. ... View more

I see Eval( Eval Expr( ... Expr( ) ) ) peppered throughout code, and once their separate functions is understood it is clear why they exist as separate functions.  However, to anyone new to scripting it takes time to start using all three functions effectively.  A new wrapper around Eval( Eval Expr( would reduce some perceived complexity.  For example, a wrapper called 'Eval Expr First' might make this more clear:   x = 2; Eval Expr First( New Table( "Untitled 5", Add Rows( 1 ), New Column( "Column 1", Numeric, "Continuous", Format( "Best", 12 ), Formula( Expr( x ) ) ) ) ); ... View more

Hi, I want to use the Import multiple files ..." to load csv files with slightly different structures: therer is huge overlap of columns, but some files have columns which the others don't. In this case, the import seems to stop if a deviation is detected in a file.   my Wish: the program loads all files and there is a control to choose: - just load columns that are available in all files - load all data (and accept that there is no data for part of the files)   Thanks,   Holger ... View more

I would like the ability to change the y axis type to Logarithmic on control charts. ... View more

FDA has a guidance for in vitro bioequivalence of products between test and reference. The name of this statistical test is Population bioequivalence.  Please find test details below link; https://www.accessdata.fda.gov/drugsatfda_docs/psg/Budesonide_Inhalation_Sus_20929_RC_09-12.pdf   could someone help to add this test inside jmp? or a script for it. ... View more

  Can we have JMP implement Silhouette plots in cluster analysis platform? Silhouette plots (Rousseeuw (1987)) are useful in many phases of cluster analysis: visualization, validation and choosing optimal number of clusters. The Silhouette value represents a measure of internal cohesion and external isolation and can be used in any of the clustering routines available in JMP cluster analysis: 1) hierarchical; 2) nonhierarchical – k-means cluster; and 3) latent class analysis once cluster assignment is made.  With JMP's focus on visualization, it will be a useful addition to existing tools in cluster analysis. ... View more

the standard is always set to m.d.y and there is no way to set the preferences to d.m.y.   somewhere it was wrote that it takes the preferences which are set as specific from Windows, but this is not working.   Another phenomena is that if you script it, like this, it works only after updating data from mssql server it works or if you do it manually by hand (m.d.y --> d.m.y over  column info) col=Column("An_Dt"); col<<data type("numeric")<< modeling type("continuous") << Format ("d.m.y",12)<<Input Format ("d.m.y");       ... View more

JMP long ago wrote a White Paper on the procedural steps to go thru to produce interpolations (at the X's I DESIRE/NEED) from a spline fit.  Works fine.  As with Excel files, you keep opening and et cetera, so you don't have to create from scratch the formulas and so on.  Every time though it's still a bit tedious.  The rows adding / the columns creation / whole new data table too and so on.  So even with an already done set of formulas, still tedious.  I'd like to see JMP have a formula or "red triangle" that says "USE THE SPLINE TO INTERPOLATE / ESTIMATE VALUES BASED ON THE SPLINE FOR THE VALUES IN THIS ______ COLUMN" and the red triangle would have a dialog to simply ask you for which column of X's are the spline "responses" to be interpolated.  Once JMP has LOESS regression (per my suggestion), DITTO there.  LOESS interpolate with a red triangle to pop up the dialog, for which column of X values do I want LOESS-Interpolated response estimates.  For the motivation, see my LOESS suggestion.  It's in the realm of metrological statistics.  Fully rigorous, but not fancy for the sake of it.  And a FULLY PRACTICAL NEED.  A NEED unfulfilled (the LOESS) and fulfilled only with a big rigamaroll (interpolation of spline via the White Paper involved procedures). ... View more

I would like a command to return the pathname of the JSL script.  For example, if I run a script "/Users/John_Doe/Documents/JMP/JMP Scripts/myscript.jsl", and I would like to have a command like this inside the script:   thispath = Get Current Script Path();    Show(thispath); And I would like this to return: "/Users/John_Doe/Documents/JMP/JMP Scripts/myscript.jsl"   The reason for this request: I have a "common functions.jsl" script that many of my scripts call using "Include".  It contains many frequently used user functions that I don't want to copy into each new script I write.  I also like to share my scripts with others in my group, along with "common functions.jsl".  I can require that my group members place common functions.jsl in the same place relative to the JSL calling it (e.g. the same folder, or parent folder), but I can't control what the overall path names will be.  If I had the path name of the calling script, I could easily use that to figure out where "common function.jsl" is (e.g. "/Users/John_Doe/Documents/JMP/JMP Scripts/common function.jsl").   I cannot use Get Default Directory().  I've found this command returns only the path of the most recent file opened using the Open File dialog.  This works if the user opens the script and immediately runs it.  The problem is if the user opens another script after opening "myscript.jsl", but then tries to run "myscript.jsl".  It this case Get Default Directory() will return the path of the other script, not "myscript.jsl".  Also, Get Default Directory() does not get updated if a script is opened from the Recent Files list.     Any suggestions, or is this something that doesn't exist yet?  Thanks for your help. ... View more