JMP Wish List

What inspired this wish list request?  I often find myself with new data tables that are almost identical to old ones.  I need to pull the plotting scripts from the old tables into the new ones.   What is the improvement you would like to see?  When I drag a script from the top-left pane of a data table window to another window, it looks like it's accepting it, but then nothing happens.  I would like to be able to copy a bunch of scripts from one data table into another via drag-and-drop.   Why is this idea important?   The script drag-and-drop is an intuitive action that seems to work, and it's frustrating that it doesn't.   (JMP v17, Windows and Mac)   ... View more

What inspired this wish list request?  The feature in Graph builder to stack multiple information to a hierarchical structure is very useful.   But the way how it is implemented is just good enough to generate data on work level. For publication or management meetings, it's way too complicated to analyze the axis title and convert the information to labels for the different levels of the hierarchy. Hierarchical X labels    Especially if the labels of the variants don't give a clear hint for the used column:   What is the improvement you would like to see?  Please improve the way how the graph is generated! e.g.: move the labels to the left add some lines   Why is this idea important?  After the proposed optimization of GraphBuilder Plots with hierarchical levels on the axes, no further postprocessing will be necessary anymore to use them for Publications and Management meetings :)       more wishes submitted by   ... View more

What inspired this wish list request? I was at the Greater Philadelphia Area Pharma JMP Users Group Meeting today and learned about the existence of the wish list from the JMP staff. I had requested this to a JMP representative at a different event a few years ago who told me to call JMP Tech support to make the request, but I never did.   I have "Box Plots" and "Plot Actual by Quantile" on by default due to my Platform Preferences for Fit Y by X with a continuous Y and nominal X. (This side-by-side plot is my favorite graph in JMP.) The red default is confusing because it does not match the legend color.   So, I usually change it by right clicking, selecting Customize...Customize Graph... then repeating Box Plot, Box Plot Line Color, and changing the color for each level of X.   Default red boxes misaligned with the legend   Color scheme aligned with the legend that comes with the Q-Q plot.     To make things worse there is a bug in JMP that I have not reported before, which I will report separately to JMP Technical Support. After I change all the boxes to black and save the graph to a script Window or a script in the data table my color customization does not stick. So, I have to redo my customization every time I make the graph. I am using v17.0 now, but I think this has happened as long as I can remember (>15 years). Today is the first day I figured out that changing the color to anything but black sticks in the script because I generally use black. (I know I could add the command lines to the script manually and resave it.)   All black boxes (not saved properly in a script):   What is the improvement you would like to see?  In Fit Y by X...Oneway, Box Plot, the box color should have an option to be other than red in the Platform Preferences. One choice could be black. Another could be the same color scheme used by "Plot Actual by Quantile".   Why is this idea important? Red is confusing for side-by-side box plots when the legend for the normal quantile plot has red to indicated the group with the first level of X. Red is confusing when the dot plots under the box plots have different colored symbols, and one of them is red. Black would work because other elements of the graph are in black.  The same color scheme used by "Plot Actual by Quantile" would work, especially when the Q-Q plot is part of the same graph to the right of the box plots and using the same Y-axis as the box plots.   ... View more

☐ cool new feature ☐ could help many users! ☑ removes a „bug“ ☐ nice to have ☐ nobody needs it What inspired this wish list request?  from @ https://community.jmp.com/t5/Discussions/How-to-know-if-a-table-is-a-linked-subset/m-p/655280/highlight/true#M84437  If I try to concatenate tables with the option Append to first table, the script stops with the message:   Cannot append to table: Big Class. Possible reasons for this include: the table is locked, the table is in a platform with a by group, or there is a linked subset of the table. in access or evaluation of 'Concatenate' , Concatenate(/*###*/Data Table( "Subset of Big Class" ), Append to first table)     The error message was very helpful to identify the issue. But how to make the script robust against linked subsets?   What is the improvement you would like to see?  An addition function: dt << get list of linked subsets() will help. Then I can close the subsets via JSL.     Why is this idea important?  code won't crash if there are linked subsets. Alternatives: Jmp updates the linked data tables Jmp cuts the link automatically concatenate get a new option: Jmp_is_allowed_to_close_linked_data_tables_if_this_is_needed_to_run_this_concatenate(1)        more wishes submitted by   ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ (either 1 &2 or 3) ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  Color by Theme in Graph builder is very cool! It can save the users a lot of manual fiddling around with the colors: Color by Theme -> cool feature!  The person who implemented this features deserves an award!   Unfortunately, this feature is missing for Point Plots   What is the improvement you would like to see?    Color by Theme for Point plots   Why is this idea important?  It will save many Jmp user N x some minutes of work - every day. ... View more

