JMP Wish List

Similar to this: https://community.jmp.com/t5/Discussions/Automatically-shows-Show-filter-option-in-every-window/td-p/186559   Would want this in at least the formula view and the graph builder view.    ... 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 Group By concept in Jmp is sooo useful! You can find it everywhere. e.g. in Graph builder one can use X/Y groups to generate split graphs - and summary statistics will automatically give the correct results for every single graph. In Platform menus, there is a By option - which splits the data into groups and every group is analyzed separately. Under the porcellain layer, there are more group by options, like the Col aggregation functions (e.g. Col Median(:height, :sex)) which automatically return separate aggregated values for groups of rows.   What is the improvement you would like to see?  Please use such Group By options wherever it is possible. let's see if other users find more places where Group By could be useful ...   here I want to focus on a Col Grouped Interpolate function which can be used in a Column Formula like New Column("interpolated", Formula(Col Interpolate(:newX, :height, :weight, by(:sex)))) It should generate an interpolation for :weight by :height - split by subgroups M/F in :sex - and use the interpolation to calculate values @ x values :newX.   In a similar way, the existing Interpolate function could be lifted to a new level by providing an argument  BY() which can be used to interpolate subgroups [for this case, I think an additional argument for()is needed to specify the groups of interest and their order] Grouped Interpolate    Interpolate(myheight, :height, :weight, by(:sex), for({"F","M"}))   Definitely worth to have it - which can be seen by the fact that users invested the time to program their own grouped Interpolate to get the results: https://community.jmp.com/t5/Discussions/Grouped-Interpolate/m-p/692358/highlight/true#M87807    Why is this idea important?  Group By is one of the concepts which makes Jmp a million times more useful for exploratory data analysis  than Excel . use this concept at as many locations in the program as possible.         more wishes submitted by   ... View more

☑ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2022   Please add this functionality to JSL editor:   When a user Double-Clicks a bracket, the code inside the brackets is analyed, clustered ind highlighted with differnet colors. Example for "if": - conditions are highlighted green to separate the code blocks in-between - else code is highlighted red to separate is from the other code https://community.jmp.com/t5/Discussions/JSL-if-else-gt-find-the-commas/m-p/573510/highlight/true#M78251   Similar highlighting could also be applied to many  other functions: Match: highlight each match to separate the code blocks. Substitute: highlight the search patterns to separate the replacement blocks ...     more wishes submitted by   ... View more

Make toolbar customization more simple, as it was up to version 10 (drag and drop, or add/remove) ... View more

Would be useful to be able to use the local data filters used to produce plots in graph builder to auto-populate the graph title field - so that the title updates when the filter is changed - this would greatly facilitate report generation where graphs need to be generated for different years, strengths - whatever it may be. ... View more

We would like to be able to lock rows and cells so they cannot be edited, but allow the users to add new rows and cells.  Thanks! ... View more

When a column data type is changed, for example from character to numeric, make it possible to access the original data that was in that column, perhaps by storing a column script to revert that column.  This would alleviate several pain points: Column is changed from character to numeric but user doesn't notice that a few values were set to missing until later in analysis. User changes column from character to numeric, realizes it is wrong, tries to change it back, and then is missing data.  They might or might not notice this now, but even if they do it is not obvious and very inconvenient that they need to keep hitting undo to fix it. Data is automatically typed as numeric or character when it should have retained is original format, as in this post: Stop JMP from trimming whitespace  ... View more

SAS Proc PLS has an option to perform PC Regression. Perhaps the same option could be employed in JMP?  ... View more

Dear all, I really started to love jmp since I was able to import my data from our database (Oracle, mysql) by some query scripts automatically/efficiently. But as far as I know, only method is to use ODBC connectors provided by the operating system (Win10 in my case, using JMP 14.0). Now we are trying to use additional data sources like mongoDB, MS Asure in cloud and others, and it seems that jmp is very limited deriving data therefrom. I know, for mongoDB there is an odbc driver, I'm about to install. And via python I could also get some data from these sources, but would require a python installation for every user. So IMHO it would be neccesary for future releases to add some native connectors to jmp. At least as a starting point in the scripting environment. When looking at other products (like tableau, but I have no access), I'm getting a bit jealousy to the rich support of data sources. https://www.tableau.com/products/desktop#data-sources Thanks and best regards, Georg   ... View more

What inspired this wish list request? A change was noticed in upgrade from JMP 17 to JMP 18 where all table column names are automatically alphabetized rather than following programmed order.     What is the improvement you would like to see? Return to previous setting where the table column order is how the table was built.     Why is this idea important? Increased burden on large tables to reorder.      ... View more

☑ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2024   What inspired this wish list request?  The fitting options in Graph Builder are very restricted. It's not possible to fit data with outliers or with jitter on the x and y axis.   What is the improvement you would like to see?  Please implement some of the cool options from Fit Y by X  also in Graph Builder!   The benefit: Users who want a cool Graph Builder plot AND a meaningful regression (like Deming or Passing-Bablock) don't have to take the detour via Fit Y by X -- including the  hurdle to find the Deming regression :)  .   Why is this idea important?  Graph Builder is THE tool in Jmp - some users use it also to fit their data. Graph Builder should provide a 1-click->fit option that is robust against outliers and which can handle jitter on the x AND *) y values.   *) extreme cases:   other wishes from  ... View more

