JMP Wish List

☑ 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?  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! ☐ 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

How is it possible to change the Font setting of Y Group in graph builder?   I'm using JMP Pro 14.1   It is not possible to right-click to change those as with e.g the x-axis.   The Group font and font size are controlled by the "Text" size as specified in the Preferences for JMP.  They are not controlled as an individual graph by graph setting.      File --  Preferences -- Fonts    It would be nice to be able to control the fonts by right-clicking   ... View more

I have over 100 graphs that generated from graph builder, I need to export them to ppt and 10 graphs per slide. Now export only can do one graph per slide, and I have to manually copy paste to make 10 graphs per slide. I am sure, I am not the only one have this pain, and it will make sense to have this option in exporting in the future.   ... View more

The summary table is a handy operation that unfortunately lacks some basic statistics. For instance, obtaining the mode is not possible even though that function exists in JMP.   See this: Additional functions for summary table via JSL    In 2016, Brady Brady released an extended version that trims extreme values as well.      Other functions to add can be first skew, kurt, corr, cummax, cummin, cumprod, cumsum, diff, first value, last value, fitness to distributions, etc. ... View more

Previously I asked a multiple Y-axis overlay chart in the user community (Multiple Y axis in a chart. (Multiple Y axis scales)) and Byron made a scirpt for it (Multiple Y-Axis Graphs).   I hope I can get this feature from the 'Graph Builder' in next JMP version with interactive Y-axis setting. Currently the multiple Y-axis graph (from the script) dosen't link with the data in the graph. If the data is linked with multiple Y-axis interactively, it will be better than other supporting programs. Thank you. : ) ... View more

☑ cool new feature ☑ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   [edited and adjusted to the new design]   What inspired this wish list request? deficiency of Conditional Data Filters  Conditional in this Data Filters means that "age (1)" defines the items which are displayed in "name (2)". --> cool Clearing the selection in age clears the selection in "name" -> not cool : (   What is the improvement you would like to see? Please add a control in the red triangle menu and via preferences to enable an alternative mode: !! lock childs when clear !! The new behavior: If a selection is cleared via >> the selection in child filters should not be reset anymore  << (sure: the row selection should be adjusted to fit to the displayed selection)   Why is this idea important? the proposed behavior has 2 modes where it can show it's advantages:   A) The new lock childs when clear  mode allows a very cool way of selecting rows: use a parent filter to select rows with interesting features, e.g. pass/pail = fail with "Conditional" activated, other filters will adjust accordingly e.g. batches will just shows batches with fail units  select all these batches clear the filter selection for pass/fail you just filtered all batches with fail chips Once you understand the magic behind it, it's a feature you won't want to miss. This way, during exploratory data analysis, you can  "stay in the flow" , just make one step after the other. No need to create a column formula with grouped Col aggregation or similar workarounds.   B) Another benefit which cannot be rated high enough! It will save users hours of waiting time over the course of their working lives:     The current "clear all child-selections" mode for conditional data filters results in long graph rendering times: Every time a selection is cleared, all child selections are cleared as well. No chance to restrict the plot to a subset! So, every the  user has to wait dozens of seconds, or even minutes.   I often work with large data sets which can just be displayed efficiently if a subset is selected (!). The current behavior of Conditional Data filters is so time consuming that I decided to deactivate it. Same for you?   The lock childs when clear mode will fix the issue: With the new behavior, the user can make a "dummy" selection (just a single row), clear all the other data filters, apply a new filter and then clear the dummy selection. What an improvement! right? ... View more

What inspired this wish list request?  The Parallel Plot (Sankey Plot) option in Graph builder is great! It provides you a very intuitive way to compare a multitude of columns. You can even flip a scale to align columns which anticorrelate.   But there is one big problem which makes the parallel plot less useful than it could be: There is no possibility to adjust the individual scales, like. e.g. in this Add-In: Parallel Plot with Axis Scaling   by @txnelson . Therefore, a single outlier point can ruin a whole "column".   there are some option to solve the issue - with their own drawbacks: - Nuke the outlier data point. - Switch to log (x+1) scale,  as @julian showed @ Discovery summit Europe 2023.     What is the improvement you would like to see?  Please provide an functionality to adjust the scales in Parallel Plot.  Nice: an option to choose ranges in order of MAD (median absolute deviation), e.g. +/-3MAD, +/-6MAD.     Why is this idea important?  With the new functionality, Parallel Plot will be much more useful than it is now.         more wishes submitted by   ... View more

What inspired this wish list request?  I frequently use moving (rolling) fixed size window statistics that can be computed independently for an asset (byVar) for a number of X variables over a datetime ordered data. In my analysis, a predictive quality model has not only select important X's but also a datetime cycle where the effects are most significant from to distinguish normal from abnormal assets.    What is the improvement you would like to see?  A version of these exist in formula stack as Col moving average. I like the ability to add many other statistics using formulas (and not scripts).  I like the following moving statistics be available simply from formulas these include (but not necessarily limited to) ..   moving specific quantiles (wish list from https://community.jmp.com/t5/JMP-Wish-List/Col-Moving-Quantile-function/idi-p/321573)  moving stdev moving slopes moving non parametric Kendall Tau statistic one could imagine moving any statistic     Why is this idea important?    Without the formula functionality, I need to go back to a scripting to recall how to do this every single time I need it. I think one of the main strengths of JMP is being  one of the easiest tool/platform to offer advanced statistics & modeling . Formulas is a great way to keep carrying the notion of "easiest". I can script but I prefer not to.  ... View more

I have two columns of integers (along with a bunch of other columns), and would like to overlay in Graph Builder on the pairing of the two --   Since overlay only accepts a single variable, I typically do this by creating a new column with both columns comma-separated by using the "New Formula Column" -> "Character" -> "Concatenate with comma", but when both columns are numeric, concatenating with comma is no longer an option, requiring a custom formula with char() and "||".   Request adding a "Concatenate with comma" option to "New Formula Column" -> "Combine" menu. ... View more

Gaussian Processes are a very powerful modeling technique in predictive analytics. https://scikit-learn.org/stable/modules/gaussian_process.html   While JMP has GP, it is only for specialized modeling (not possible to fit using training/validation/test)     ... View more

1) What inspired this wish list request?  ☑ cool new feature ☐ could help many users! ☐ removes a „bug“ ☐ nice to have ☐ nobody needs it   #myTop10_2023   In GraphBuilder, one can drag a column onto the Color drop zone to use different colors for the individual items in the column - or to apply a color gradient depending on the values of this column.   By dragging 2 columns into the color drop zone, one can provide 2 columns -and then later specify via the variables list which of the two columns to choose. This makes it possible to apply independent color settings to different subplots, like in Graph Builder - subplot with different color settings?    Unfortunately, it's not possible to use more than 2 colors :(   2) What is the improvement you would like to see?  Please allow Jmp to use more than 2 columns in the Color drop zone.   3) Why is this idea important? It's possible to get up to 3 colors into the color drop zone, but the 3rd color doesn't work. It's there, it seems to work, but it doesn't do what it should do. The below code intentionally uses sex twice as color (1. and 3. entry). This is not the reason why it doesn't work - it just helps to illustrate the issue.   A comparison of the top and bottom plot shows that the top plot (which uses the third color column) has wrong colors (no blue points, the points are red) :( In different examples, the second color column was used instead of the third one.           Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); Graph Builder( Show Control Panel( 0 ), Variables( X( :height ), Y( :weight ), Y( :weight ), Y( :weight ), Color( :sex ), Color( :weight ), Color( :sex ) ), Elements( Position( 1, 1 ), Points( X, Y, Color( 3 ) ) ), Elements( Position( 1, 2 ), Points( X, Y, Color( 2 ) ) ), Elements( Position( 1, 3 ), Points( X, Y, Color( 1 ) ) ) )         more wishes submitted by   ... View more