☐ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  Every day I generate a dozen of summary tables, just with a single column as group variable and without any aggregation. ... just to get Jmp calculate the number of unique values in that column. Definitely much faster than writing a JSL code with Summarize :) But still: several mouse clicks.   And then I generate other summary tables just to get the mean, max, min ... value of a column.   I guess that other users use the Summary Platform for similar means.   What is the improvement you would like to see?  Add a functionality to show a short a column statistics in the status bar when the user moves the mouse over the column header histogram or the name of a column. In the preferences please proved a list with aggregation options - the more, the better.     Why is this idea important?  Huge speed improvement.   I "fear" that this functionality is already available (so obvious)  - and that I wasted my time by creating this post. where?         more wishes submitted by   ... View more

What inspired this wish list request? JMP is a great tool for data exploration, and helps build quickly prototypes for predictive models, to see if there is an added value in pushing the analysis and modeling further. Looking at the panel "Overall Statistics" for a classification topic, I find there may be some performance metrics missing that are frequently used in the Machine Learning / Data Science world. Here are the metrics currently displayed for a classification topic (example from a bootstrap forest):    What is the improvement you would like to see? I would like to see displayed commonly used performance metrics for classification, such as Sensivity, Specificity, Precision, Accuracy, F1 score, Matthews Correlation Coefficient ... Perhaps directly under the Confusion matrix ? Here are the possible metrics in use for classification topics from an online calculator, with the formulas explained : Confusion Matrix - Online Calculator (onlineconfusionmatrix.com)   Why is this idea important? As JMP is trying to bridge the gap between the Statistics and Machine Learning worlds by integrating several models from these two modeling mindsets in one platform, it would make sense to also integrate Machine Learning performance metrics in the results of a classification model, in order to have all infos in the same place and be able to speak the same common language.  ... View more

Dear Sir/Madam,   I've been dealing with information (eg yield table) from different subcons, on same product.  However, the tables may contain slightly different column names but they're meant to be on the same column.  Hence merging the tables from all subcons is a nightmare!     I have attached a simple table to illustrate what I need to accomplish.   If you could help to develop a command to merge tables with similar column names, that would help me (and JMP community) alot!     Thank you in advance!   Best regards, Voon Yean Ten An engineer from Broadcom   ... View more

  What inspired this wish list request?   Desire to expand functionality of line fitting in Graph Builder plots.   What is the improvement you would like to see?   When fitting a line in Graph Builder, allow the user to force the Y-intercept to zero.  This functionality is available in Fit Y by X (through Fit Special) but not Graph Builder. I have had multiple internal users ask me how to do this, or whether it can be added in the future.   Why is this idea important?  Allows users access to functionality found in another platform from the popular Graph Builder platform. ... View more

What inspired this wish list request?   Desire to further improve interactivity within Graph Builder plots.     What is the improvement you would like to see?   (1) with the mouse over a Graph Builder plot, hold down ctrl (Windows) or option (Mac) and scroll the mouse wheel to zoom out/in around the x/y location of the mouse pointer, and (2) with the mouse and focus on a Graph Builder plot, press the spacebar to temporarily switch the cursor to the "hand" (pan) to allow quick panning of plots   Note, these behaviors are standard in Adobe Photoshop and many other graphical tools.     Why is this idea important?  Quick interaction with data plots is a hallmark of JMP capability, and these shortcuts would further improve the speed/usability of these interactions.   ... View more

What inspired this wish list request?  The process screening has Grouping columns as an option and the "original" order for the table is based on those (and the order of the Columns in the table).  It's not currently easy to get the table back to this ordering via JSL (this is the ordering you will get if you toggle click to sort to "off" position but the order you are presented the table in is always unavoidably based on stability index).  It's possible to hide the stability index column with stability index(0) but not to avoid the ordering.   ex:   Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); //give a distinctive order to something in the grouping dt:Site << Set Property( "Value Order", {CustomOrder({3, 1, 2, 4, 5}), CommonOrder(0)} ); //as advertised that sorts the rows of the table by stability index //even if we don't include stability index obj = dt << Process Screening( Grouping( :Site, :lot_id ), Process Variables( Eval( 5 :: 132 ) ) , stabilityindex(0));   //try toggling the sorting with click see and see that there is a "special" order based on the groupings and order of process columns in the table //it honors that value order //but hard to get this ordering to appear via JSL           What is the improvement you would like to see?      Why is this idea important?      ... View more

What inspired this wish list request? Changing marker size/line thickness in graphs is a frequent task for me, but it takes too many clicks. I shared this idea with John Sall before, and he liked it.     What is the improvement you would like to see? Please program rotating the mouse wheel up/down while holding Alt key as a quick way to increase/decrease the marker size in any graph. For line thickness change you might want to program mouse wheel rotation while holding Ctrl key. Once a lower/upper limit is reached, further rotation of the mouse wheel does nothing.     Why is this idea important?  It increases productivity in tuning the graphs appearance to the user's needs. The idea follows the spirit and example set by on-the-fly font size change by Ctrl-Shift-+/- key combination already existing in JMP.   ... View more