☑ cool new feature ☐ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  edit: first part shifted to Expression Indexing: How to climb the Expression Tree?  Thanks @jthi for providing a solution: Via  Extract expr a user has the possibility to search and extract parts of Expressions. The function provides a pattern search and returns the first match.   Even Wildcards are possible :)   What is the improvement you would like to see?    A mixture of Display Tree Indexing and Data Table Indexing - just for expressions:   A more precise read access via: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myExpr=Expr(gb = dt << Graph Builder( Size( 437, 413 ), Graph Spacing( 4 ), Variables( X( :height ), Y( :weight ), Y(:height), Overlay( :sex ) ), Elements( Points( X, Y, Legend( 1 ) ), Smoother( X, Y, Legend( 2 ) ) ) )); //instead of: Arg(Arg(Arg(Arg(Arg(myExpr,2),2),3),3),1) // I want to use: myExpr[2][2]["Variables"]["Y"(2)][1] //assign // send // Graph Builder // Variables // or like it's possible for Display Trees: myExpr["Variables"]["Y"(2)][1]   Where it gets really cool: write access similar to what's is possible via Data Table Indexing: myExpr["Variables"]["Y"(2)][1] = Expr(:height); Like Substitute - but in a different dimension! [edit] And maybe the best application of Expression Indexing:  Insert Into , e.g.: Insert Into ( myExpr["Variables"], Expr(Y(:age))) Why is this idea important?  With the Power of Expression Indexing, Expression Handling in Jmp will get easier :)         more wishes submitted by   ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  Some while ago, I found this post in the community: In graph builder, is there a way to set the default color code gradient range to "Middle 90%"?  by @tsg.     Up to now, there was no reply - and I could not find a related wish ...     What is the improvement you would like to see?  Possibility to set the default range of a color gradient to Middle 90%.   Alternative options: 1% - 99%?       Why is this idea important? The middle 90% option is amazingly useful - outliers don't destroy the color settings. Especially for exploratory data  analysis of a "dirty" dataset - e.g. by using the Column Switcher!   But at the moment, the user has to enable the setting manually - and concerning Column Switcher it's disabled after every single switch. Argh!   The possibility to set the default range of a color gradient to Middle 99% would solve the issue         more wishes submitted by   ... View more

VIF values can be found in Fit Model output, but not in Evaluate Design output.  Since VIF is not a function of Y, it would make sense to also show VIF values in Evaluate Design.  (One could generate random Y data to get VIFs in the Fit Model output, but maybe we shouldn't have to go through this extra step to see VIFs when creating experimental designs.) ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2024     In Column Properties, one can define the colors and the order for specific "values" - but ist astonishing that JMP is lacking a possibility specify the marker settings as well. Therefore, the user has to synchronize the settings manually for every single plot: https://community.jmp.com/t5/Discussions/color-settings-for-quot-missing-quot-values/m-p/565346/highlight/true#M77738    "Marker by Column" sounds almost like the missing feature - but a closer look shows that the functionality is "related", has little overlap and several disadvantages.   My wish: An additional column property setting to specify Marker settings for specific column values. The functionality should be analog to "value colors", but for markers.   The benefit: The user can specify (colors and) markers for specific values and make them more visible (e.g. highlight and differentiate between different fail categories, show "pass" with a tiny standard marker).     WHY IS THIS IMPORTANT? "Marker by Column" uses row states to assign Markers. the issue: The setting is active for ALL (!!!) Plots - not just the plots where a specific column is used as overlay. With the help of Value Markers, one gets the chance to specify different sets of markers for different columns. This is already possible for Value Colors and Value Order. Why is it not possible for Markers.     more wishes submitted by   ... View more

I would like to be able to have a secondary set of limits to use in the column properties that will work with all of the different distributions and such. In my work we often have specification limits as well as guard banded limits and currently I have to run analysis twice once with spec limits and once with guard band limits. But it would be nice to see them together on the same charts.  ... View more

Topic: add build-in capability that allows to paste directly a list of column names -from clipboard- in column dialog filter.   Today's workaround: as of today, I did a script that  takes the clipboard content -loaded with column names- and converts it into a regular expression. Then, I paste this regular expression in filter and I select 'regular expression' filter mode. This works but is a bit painful. I use this often when working with 'column switcher', but I assume this may work for many other needs.     ... View more

Hi,   Could it be possible to implement a new function for encrypt and decrypt multiple files ? A way to encrypt or decrypt multiple files which have the same password. Could be very interesting.   Thanks Regards Guillaume ... View more

☑ cool new feature ☑ everybody will want it! ☐ removes a bug ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  Table Scripts are useful, Column Switcher and Data Filters are helpful. But - have you ever dreamed of having a universal control panel for your presentation? In Jmp 19 (?) it will be available *)   *) if enough users support this wish with a Kudo.   You might know: Enhanced Log/workflow Builder has two different ways how actions are recorded. a) for Tables, every change is recorded as a separate step: if a table is changed, JMP does NOT record a script how to generate the current data table, it just records how to get from the previous version to the current one   b) for reports, just the final version of the report is recorded: if a report is changed, Jmp doesn't record anything. Just at the end ... JMP         ....  records a script how to generate the current report]   Some days ago, @bswedlove posted the wishChanging a label should show in the Log  Let's start with this wish ... and think big - really BIG.   What is the improvement you would like to see?  add a setting for the enhanced log/ workflow builder on which level to record the steps: a) slim: just final scripts for reports (like now) b) verbose: intermediate steps are recorded as well What comes out: Presentation Autopilot   With the current Workflow Builder, a user can record his analysis workflow and use it again for the next data set.   With Presentation Autopilot (aka Workflow Builder 2.0), a user can generate an interactive, easy to use, fancy, impressive ... Presentation Workflow. He can start with a graph - and record whichever change he makes, group such steps and voila: he has an autopilot which can be used to interactively guide him through the changes of the graph, add variables, change colors, add labels, remove variables, replace variables, add a data filter, change the size, ...   Why is this idea important?  It will be sooo cool - everybody will want it! other wishes from  ... View more