JMP Wish List

I think it should be possible to add custom axis breaks to the Graph Builder, in the same way it is often possible in other graphing software like Origin Lab.   At the moment, producing a good display for continuous X-axis data with X-axis grouping is quite involved. For example: if we have continuous timestamps over multiple days, but the data goes only for one hour during each day, but you still want the graph to show the course during a single day.   Previous post explaining the problem: https://community.jmp.com/t5/Discussions/How-to-insert-X-axis-break-in-graph-builder/m-p/525673 ... View more

I have JMP 16. Please enable Paste Special (Ctrl-Alt-V hot key) options in JMP, similarly to Excel. The latter has a very rich dialog window reproduced below. Include check box Do not change data type of receiving columns and convert incompatible data type entries to ‘missing values’ ( • ). This check box will act similarly to changing column properties in JMP: if there are non-numerical entries in some rows of columns the user wants to make Continuous, they will become missing values.   ... View more

Hi.  I propose there should be an optional argument that forces all columns to be Character Data Type for both the Open() and Multiple File Import() commands.  This request is similar to, but not exactly the same, as these 2 requests:   https://community.jmp.com/t5/JMP-Wish-List/Excel-Import-specific-column-types-or-formats/idi-p/248136  https://community.jmp.com/t5/Discussions/Force-column-from-CSV-import-as-Character-not-Numeric-Date/m-p/260752#M51078    The first link requests the ability to manually specify column data type for Excel files in the Open() GUI, whereas my request is addressing usage of the Open() command in a script, not the GUI, and applies to both csv and xlsx files.  The second link appears to apply only to MFI() and csv files, whereas, I would like this ability for both MFI() and Open(), and for both csv and xlsx files.   I realize there exist various scripting methods that could do this for certain scenarios, although not all. Some of these methods might require you to know the column names/locations in advance, or require that the column names always be on the first row.  This is not something we necessarily have control over.     I feel having a single option to set would simplify this greatly for many users.  Also, this would save time since JMP would not need to spend time scanning the file to detect column data type.  Lastly, my feeling is that this could be low-hanging fruit to implement, in that you'd just be turning off the portion of the internal code that scans each column.   Hope this is possible.  Thanks. ... View more

Add more icons to column listing if column properties are set. Currently I would like to have one for Notes to easily know which columns have notes set and which do not, but most likely it would be beneficial to have icon for all of the properties (predetermine some icons which would be by default on and then let users make changes in preferences) This is also partially related to other wish list item I have created Add Data Type icon to column listings    ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it     By default, column formulas include "excluded" rows in the calculation. An easy solution is to add "excluded()" explicitly as a group by option: Exclude data in formula      My wish: a option in the  New Formula Column context menu:   more wishes submitted by   ... View more

Some built in column formulas like Col Mean() are very fast because they only calculate expensive values once and return or modify them for each row.  With custom formulas this is harder to achieve because each row is evaluated separately.  Sometimes using a separate column to store intermediate values can speed things up (for example storing the row indexes that meet a certain criteria, instead of re-calculating them every row), but that gets messy and hard to follow. If there were some concept of a column context such that the evaluation of one row could access intermediate values calculated in the previous row, then a script could calculate results for all rows at once and then quickly return them and pass the intermediate results to the next row. The formula would also need access to the whole column instead of just the current row, so the column reference should be passed unevaluated. ... View more

When performing certain tests in JMP, the null hypothesis is stated, but not for all.  I found several people are confused by the interpretation of the results for hypothesis tests if the null hypothesis is not stated.  Could a future version of JMP state the null hypothesis whenever there is one to consider? ... View more

I currently have scripts that will perform both tests, but it would be very convenient if they were built into JMP. ... View more

I'd like to request an ability to convert an excel file to a text file through JSL without having to open the excel file first.  This would greatly speed up daily reports that have to reference excel files (fyi: an excel file currently takes 30 seconds to open but the same file as a text CSV file opens in a second).  Something along the lines of Copy(source, tabs, starting row, starting col, ending row, ending col).   This was brought up in this discussion post as well: https://community.jmp.com/t5/Discussions/Save-xlsx-to-csv-file/m-p/36763   Thanks for considering it! Steve ... View more

Currently Fit Y by X platform where a single Y and single X with a By role does not turn on Fit Group. But in JSL, you can wrap the script in Fit Group and it works.   Normally in Fit Y by X, when you do multiple X's or multiple Y's, you will get the Fit Group (using Big Class.jmp example file): Fit Group( Oneway( Y( :height ), X( :age ), ), Oneway( Y( :weight ), X( :age ), ) );   If you run Fit Y by X for say two continuous, and a categorical in the By() role, you cannot arrange by rows: Bivariate( Y( :weight ), X( :height ), By( :age ) ); But using JSL, you can simply wrap it inside the Fit Group and it works: Fit Group( Bivariate( Y( :weight ), X( :height ), By( :age ) ) );   as does the more general call to Fit Y by X: Fit Group( Fit Y by X( Y( :weight ), X( :height ), By( :age ) ) ); Could this be allowed to be the default, or at least allow as a Platform Preference?   What is saves to the table or script window looks like this: Fit Group( Bivariate( Y( :weight ), X( :height ), Where( :age == 12 ) ), Bivariate( Y( :weight ), X( :height ), Where( :age == 13 ) ), Bivariate( Y( :weight ), X( :height ), Where( :age == 14 ) ), Bivariate( Y( :weight ), X( :height ), Where( :age == 15 ) ), Bivariate( Y( :weight ), X( :height ), Where( :age == 16 ) ), Bivariate( Y( :weight ), X( :height ), Where( :age == 17 ) ) ); ... View more

