JMP Wish List

I want tableboxes that use ColSpanBox to name the columns better when interacting with `<<make into data table`.  Currently it just takes the lowest column name.     dt = Open("$SAMPLE_DATA\Big Class.jmp"); new window("Row Borders", tblbox = tablebox( ColSpanBox("1", NumberColBox("age", dt:age << Get Values), StringColbox("Sex", dt:sex << Get Values), ), NumberColBox("Height", dt:height << Get Values) ) ); tblbox << Make into data table(); The behavior that tabulate does would be fine by me.        (dt << Tabulate( Add Table( Column Table( Grouping Columns( :sex, :age ) ) ) )) << Make Into Data Table           ... View more

I'd like it if I could set individual cell colors.  Currently I have to make a table then color the cells then << Get as report or Journal.   ... View more

One idea: bring up the scripting index when a function the cursor is in a function name (or a function name is highlighted) in the script editor and the user presses a keyboard shortcut or function key.   In RStudio pressing F1 or F2 opens the function definition or brings up a vignette with a list of arguments for that function.  JMP needs this! ... View more

When you are writing a script embedded in a data table, there are several issues compared to a stand alone script file.   There is no Embedded log. If I want t o see what is in the log, I have to go through the debugger. But I don't like this option as the debugger has a strong tendency to crash JMP. Can we please have an embedded log in the datatable-dependent script windows ?   Upon execution, the data table is not saved automatically. This means that when I run a script and JMP crashes (I don't know if it is just me but that happens A LOT), my work is lost if I didn't save the data table. Can we have an autosave option ?                 ... View more

I would really love it if we could subscript a list with a matrix and have it shape the list into a list of lists.       l = {"A", "B", "C", "D", "E", "F"}; ss = [1 2, 3 4, 5 6]; l[ss]; // I want this to come out as {{"A", "B"}, {"C", "D"}, {"E", "F"}};         ... View more

I would like a JSL command that allows me to change the Display Language in JMP - not only the check box below the language, but the language itself. Being able to check what Display Language is currently used, would also be very helpful.   When using Display Language English on a German OS, I can use the checkbox below to tell JMP if decimal points (tick) or decimal commas (no tick) are expected. When using Display Language German on a German OS, the tick makes no difference in that respect. As our users have both language options it's important to know what language they're using in JMP before a common script is run on their system. Currently I can only think of a poor workaround to check the language and give a warning if they're using the wrong language for the script they want to use. ... View more

It will be convenient if there is a function that accepts a value and a name of a color gradient and returns a color code. ... View more

Contrast in Generalized Linear Model doesnt save as script and not accessible in script - so if you set up contrasts, the redo only adds the contrasts button and you have to re-enter all the contrasts.    It would also be good to be able to specify the reference category. In general the parameterisation should be more controllable or at least obvious.  A lot of users seem unaware that standard least squares and nominal logistic personalities use centered X's (ie mean reference category) whereas Generalized Regression and Generalized Linear Model use the reduced rank approach - ie zero'ing one of the levels like SAS does.  It would be good to have control over that, ie specify which level gets zero'ed or if mean subtraction should be used.  IT would be good to have the same approach and features available in all the regression procedures as far as possible and make everything JSl accessible. ... View more

Advanced users obtain results of platforms (e.g., Fit Model) by scripts. But for this, JMP forces the user to "scrape" the report, which is painful. It will be very helpful if the analysis results are, like in R, returned in a structured way, e.g., as an Associative Array. ... View more

Hi, Could you please implement Tukey's (Running Median) Smoothing approach in JMP. You already have a number of other EDA type tools and this one seems to be missing from JMP.   Many thanks. Russ ... View more

Folks,   Currently, the Edit | Reformat Script command does a really nice job of reformatting JSL script so that all indentations are properly aligned.  However, this command is wrapping any text in a row that exceeds something in the order of 130 characters, regardless of the Wrap Text setting in Preferences.  I often organize/format my JSL in ways to aid in readability and organization which results in rather long rows (I have multiple large monitors which facilitiates the proper display of these long rows of characters).  Unfortunately, any time I run Edit | Reformat Script my long rows of JSL commands are wrapped in ways that makes it difficult to read and see my code structure.  I would appreciate it if the underlying value in Edit | Reformat Script that limits how many characters can be on a row is increased dramatically, or even eliminated.  If the character limitation was eliminated, the Wrap Text property in Preferences could handle text that extends beyond the size of a given window, regardless of monitor size.  Thanks for listening! ... View more

As we are all aware, a good deal of the time we spend on analyzing datasets is in preparing them for the analysis (ie- cleaning, organizing, formating, etc.).  Frequently I work with datasets that are updated with new data periodically and I would like to have the ability to script all the dataset preparations steps so they can be executed with the new data.  JMP has the ability to script analyses and graphing but not the dataset preparation steps.  I hope that other members of this community would find this fuctionality valuable.  If you would like to see this implemented please add your kudo to the rest of us.  Many thanks, Floyd Fox ... View more

When using JSL, update the Make Validation Column function to accept column names for Stratified Random, Grouped Random, and Cutpoint options. I know you can use formula random and add a by(:Group) but there should be a direct way to do this. Example: current data table() << Make Validation Column( Training Set( 0.50 ), Validation Set( 0.25 ), Test Set( 0.25 ), Stratified Random ("My_Column_Name") ); ... View more

