JMP Wish List

Many tables I work with in Query Builder have many field names.  Sometimes I have an existing query and want to add a few additional fields.  The search field might not help if the field name is abbreviated differently than I expected.  The visual of italics when a field is already in the list helps some, but it is hard to turn my brain on/off as I scroll through the list to find the non-italicized field name I'm looking for.  It would be very helpful to have a filter on the search field at the left of query builder to only show the fields NOT already used in the main query build (not selected).  It should work with the filter you already have for highlighting one table and only seeing the fields for that table.  This is an "ease of use" idea.  I can get around it, but it is frustrating because it seems like it could be a relatively easy filter to add.   I asked if there was an option to do this at the JMP training at my company, and they thought it was a very useful idea that was not currently available and suggested I enter it here.    Example:  In the image below, a filter for "Fields not in Query" would show just Order_Type and Customer as those are the only fields not in italics (not in the query).  I assume it would be accessed from the red triangle.     ... 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

What inspired this wish list request?  Often small ad-hoc groups across teams want to explore data together.  Today these need to be in separate spaces, eventually they can be in separate folders, but in both cases that means the only way to organize posts is based on permissions.   What is the improvement you would like to see?  Allow permissions to be applied to individual posts. That way a user can put similar content in a single folder or set of folders, and only share the posts that are relevant to individuals.   Why is this idea important?  Managing larger numbers of reports in other software is difficult and frankly just does not happen.  Giving more flexibility over how posts are organized will make it just a little easier to keep jmplive from being cluttered with old posts, folders, and spaces.   ... View more

What inspired this wish list request? This post Referencing a table that is created via "make into data table"  where user is creating complicated Workflow and tries to get values from report tables (when JMP creates tables from report table boxes they will get named "Untitled automatically.)   What is the improvement you would like to see? When user uses Make Into Data Table or Make Combined Data Table let them choose the name of resulting table.   Why is this idea important? Improves JMP's capability to provide robust scripts to user (easier for non-scripter people to create automatisations with enhanced log and workflow builder). ... View more

What inspired this wish list request?  Graph Builder has a DropZone to automatically adjust the color of Data Points, Bar charts, Heat Maps etc. Whenever several rows of the data table are combined to produce one data point, bar, heatmap cell ... , the respective colors are blended. Very cool!   Unfortunately, Tabulate doesn't have a Color Dropzone: https://community.jmp.com/t5/Discussions/Color-Tabulate-report-based-on-other-column-value/td-p/528641  https://community.jmp.com/t5/Discussions/Color-Cells-based-on-formula-result-and-display-using-tabulate/td-p/56954      What is the improvement you would like to see?  and let Tabulate automatically adjust the background color of rows. If several rows of the data table are combined to produce one row in Tabulate, the respective colors should be blended. Like in Graph Builder, please add a function to adjust the transparency.     Why is this idea important?  Just imagine how useful Tabulate could be with the new function :) - for hierarchical groups, the main label could be used as color to give the table some structure - a column could be used as color which is not directly used for Tabulate - to highlight some rows.   v18 (?):         Tabulate without colors (v17.1):   Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Tabulate( Show Control Panel( 0 ), Add Table( Column Table( Analysis Columns( :height, :weight ), Statistics( Mean ) ), Row Table( Grouping Columns( :sex, :name ) ) ) )         more wishes submitted by   ... View more

What inspired this wish list request?  If nominal values are used on an axis - esp. if such values are stacked in a hierarchy -  it's hard to trace which data belongs to which entry:   What is the improvement you would like to see? In the Axis settins, please provide an option to define the background of the axis labels by the Value Color of the respective label:     This makes the plot much nicer and easier to understand. It should be possible to activate and deactivate value colors for each level of the hierarchy:   alternative: all levels get the color from one of the levels, like @Thierry_S suggested in     Why is this idea important? The ability to change the background of the axis labels is a cool new feature to generate more attractivep lots. It  can be used to highlight a specific value - like in this comparison of 2 test runs: By the green background color, the focus is directed to the central value - at the intersection of pass/pass devices.         ... View more

What inspired this wish list request? Thanks for updating the interactive HTML output (File > Export >  Interactive HTML with data) in JMP for sharing results with colleagues! I use it many times and it really is a great feature! When I create a scatterplot matrix based on simulated data I like to filter my data. I can do this also within the HTML file output with the mouse by drawing a rectangle across the data points.     What is the improvement you would like to see? It would be much more intuitive to do this via the Local Data Filter. This feature is however not interactive in the HTML output. Could you fix that?     Why is this idea important?  Easier data & result sharing; onboarding new people to JMP       ... View more

What inspired this wish list request?  There is a plethora of posts in the Jmp Community concerning Date and Time data curation, e.g.  Manipulating Timestamp  Unix Timestamp to Real Date & time  Changing Date Format  Date-Time Format Problem  Date Format help please  change date format    There are some tools which help a lot - but any improvement will help :)   For time & date columns the user can select from a long list of standard settings and even specify a custom pattern. BuiltIn presets can be concatenate to construct the desired pattern.   Unfortunately, every time the user has to construct a pattern he has to start from scratch.   What is the improvement you would like to see?  Please add a history to the custom date/time pattern dialog window.     Why is this idea important? If a user uses a pattern once, there is a large chance that he will use it again. With the history aavailable in the dialog window, it will be much easier to use the Format Pattern window: Invest the time once to generate the pattern and enjoy it for the rest of your live.           more wishes submitted by   ... View more