Add new Col statistical functions: Col IQR ("robust standard deviation") Col Standardize Robust (use median instead of mean and quantile range instead of standard deviation, default to IQR) sklearn.preprocessing.RobustScaler — scikit-learn 1.1.1 documentation Could also be added to existing Col Standardize function as a argument Col Normalize  Normalize between range (0 to 1, -1 to 1 and based on limit columns) Feature scaling - Wikipedia Not as important: Col Robust Sigma (default divisor to 1.35) and Col Robust Limit (default sigma multiplier to 6 and argument to choose lower/upper) http://www.aecouncil.com/Documents/AEC_Q001_Rev_D.pdf  Also add as many of these as possible to Matrix operations if they are missing.   Most of these could already be implemented fairly easily by using existing statistical functions, but I would much rather have them as normal functionality in JMP (native implementation could also be faster?). In my opinion, these are very useful and powerful functions (like are all other Statistical Col functions). Example functions (might include mistakes): Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp"); // add outlier for M dt << Add Rows({name = "OUTLIER", age = 1, sex = "M", height = 500, weight = 500}); // add limits dt << New Column("LSL", Numeric, Continuous, << Set Each Value(50)); dt << New Column("USL", Numeric, Continuous, << Set Each Value(60)); dt << New Column("ColMean_height", Numeric, Continuous, Formula( Col Mean(:height, :sex, Excluded()) )); dt << New Column("ColMedian_height", Numeric, Continuous, Formula( Col Median(:height, :sex, Excluded()) )); dt << New Column("ColStdDev_height", Numeric, Continuous, Formula( Col Std Dev(:height, :sex, Excluded()) )); dt << New Column("ColIQR_height", Numeric, Continuous, Formula( Col Quantile(:height, 0.75, :sex, Excluded()) - Col Quantile(:height, 0.25, :sex, Excluded()) )); dt << New Column("ColStandardize_height", Numeric, Continuous, Formula( Col Standardize(:height, :sex, Excluded()) )); // Example https://scikit-learn.org/stable/modules/generated/sklearn.preprocessing.RobustScaler.html // using IQR here, but might be good idea to be able to change the quantiles (default to IQR) dt << New Column("ColStandardizeRobust_height", Numeric, Continuous, Formula( (:height - Col Median(:height, :sex, Excluded())) / :ColIQR_height )); // https://en.wikipedia.org/wiki/Feature_scaling#Rescaling_(min-max_normalization) dt << New Column("ColNormalize_01", Numeric, Continuous, Formula( 0 + (:height - Col Min(:height, :sex, Excluded())) / (Col Max(:height, :sex, Excluded()) - Col Min(:height, :sex, Excluded())) )); dt << New Column("ColNormalize_11", Numeric, Continuous, Formula( -1+(:height - Col Mean(:height, :sex, Excluded()))*(1-(-1)) / (Col Max(:height, :sex, Excluded()) - Col Min(:height, :sex, Excluded())) )); dt << New Column("ColNormalize_limits", Numeric, Continuous, Formula( ColMin(:LSL, :sex)+(:height - Col Mean(:height, :sex, Excluded()))*(ColMax(:USL, :sex)-(ColMin(:LSL, :sex))) / (Col Max(:height, :sex, Excluded()) - Col Min(:height, :sex, Excluded())) )); // maybe even Robust Sigma, divider would default to 1.35 // http://www.aecouncil.com/Documents/AEC_Q001_Rev_D.pdf // and robust limits, sigma multiplier defaulting to 6 ... View more

One seemingly simple issue I have in JMP 16.1 is when using a Row Legend within platforms like Fit Y by X and Variability Chart, the legend added is applied as a color/marker to the full data set. This can be an issue as I usually just want that legend applied for that single graph, rather than applied universally within my data set.   Below is an example from the Big Class data set. It may not be desired to have that row legend now be fixed for the full data file. This is a very simple example where you can reproduce it in Graph Builder. But it would still be good to get the color/marker for other platforms.   ... View more

possible to add "add script" to the right click context menu of the table script window?   Thre is already the "paste" function to add a copied stript, but I really miss the "add script" to add a new, empty one. ("add script" is just available in the red triangele table menu.)     ... View more

Can we get Skewness and Kurtosis added to the options in Tabulate? I use those a lot in my summary statistics. ... View more

☑ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   In graph builder it's very convenient to pull the axes with the mouse to adjust min, max and the range. Is it possible to add this functionality also to the color gradient legend? ... View more

I'd like to suggest the following for equivalence testing and practical difference testing: Add a column property for practical difference limits.  This will be reference whenever an equivalence test is done in Distribution, Fit Y by X, and Response Screener In Distribution, Fit Y by X, and Fit Model, add in a report out option for practical significance.  This would be in line with the report out options you can get from Response Screener -> save compare means. I'd also like to see equivalency testing and practical difference testing for Stdev's (variances would be fine as well)   ... View more

☐ cool new feature ☐ could help many users! ☐ removes a „bug“ ☑ nice to have ☐ nobody needs it add more features to the slider object: set the step size at initialization to enable new features like: use the keyboard up/down arrow keys to change the value alternative: increase and decrease the value via buttons on the screen (that can be enabled via context menu) Slider with automatically included Number edit Box not new: Combined and Connected Number Edit Box and Slider Box  other wishes submitted by   ... View more

I want to export the specifications of trees I've made using hierarchical clustering (Analyze/Cluster...) in NEXUS format so I can manipulate them with a phylogenetics program like FigTree; i.e rooting, visualization, etc.   Using JMP 16Pro ... View more

I'd like to suggest the ability to only lock one side of an axis range (the min or the max).  This would allow the user to lock the range at zero (min) and then allow the max setting to vary with the data range.  This would mimic the way the axis setting works in a popular program that rhymes with "terrel".   Thanks for considering this request.   Steve ... View more