JMP Wish List

Currently depending on the size of data / data structure which I want to get the uniques from I use following: Data table column values Associative Array (if I'm lazy, but gets slow with lots of values) Summarize (a bit better, also slows down) Summary table and get values (I can get counts this way if I want to) Distribution platform and get values from Report layer (nice thing with this, is that I can get other statistics at the same time and it is fast) Lists Associative Array Insert values to table and use methods mentioned above My suggestion is to add specific function to get unique values from from data tables and lists in a list/matrix. It could be also data structure like Python's Set (and if were to be data structure  A set is an unordered collection with no duplicate elements. Basic uses include membership testing and eliminating duplicate entries. Set objects also support mathematical operations like union, intersection, difference, and symmetric difference. ... View more

I would like to be able to specify decimal separators as comma or period on a per table basis. So decouple it from my local computer settings. Reason being that I import data from all around the world and export to people around the world as well. ... View more

What inspired this wish list request?  During exploratory analysis, which JMP admirably encourages, we often do the types of analyses that can be well represented both in graphs and tables. In such a situation, some people launch Graph Builder and some do Tabulate, often ending up with similar results with different representation. Some types of graphs, made with Graph Builder, can theoretically be converted to tables in Tabulate, and vice versa. We often end up creating both graphs and tables, which summarize almost identical information. We sometimes feel like switching between Graph Builder and Tabulate, but this is not easy and we need to start over.   What is the improvement you would like to see? When a graph can can be represented with a table, give the user an option to have the graph automatically converted to a table, and vice versa. ... View more

Every Computer change I appreciate the "Get" Funtion for the Preferences.    I'm missing that the AddIns will be integrated into my preferences. Now I need to install them every time again. It would be helpful to have one Click and have Jmp running as is ran on the old computer. Thanks Peter ... 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?  The Regex search in Jmp is restricted because the user is not allowed to set all flags which are officially available for regex searches.   vs. what is possible in Jmp for Regex():   What is the improvement you would like to see?  Please add options to enable/disable all flags.   Please start with standard behavior which matches other tools.   Why is this idea important?  At the moment, with singleline option enabled, the result of a Regex search in Jmp differs from what the user expects after debugging the Regex search outside of Jmp (unfortunately, there is no Test system in Jmp which can be used to debug Regex searches): Regex: disable singleline option  So, it will be highly beneficial once  - Jmp behaves the same as the other tools. - Jmp allows all options which the user finds in other tools.         more wishes submitted by   ... View more

☑ cool new feature ☑ could help many users! ☐ removes something that feels like a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  Sometimes / often missing values are even more important than the available values. Great: - More and more modelling platforms got the option "informative missing". - Column manager shows the number of missing values:   - there is even a platform to analyze Missing Value   On the other hand, there is Graph Builder: With the default setting, Graph Builder doesn't show "missing values". If a user generates a x/y scatter plot and uses a column with missing values as color or overlay, all the points with missing values will DISAPPEAR from the scatter plot. The "easy" solution: enable Include Missing Categories from the Shift + red triangle menu - or via the preferences.  Then the points will show up with a separate category:   For nominal values on an axis, it's the same, the values will show up as a separate category. Very convenient to Explorer Missing values.     Unfortunately, for continuous values, there is no option to show the missing values separate from the other points. A workaround: the user can generate a transform column for is missing(:col) and show the points in a separate subplot: Missing entries - modelling type: continuous        But unfortunately, the functionality of  transform columns is quite restricted: improvements for Transform Column  e.g. - a transform column doesn't react on changes via a column switcher - it's not possible to get a reference to a transform column. Therefore it's not possible to programatically change the transform column to the new column   What is the improvement you would like to see?  Please add an Option Include Missing values to Graph Builder (via Shift + red triangle menu - and maybe via preference) which acts like  Include Missing Categories , but for continuous values - and generates a plot similar to this one:     Why is this idea important?  In combination with column switcher this will add a new, incredibly useful way to explore missing values :) Just imagine how useful it will be to display missing values in a Graph - separate from the actual values.   more wishes from   ... View more

  When performing stability regression analysis  (Analyze/Reliability and Survival/Degradation – than Stability test), to the field  "Y, Response" it is possible to add only one parameter. It will be great to have option for analyzing multiple parameters at same time (like in Capability analysis)? Sometimes there is  a lot parameters to be analyzed during stability check .       ... View more

What inspired this wish list request? Challenges with establishing the ability to pull data from SharePoint lists and/or files stored on sharepoint.  SharePoint is a tool that is used for managing tasks and incoming work.  There are several instances where we would like to be able to pull from these lists to use the data for metrics and dashboards.  Connecting to the lists and having the ability to pull in files (.jmp, .xlxs, .csv) that are stored on the SharePoint is very important to use.   What is the improvement you would like to see?  Something similar to what is available to Google Docs to allow easy access to import SharePoint lists and documents stored on a SharePoin   Why is this idea important?  To ensure metrics are accurate and up to date.   ... View more

What inspired this wish list request? Having to perform a task of "make combined data table" and re-creating a complex function multiple times to get the desired values.  Also, is difficult to coach scientist on how to do this with their data and there is opportunity for the formula to be modified or entered incorrectly by mistake.   What is the improvement you would like to see? Custom formulas for summary statistics that can be created then used in Tabulate, Distribution, Summary, Graph Builder etc. It would be great if you could also use any of these formulas as column formulas with the option of By Variables.(ex. Col GCV(:Column 1, :By Variable Column))     Why is this idea important?  Increase efficiency; Avoid errors when re-entering formulas; Allow flexibility to add to the COTS based on need.       ... View more

What inspired this wish list request?  Many countour plots benefit strongly from a labeling of at least some iso lines     What is the improvement you would like to see?  To my understanding, labeling of iso lines is possible for contour plots generated directly from the graph menu but not for a contour plot made via graph builder Also the labeling is very unflexible - for narrow lines the labeling are overlapping and thus unreadable. The positioning seems to be fixed.    Why is this idea important?  So far I can only make nice contour plots with competition software like origin - would be nice to have a more flexible contour plot in JMP to have the possibility to completely switch to JMP.     ... View more

When using a non-parametric test in the Fit Y by X oneway analysis platform the chart would stick with the default of showing mean values (group means or overall mean). It would make more sense to have a chart display that matches the type of analysis being selected. ... View more

What inspired this wish list request?  Model selection is essential for DoE Analysis. JMP provides this feature for platforms like Fit Stepwise or Generalized Regression, where only fixed effects are present in the model. However, by using Split Plot Designs or random block models I need to use either the Mixed Model Platform or the Generalized Mixed Model Platform. Both platforms does not allow automatic model selection steps like Backward Elimination, Forward Selection or Prune Forward Selection. Thus, I'm forced to perform these steps in a manually way, which are very tedious. Other software tools like Design Expert already allow automatic model selection for split plot designs!     What is the improvement you would like to see? Simply add all the model selection features from the generalized regression platform (see screenshot) to the Generalized Mixed Model Platform       Why is this idea important? At the moment I have to use Design Expert to perform a model selection on Split-Plot Designs, because it is too much work to do this manually in JMP. In other words, I cannot use JMP for Split-Plot Model Analysis respectively not even for random block models!     ... View more

☑ cool new feature ☑ could help many users! ☑ removes a "feels like bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request? With the Subgroup option in Table/Summary one can split group statistics by subgroups - several columns can be used as subgroups to get even more details.   At the moment, when several columns are selected as subgroups, all possible combinations are hierarchically listed. For the example here: Table summary - Subgroups every single day of the week X every single day of the month gets a subgroup, ending up with 7 * 31 = 271 subgroups (dom, dow)   Sometimes, the user just wants to generate a fast overview with subgroups from several columns. Therefore, subgroups should not be listed hierarchically, but just put next to each other (side-by-side subgroups *): This is not possible yet in Table/Summary and the cool intersection feature feels more like a "bug" :)   As a workaround, the user can use the Tabulate Platform: https://community.jmp.com/t5/Discussions/Table-summary-Subgroups/m-p/589647/highlight/true#M79432  Tabulate gives the user all the flexibility to choose between hierarchical listing of (sub)groups and putting (sub)groups side-by-side  (actually: groups ... below each other :) But Tabulate has several disadvantages: - Tabulate doesn't provide interactive linking to the source table - Tabulate doesn't provide sorting (right?) - Tabulate doesn't support columns with modeling type multiple response   What is the improvement you would like to see?  For the Table/Summary Platform, please add an option that allows the user to chose if several (Sub)group Categories should be intersected or just put next to each other.   Why is this idea important? The click effort to generate a  summary with side-by-side (sub)groups (*) can be significantly reduced. e.g. for the example in Table summary - Subgroups  from ~ 17 clicks/dragNdrops to 5 clicks/dragNdrops.         more wishes submitted by   ... View more

I'm currently working on some larger JMP-scripting projects where version control is a must. With JMP14 I started to work with projects.    Committing & pushing my code to github manually is a bit of a pain. It would be great to have some very basic functionality like commit/push/pull integrated in JMP projects. ... View more

As you know, many of data scientist use XGBoost, LightGBM, and CatBoost (gradient boosting decision tree) to solve their problems by using Python. Could you add these modelings in the decision tree menu (JMP) as well? If it can be provided by JMP Script Language (JSL), it will be great as well. Thank you. : )   Reference: https://papers.nips.cc/paper/6907-lightgbm-a-highly-efficient-gradient-boosting-decision-tree.pdf         ... View more

From time to time I have to look matches from long strings and usually regex is the method I will (would) use for. Below is an example where I try to find all words starting with f Names Default To Here(1); str2 = "which foot or hand fell fastest"; show(Regex(str2, "f[a-z]+")); // wanted result {"foot", "fell", "fastest"} This will return me only the first match ("foot"). I would request a flag to be added, which could be used to find all possible non-overlapping occurrences, in similar manner as Python's re.findall works.   ... 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": in the context menu add "allPlotGroups" as argument for the column aggregation to provide the same functionality as Summary Statistics. (edit: @Graph  : ) 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. On the other hand, when I activate "mean" or "median", all lots which are processed on the same day will get averaged. 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 Transform 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

When I write code, I try to make it easy to read, understand, and maintain.  I write comments.  I indent code blocks.  I use line breaks to spread the code out over multiple lines.  I try to write code with a consistent style.  However, I frequently find that JMP reformats my code without asking.  It simply decides to obliterate all the effort that I put into good coding practices.   For example, I write a script and attach it to a data table.  Then I right-click on the script and press "Copy" and then right-click in the script window and press "Paste".  The copy of the script does not contain any of the comments or code block indentions that were in the original script.   Another example:  I create a formula column on a data table.  Inside of the formula editor block, I write some JSL code to perform an iterative calculation (this is really cool. I just figured out you could do this!).  Of course I want to use comments and whitespace in this code, like I would in literally any code that I write anywhere.  Well, after I hit enter, the comments are invisible until I double-click on the formula editor block.  But they do exist.  Until I click OK and JMP evaluates the formula.  Next time I open the formula, comments and whitespace are gone.   It gets worse.  I have multiple scripts attached to my table that all reference a certain column.  Then I rename that column.  All of these scripts are updated with the new column name.  But in doing so, they are all "reformatted" by the JSL parser and all of my comments and whitespace are destroyed.  ಠ_ಠ   What is the point of even having comments in the JSL language if JMP is going to immediately wipe them out at the first opportunity?  Am I supposed to edit my JSL scripts in a less-hostile text editor (i.e. Notepad++) and store the readable versions as separate files?  I just don't understand why it has to be this way.  Please leave my comments alone!   Note: @Cwalla reported the same issue in the forums here  ... View more