What inspired this wish list request? The need to discuss peers attending different sessions to cover the key subjects.     What is the improvement you would like to see? Provide a Printable or Excel friendly version of the agenda.     Why is this idea important?  To help attendees maximize the value for their organization.     ... 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 command  New SQL Query() is very useful because it allows the user to run the Query in the background. While the query runs the user can continue to work in Jmp. Very efficient :)   The command  Execute SQL() is very useful for debugging because it sends the SQL error message to the log.   It seems that the command  New SQL Query doesn't have the possibility to log the error message ( catch Sql Query error ) and that the command  execute SQL doesn't have the possibility to run the query in the background    What is the improvement you would like to see?  If so, please make it possible to run at least one of the following codes: myquery = New SQL Query(); myquery << run; myquery << get error message; or Execute SQL (... , run background )   Why is this idea important?  With the new functionality the user has the chance to do something else while the SQL query is running to find typos in the SQL code       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?      there are different ways to highlight selected data points,     but sometimes, it's hard to see ALL the selected data points (without searching).   What is the improvement you would like to see?  Providing the possibility to activate multiple options at once:   especially: the combination  of  - unselected faded - selected larger - selected outlined will provide a nice combination which will make it much easier to see selected data points :)   Why is this idea important?  It will facilitate exploratory data analysis in Graph Builder.         more wishes submitted by     ... View more

☑ cool new feature ☑ could help many users! ☑ removes (what fells like) a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2023   What inspired this wish list request?  The Summary Statistics in GraphBuilder are very comfortable, they automatically react on changes of the Data Filter and the calculated values respect the grouping of data points on the x axes, group X/Y, wrap, Overlay and  pages. old part about smoother, where summary statistics is available now:     Unfortunately, Summary Statistics are just available for Point, Line, Bar and Heatmap plots, but e.g. not for for parallel or smoother plots. This is why sometimes it's NOT possible to get a smoother and point/line plot aligned - by automatic means of Graph Builder, like in this plot from Graph Builder: Summary Statistics for Smoother    To fix the issue, one has to do the aggregation "manually" by a Transform Column.     There are many reasons why users add Transform Columns instead of using the Summary Statistics of Graph Builder. - limited number of aggregation option which are available via Summary Statistics ( Add CDFs to Graph Builder , Rank is also missing ) - user has to adjust the statistics (will be used more frequently, once new JSL function: Col N Categories  is available).   The issue of Transform Columns: they are much less flexible than Summary Statistics:   They ignore the Local Data Filter   Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); gb = dt << Graph Builder( Transform Column( "Mean[weight]", Formula( Col Mean( :weight ) ) ), Size( 480, 463 ), Show Control Panel( 0 ), Set α Level( 0.01 ), Summary Statistic( "Median" ), Graph Spacing( 4 ), Variables( X( :age ), Y( :"Mean[weight]"n ), Y( :weight, Position( 1 ) ), Group Y( :sex ), Overlay( :sex ) ), Elements( Points( X, Y( 2 ), Legend( 1 ), Summary Statistic( "Mean" ) ), Points( X, Y( 1 ), Legend( 3 ), Jitter( "None" ) ) ), Local Data Filter( Add Filter( columns( :name ), Where( :name == {"ALFRED", "ALICE", "AMY", "BARBARA", "CAROL", "CHRIS", "CLAY", "DANNY", "DAVID", "EDWARD", "ELIZABETH", "FREDERICK", "JACLYN", "JAMES", "JANE", "JEFFREY", "JOE", "JOHN", "JUDY", "KIRK", "LAWRENCE", "LESLIE", "LILLIE", "LINDA", "MARION", "MARK", "MARY", "MICHAEL", "PHILLIP", "ROBERT", "SUSAN", "WILLIAM"} ), Display( :name, N Items( 15 ), Find( Set Text( "" ) ) ) ) ), SendToReport( Dispatch( {}, "400", ScaleBox, {Legend Model( 3, Base( 0, 0, 0, Item ID( "F", 1 ) ), Base( 1, 0, 0, Item ID( "M", 1 ) ), Properties( 0, {Marker( "Triangle" ), Marker Size( 3 )}, Item ID( "F", 1 ) ), Properties( 1, {Marker( "Triangle" ), Marker Size( 3 )}, Item ID( "M", 1 ) ) )} ) ) ) solid points: mean via Summary Statistics -> different values for different ages, sexes + respects the local data filter open triangles: mean via Transform Column -> all values are the same, LDF is ignored One could argue: the triangles display exactly what the Transform Column is told to calculate. No need to worry. Yes, sure  ... if there wasn't the Summary Statistics! The Summary Statistics got the same task: "mean(weight)"  - and displays completely different values. They ignore the distribution of data points on the x/y axes, X/Y groups,wrap, overlay and  pages. In Principle, this issue can be fixed very easily - one just has to add the respective columns as arguments of the column aggregations. But - with each change of the graph, the user has to check very carefully if all the necessary columns are in in the JSL code. -> argh!   What is the improvement you would like to see?  For Transform Columns in Graph Builder (and other Platforms - like Summary!!!), please add an option to respect the Local Data Filter (option: LDF subset). an option which tells the transform column to split the data similar to what Summary Statistics does (individual subsets for different values on the X axis, X/Y groups, Pages ...). I called it "graph items. (comfort mode  - I am sure there is a word which describes it more precisely :) Alternative option: If a column aggregation is used in a Transform Column of a GraphBuilder it should accept arguments like allPlotGroups, X, X(1), X(5), Group X, GroupX(1), Overlay, Page.   Col Number(:height, :sex, "Page") // if a column is used as page, please calculate individual values for the data points on different pages Col Number(:height, :sex, "GroupY") // if a column is used as GroupY, please calculate individual values for the data points on different GroupsY Col Number(:height, :sex, "X(1)") // please calculate individual values for different values of the column which is used as X(1) Col Number(:height, "allPlotGroups") // please calculate individual values for different values of the column which is used as X, GroupX, GroupY, Wrap, Page Col Number(:height, "GroupX", "GroupY", "Wrap", "Page") // similar to the previous one, but no subgroups for "same X value"   "comfort mode" from the context menu and "allPlotGroups" as argument of the column aggregation provide the same functionality as Summary Statistics. The last example is something I wished for a long time when working with Summary Statistics: When plotting data vs. time I can use the lot number as overlay, but if a lot is split over several days, it will show up as two lots. So, here the new feature will provide an even larger flexibility than SummaryStatistics (!): a flexible way to specify how data is aggregated: - just group by Overlay (lot) - don't group by X (time) - instead: average over time (via another Transfrom Column)         Why is this idea important?  Graph Builder is cool. Summary Statistics are very useful - but the functionality of Summary Statistics is limited. (I don't know why the developers restricted the summary statistics to such a tiny subset of what is available e.g. via Header statistics ?!) And when falling back to Formula Columns, issues pop up which show how comfortable Summary Statistics can be.   With the new feature, users can use Transform Columns with the comfort and flexibility which they got used to from Summary Statistics - and without the limitations.   more wishes submitted by   ... View more