What inspired this wish list request?  JMP17 Fit Y by X, "Means and Std Dev" output report changed the standard columns output. Columns can be changed manually by right-clicking on the table and choosing the Columns I want to see. Preferences to make these Column selections does not exist.  We do not want to create a script or distribute an Add-In.  We would prefer to easily update the Preferences.   What is the improvement you would like to see? Column selection from this output table should be available in the Platform Preferences pick-list.     Why is this idea important? We have several engineers in our company who use the "Means and Std Dev" report in their standard reporting for their important parameters.  They do not want the additional columns in the new standard report.  They want the ability to customize their own preferences for this platform.     ... View more

Idea for this came from How to denote letters to mark significant differences in a boxplot?    These could be displayed (at least) in two platforms Graph Builder and in Fit Y by X when pair comparison is performed. For Graph Builder these could be found from Box Plot settings on the left and/or from right click under box plot (user might also have to be allowed to choose comparison method). For fit y by x not sure what would be the easiest place to add these. Maybe button under Means Comparison or into one of the context menus for outline boxes (Connecting Letters Report)     ... View more

I would like to have Graph Builder be able to Overlay by several variables in the same way that x, y or color drop-zones can take several variables. This would allow overlay to be selected/deselected from the "Variables" group under each graph type and create much more complex and rich visualizations. ... View more

What inspired this wish list request?  With the small icon the left, a user can open heder graphs on top of the data table which show histograms of the available entries. Sometimes, with too many distinct entries in a column, the header graph is too small to show all values. Then the user can increase the size of the header graph - but this reduces the space for the actual data table.     What is the improvement you would like to see?  When the mouse is on the header graph, please add a possibility to scroll though the entries of the header graph - instead of scrolling through the data table:       Why is this idea important?  not important.         more wishes submitted by   ... View more

I would like to suggest the ability to click on the heat map legend when "discrete colors" is clicked on the gradient setting.  So in the picture below when I clikced on the bin between -20 and -30 that data would be selected.     Thanks for considering this.   Steve   ... View more

I really like the new feature in JMP 15 showing the distributions below the headers. Yet, for time series (sensor data), distributions are not enough.   It will be great if we can also add spark-lines (Excel and many other software have them). ... View more