I've previously been using Windows machines, but recently switched to Mac.  In top of the script editor on Windows machines, there was a dropdown box with the name of the current data table.  On my mac I do not see this box anymore.       I have several tables open and it's important to know which table JMP considers to be the current data table while using or debugging a script.  Thanks.   ... View more

All,     When you have a matrix and you would like to sort the matrix, I am currently unaware of a function that would let me sort the matrix without using a loop over the columns or rows. I don't think this is particularly efficient. Additionally, there is no straight forward way to retain the positions once sorting is performed. Please see the following discussion for more details :  https://community.jmp.com/t5/Discussions/Sort-a-matrix/m-p/85678#M38246       As you will see in the discussion , @Mark_Bailey was kind enough to offer a simple custom function, which I would think is useful to have in the JMP arsenal.     The function that @Mark_Bailey provided is shown below for convenince.    A = [10 -12 4 8; 6 -9 8 0; 2 3 11 -2; 1 1 9 3]; sort matrix = Function( { m }, { t, b=[], i=[] }, For( j = 1, j <= N Cols( m ), j++, t = A[0,j]; b ||= Sort Descending( t ); i ||= Matrix( Reverse( As List( Rank Index( t ) ) ) ); ); Eval List( { b, i } ); ); { B, I } = sort matrix( A ); Show( A, B, I ); I also took the liberty of adding a little more along the same lines, so as to make it more generalized than my limited need :   sort matrix = Function( { m,order }, { t, b=[], i=[] }, If(order == "ascending", For( r = 1, r <= N Cols( m ), r++, t = A[0,r]; b ||= Sort Ascending( t ); i ||= Matrix( As List( Rank Index( t ) ) ); ); Eval List( { b, i } ); , // else If(order == "descending", For( r = 1, r <= N Cols( m ), r++, t = A[0,r]; b ||= Sort Descending( t ); a i ||= Matrix(Reverse(As List( Rank Index( t ) )) ); ); Eval List( { b, i } ); ); ); );   ... View more

What inspired this wish list request? Needing to copy arrays / json elements into a separate text editor to make visially appealing to quickly skim keys/values/structure   What is the improvement you would like to see? I would like to see a better 'reformat' button or a specific item for reformatting Associative Arrays and JSON objects. In other editors I have seen this called 'format json', 'pretty print', or 'beautify' ... but in the end, it's merely formatting the object for the human eye.   Why is this idea important? Associative Arrays and JSON object can become complex quickly and displaying them in block text is difficult to look at and see what is going on. Moreover, looping through these objects may take more time and / or doesn't really help understand what we need to look at -- especially if we just want a quick gut check looking at something.   As an example: Here's an associative array as it appears in the log: ["fieldName" => "product", "filterDetails" => {["all" => false, "field" => ["error" => false, "multivalue" => false, "name" => "product"], "only" => false, "polarity" => "INCLUDE", "values" => {"CatOne"}]}, "from" => 1, "timeFacet" => "EOW", "to" => 1] Pasting it into a new JSL window to 'look at it more cleanly', highlighting, and hitting the reformat button produces this: ["fieldName" => "product", "filterDetails" => {["all" => false, "field" => ["error" => false, "multivalue" => false, "name" => "product"], "only" => false, "polarity" => "INCLUDE", "values" => {"XXX"}]}, "from" => 1, "timeFacet" => "EOW", "to" => 1] But what should happen, and does in other editors (once I convert the AA to a JSON object) is something more like this (manually formatted with underscores for spaces here as a pasted format lost all indentations in preview): [ ____"fieldName" => "product", ____"filterDetails" => { ________[ ____________"all" => false, ____________"field" => [ ________________"error" => false, ________________"multivalue" => false, ________________"name" => "product" ____________], ____________"only" => false, ____________"polarity" => ____________"INCLUDE", ____________"values" => {"XXX"} ________] ____}, ____"from" => 1, ____"timeFacet" => "EOW", ____"to" => 1 ] ... View more

There are a couple of suggestions in the wish list for ChatGPT capabilities. I'd like to amend them a bit to add the open source Deep Seek as a JMP service. In other words JMP would provide Deep Seek based servers as part of it's package.   There might be one obstacle in that I believe the open-source license has a non-military use clause, so that might need some investigation and  work.     ... View more

What inspired this wish list request?  Routinely (>90% of the time) I need to go back to the data table specific to the analysis window I'm working from and I have trouble getting back to the specific data table when I have multiple tables and windows open.      What is the improvement you would like to see?  I would love if there was a button in each analysis window back to the datatable so I don't have to search for the data table, very similar to how the sub-windows generated from each datatable appear in the bottom of the data table.   Why is this idea important?  saves time and confusion     ... View more

Application Builder opens up incredible opportunities to to develop user interfaces for numerous tasks. When using the key pad, the Tab key could be used to position the cursor for the next entry if it could be controlled. This would be much faster than using the mouse to position the cursor. Currently, the Tab key positions the cursor in reverse order of field creation sequence. It would be nice to be able to define the position of the cursor based upon the current field and/or entries made in the current field and previous entries. ... View more