What inspired this wish list request? Silent installation of JMP using DSC tools like Ansible, Chef, SCCM, GPO, fail with an InstallShield error. While the .iss file is a neat feature, InstallShield installs of JMP will fail using these methods.     What is the improvement you would like to see? The ability to silent install JMP repeatedly with DSC tools :D     Why is this idea important? IT departments are increasingly using DevOps tools to automate their environments and deployments. Ensuring compatibility with such package managers like Chocolatey or SCCM would be a huge benefit. Using a MSI installer would do that, I believe.     ... View more

☐ cool new feature - no, but: ☑ could help many users !!!! ☑ removes something that feels like a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  When the user changes the order of subplot in graph Builder tby dragging the label on the X or Y axis to another position, strange things happen: https://community.jmp.com/t5/Discussions/Graph-Builder-settings-for-new-FrameBoxes/m-p/561610/highlight/true#M77469   In this example, - dragging "height" on the Y axis to the top resets the colors (!!) - dragging"height" on the X axis to the right does NOT reset the colors (? :) ) - just grabbing and releasing "height" on the X axis resets the colors (!!!)     In addition, when adding new subplots it's almost a gamble how the plot will look like: The color/marker settings are cloned to new subplots, if variables are added via drag & drop  - on the right of an existing X variable - on the bottom of an existing Y variable and the settings are not cloned if the new variables are added - on the left of an existing X variable - on the top of an existing Y variable (99% of the use cases !!!)     What is the improvement you would like to see?  please fix the issue! When a user changes the order of of subplots or adds new variables, some actions should take place on a plumbing layer such that on the porcelain layer  everything behaves like expected.   Why is this idea important?  1) When changing the order of subplots, every user expects that just the subplots change their position - nobody would expect that color settings change.   2) When a user adds variables to the x or y axis, the result should be predictable. The result should be the same - regardless of wether you add the new variable on the left, on the right, on top or at the bottom of the existing variables.   other wishes from          dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); gb = dt << Graph Builder( Size( 534, 496 ), Graph Spacing( 4 ), Variables( X( :height ), Y( :weight ), Color( :sex ) ), Elements( Points( X, Y, Legend( 9 ) ) ) ); // change color/marker settings scalebox = gb << get legend server(); scalebox << Legend Model( 9, Properties( 0, {Line Color( 43 ), Marker( "Down Triangle" )}, Item ID( "F", 1 ) ), Properties( 1, {Line Color( 0 ), Marker Size( 10 )}, Item ID( "M", 1 ) ) ); // add second Y variable gb << add variable( {:height, Role( "Y" )} ); gb << add variable( {:sex, Role( "X" )} ); Wait( 0 ); New Window( "Modal Dialog example", <<Type( "Modal Dialog" ), V List Box( Text Box( "Try to change the order of height and weight on the x and y axis by dragging either weight or height to the other side. Did the color change?" ), Button Box( "OK" ) ) );   ... View more

What inspired this wish list request? We're building a tool that loads well-documented data sources to JMP (a data mesh, essentially). We'd like to reveal the documentation about column governance, data types, and meaning to users conveniently. We can add these details to the Notes property, but this isn't highly visible.     What is the improvement you would like to see? When hovering over a column header, if the Notes property is defined, show a tooltip containing the column notes. Practically, this would display in just the same way Event Handler tooltips display, but rather than being defined at the cell level, it's defined at the column header.     Why is this idea important? Well-documented data sources allow other capable data-workers to understand, work with, and gain value from the data sources generated by others. For us, this means that the scientists who deeply understand, say, protein chemistry can create data tables with notes that allow those of us (like me) who don't really know what a "pI" is to use the dataset fluently.     ... View more

What inspired this wish list request?      What is the improvement you would like to see?    In this example, if I changed the date filter, I would want the P30770 selection to stay selected until the P30770 selection is no longer has any qty in the selected time period.     Why is this idea important?      ... 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

☑ 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

JMP17 has new function called New Formula Column. It would be nice if it were to return the references to the newly created columns in a list, in similar manner as << New Column does for single column. This would make using this function easier   Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp"); new_col = dt << New Column("Log2[height]", Numeric, Continuous, Formula( Log(:height, 2) )); new_cols = dt << New Formula Column(Operation("Log 2"), Columns(:height, :weight)); Show(new_col, new_cols); ... 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

When comparing groups in Life Distribution for the Lognormal Distribution, it would be great if T50 (Median) values were shown in the comparison table, as they are more intuitive than the location values that they're derived from.   When using the Weibull for the same application, this is already the case. There alpha and beta are reported instead of location and scale.   Maybe the same kind of parameter sets could be used and alternative ones provided optionally via right-click -> Columns.   ... View more