What inspired this wish list request?  I make several reports that run hourly on a server farm -- they output static reports via HTML files, and one way that I'd like to visually display if the report is stale is to have a short little JavaScript header that checks the creation time vs. the current UTC time (our company has users around the globe), and if older than 2 hours it'll turn the background red.     What is the improvement you would like to see?  I'd like JMP to natively give the UTC offset of the local time-zone.  Currently I spin up a short little Python script in the AddinLoad file to determine it, but It'd be nice to have it be native       Why is this idea important?  Having UTC offset can be handy when dealing with users across multiple time-zones.   ... View more

What inspired this wish list request?  Publishing some charts to JMP Live, for example MDMCC reports, has been a disappointment.  A lot of value for that platform and other use cases comes from graphlets.   What is the improvement you would like to see?  Support custom hover labels and graphlets in graph builder when published to JMP Live.   Why is this idea important?  Much of the benefit of displaying data in live reports comes from context provided with and behind that data.  If a value is out of spec, why? If a T2 metric is high, what caused it?  Without that info on display right where and when it is needed, users need to navigate multiple reports using complicated filtering to learn the same thing.   Two common places where hover graphlets are valuable: context for a single point on a time series trend, and showing time series trends and score contributions for outliers in a latent variable score space. ... View more

☐ cool new feature ☑ could help many users! ☑ feels like a bug ☐ nice to have ☐ nobody needs it What inspired this wish list request?  Multi file Import: Discovering Files takes too long  For files which are stored in a network folder, it's can be faster to open Python, write a new code using GLOB and use the file list as input for Open in a for loop ... than to wait for MFI to fill the file list with entries which are then de-selected by the name filter.   What is the improvement you would like to see?  Please add an Option to MFI which i as fast as GLOB: The user specifies some filenames -> MFI finds the files (if the specs for data, size etc. are disable, there is no need to invest minutes to get this data. get it when the user activates one of the specs)   And Don't do it vice versa:  find all files in the specified directory, read the date, file size, etc. and then find out that just 2 of the thousand of files in the list match the filename spec.     Why is this idea important?  Make Jmp as fast as other tools.         more wishes submitted by   ... View more