JMP Wish List

What inspired this wish list request?  Developer Tutorial: New Python Integration and Scripting Capabilities in JMP 18  @Paul_Nelson  wrote The focus on JMP 18 was character and numeric columns. Full support of the data table is current ongoing development.   What is the improvement you would like to see?  Please add Python support for expression columns.   Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); Python Send( dt ); Python Submit(" dt['age'][1] # works dt['pet'][1] # doesn't work " );   Why is this idea important?  ... View more

Just as the title says, it'd be nice if the Scroll Box() supported the << Scroll Window() command.  Key advantage is being able to put in a DisplayBox and have the Scroll Box go straight to it. ... View more

What inspired this wish list request?  I am working with multiple import of excel sheets from various users and some are applying filters to have the required informations. However I want to import all data of the files in an automated way.     What is the improvement you would like to see?  It happens that hidden and filtered rows are handled differently in excel and JMP 18. It would be good to have a "<<Set Excel Suppress Filtered Rows( 0 )," so all excels don't need to be checked to be sure no filters are applied before running the automation.      Why is this idea important?  This is important in the aim of automatization of data from team or group when not all people have JMP and use filtered specific excel files. If you want to recover all data from these files and not only the prefered ones of each usersto avoid bias in your data analysis     ... View more

☑ cool new feature ☑ could help a lot of Jmp users! ☑ removes something that feels like a „bug“ ☐ nice to have ☐ nobody needs it   What inspired this wish list request?  Workflow Builder is great to define a workflow and then run it again and again. It works very smooth if the input data is always stored with the same filename, like in the talk  . Then the workflow can run fully automatic and will always generate the same output.   If the user wants to run the same workflow with different input files (leading to tables with different names), the data table reference in the workflow steps has to be changed accordingly. This can be done via the Reference Manager and the option Allow Replacement of References:   The topic was discussed in the Q&A session of Workflow Builder or the "baby steps" into Scripting . The issue with this approach - as highlighted by @brady_brady : A user has to sit in front of the computer and has to choose the right table at a specific time during the execution of the workflow. This is especially annoying if the import step was even part of the workflow: step 1: open table step 2: plot -> which table?   To fix the issue, the user has to add some custom JSL to make the workflow fully automatic.   In Jmp 18 the Workflow Builder made a step towards Workflow Manager:  Now it's possible to add "advanced" steps like If/Else and For Each Loops.   A very nice feature (***) the return value of one step can be used as an input for another step - wow! e.g.  MFI → list of tables →  (input)  For Each   https://www.jmp.com/support/help/en/18.0/?os=win&source=application#page/jmp/example-of-a-workflow-with-a-for-each-loop.shtml#      What is the improvement you would like to see?  1) Please make the idea (***) more user friendly by providing an advanced Step: Access Table(s) The step can be placed at position 1 in the workflow and should provide standard options like: - Pickfile() + Open() - PickDirectory() + define file patter + MFI - Current Data Table() - Ask the user NOW to pick an open table   ... similar to the Data Table options in Dashboard Builder:     2) For EVERY step (not just For each) - please provide an option to specify the input value - data table reference - column reference - platform reference .... And there should be an option to select multiple steps at once -  and link all of them to one Access Table(s) input.   2 b) Stick to the approach with the reference manager - and besides the option to ask for a table reference: there should be an option to pick (the return value of one of ) the Access Table(s) step.    Why is this idea important?  Workflow Builder has a great potential, especially for users who don't want to learn JSL. But as soon as the input table name changes the user has to choose between custom JSL and annoying questions which data table to use.   With the proposed improvement, the problem can be solved.   more wishes from     ... View more

What inspired this wish list request?  You never should mess with user preferences when scripting (there is one exception) but sometimes changing them would make things much easier and script simpler.   JMP Projects - Local Preferences is a bit similar to this but has more limited scope   What is the improvement you would like to see?  I would like to see session preferences (these would be kept for the current JMP session) and instance preferences (could work in similar manner as Names Default To Here(1) changes namespace). It should be also possible to set session/instance Ignore Platform Preferences(1), below is example how these could possibly work when scripting Session Preferences( Platform Preferences( Bivariate( Ignore Platform Preferences(1) ), DOE( Simulate Responses(0), Suppress Cotter Designs(1), Save X Matrix(0), Discrete Numeric Powers Set to Necessary(0), Use Blue to Red color theme for color map(0) ), ) ); Local Preferences( Platform Preferences( Bivariate( Ignore Platform Preferences(1) ), DOE( Simulate Responses(0), Suppress Cotter Designs(1), Save X Matrix(0), Discrete Numeric Powers Set to Necessary(0), Use Blue to Red color theme for color map(0) ), ) ); Similar idea could be expanded to work with Presets Session Preset( Distribution( Continuous Distribution( Apply Preset("Focus on Distribution") ) ) ); Local Preset( Distribution( Continuous Distribution( Apply Preset("Focus on Distribution") ) ) ); It could be even worth it to be able to set these interactively and not just while scripting. Add new Session Preferences menu / add button to current Preferences and for presents some way to "enforce" specific presents for the session.   Why is this idea important?  Makes it easier to manage platforms when scripting without worrying about messing user preferences.   ... View more

What inspired this wish list request? other editors that have that small section of the code where you can scroll in a large bar ie, the vscode minimap     What is the improvement you would like to see? the jsl editor should also have this capability     Why is this idea important? i'm not always able to do editing in VScode so I would like the JMP editor to be as pleasurable as possible :)     ... View more

What inspired this wish list request? the ease of other editors to control what level of fold you can open/close code.     What is the improvement you would like to see? Control on the level of code folding either in menu or shortcut keys.     Why is this idea important? Say i have a large function and other functions within that function, i may want to fold the interior functions but not the main level function.     ... View more

What inspired this wish list request?  We are using JSL to create charts for very heavy datasets, and exporting them to PDF for external users with no JMP access. The size of PDF is too big to handle sometimes, there could be dozens of charts in the same pdf with millions of points per charts,  we get PDFs of above 700-800MBytes sometimes, and they are too heavy to open and navigate.   What is the improvement you would like to see?  we want to preserve the options to search for text in the pdf, and keep the resolution of the charts high, but we don't need the plot data to be vector based. So a good solution would be to convert the charts to flat hi-res images and embed them in the pdf with the surrounding text kept searchable.   Why is this idea important?  This is a common issue for all users who export PDFs with charts that shows large datasets.   ... View more

What inspired this wish list request? I tried Alt+clicking function from scripting index, so I could quickly get to specific category but immediately saw that it didn't work like.   What is the improvement you would like to see? I would like like that scripting index would highlight/go to first category when I select item, from non-filtered list of items, which isn't All Functions.   If I have for example simple script like this Names Default To Here(1); Expr() and I would access the category in which Expr is, easiest option would be to open scripting index, write Expr to filter, select Expr from the filtered item list, select Expression from category and finally clear expr from filter.    How I would hope it would work, is that when I click Expr (from non filtered Item list) or alt+click from scripting index, I would immediately be brought to scripting index which has Expression category selected with my desired item also selected (Filter could also be filled, but that should be Preference). Currently I will have All Categories selected and I will have to browse through to find next highlighted category.   Why is this idea important? Makes using scripting index more intuitive and faster. ... View more

What inspired this wish list request?  I want to automate the saving of Animated GIF for my dashboard. Currently, I can click the animation control to play, record & save as animated GIF by using hand. Log and workbuilder did not record the steps done with animation control (i.e Run > Record > Save as GIF).   What is the improvement you would like to see?  Record step taken in animation control in Log & Workbuilder. https://community.jmp.com/t5/Discussions/How-to-save-Dashboard-to-run-animation-gif-through-JSL/m-p/716958#M89863    Why is this idea important?  Currently, 2 weeks to get the correct JSL syntax, just to be able to "Click" play button in the animation control . Save time (since user would never guess "Run", "Go", "Set", "Click" actually are used differently in JSL).   Thank you ... View more

What inspired this wish list request?  Simplicity and efficiency of process screening platform compared to measurement system analysis.   In my earlier positions I was used to running measurement system analysis using more or less complicated macros (minitab) or more or less complicated scripts (jmp). JMP does offer easy way run MSA but to get usable report you have to do more work and if you wish to analyse results further, it is even more work.    What is the improvement you would like to see? I would like to have MSA platform which is similar to Process Screening. User would determine on launch of the platform what to calculate and how to get limits (use limits table/use limit columns in same table/use column properties) and so on... Then when user presses OK, it will create similar table as we can see in Process Screening, lots of information, fairly easy to sort, we can select rows and perform extra actions, we can add more columns to result table and so on...    Why is this idea important? Makes the calculation of MSA / gage easier for multiple parameters and makes analysing results from that single result table possible.       I can provide some ideas and mock-ups what could be included but it will take me multiple hours of work so I would rather first hear is there any point in this request. ... View more

What inspired this wish list request?  The use of iba records (https ://www.iba-ag.com/en/) in the steel and energy industries become an international standard. No direct file import is possible, an intermediate txt file is needed.     What is the improvement you would like to see?  Direct file import (like excel) using preview. Possible batch import with multiple files because these files are process data recording all day long   Why is this idea important?    Developing a gateway would make it easy to open up JMP to this field of activity (metals and energy). Developments (c++, .net,… in dll form) for reading iba files are available from iba. ... View more

What inspired this wish list request? At my company we need to compute ppk and new limits for datasets containing ~10k rows x 10k cols, and this needs to be done on multiple datasets semi-daily.  This can take a very long time.  I've explored writing scripts to automate this using either the Distribution or Process Capability platforms and output the ppk, the best-fit, the parameters for that fit, and a new set of limits based on a target ppk.  Some colleagues have written a script in Matlab to do the same.  Despite all my efforts to optimize my JMP script, the Matlab script is still about 10x faster.   What is the improvement you would like to see?  I would like to see a JSL function that can be run in a script and does not create any report windows.  It would have these inputs: the data for a column as a 1xn matrix, a list of distributions to fit to the data, the preferred ppkmethod to use (score, percentile), target ppk And it would output the following: Name of the distribution with the best fit (minimum AICC) a vector or list of the fit parameters for the best-fit distribution type the ppk, ppkmethod used (zscore or percentile), aicc (nice to have, but not essential) new limits, computed using the target ppk (nice to have, but not essential) Lastly, it should be able to fit these distributions: Beta, Exponential, Gamma, Johnson, Lognormal, Normal, Normal Mixture, SHASH, and Weibull.   Why is this idea important? (1) I want my team to use JMP, but it is nearly impossible to convince them if my script takes 30min to run while the Matlab script does the same thing but takes only 1min.  The reason my script is slower is due to all the overhead of creating a report window for 10k columns.  Instead, it would great if these calculations could be done with a function that can skip report generation and just provide the results I need.  I believe this would be much faster, as well as easier to code. (2) We must be able to analyze datasets >10k columns.  I've noticed that my script just stops in the middle of execution when I try to run it with 12000 columns.  I have not identified the root cause yet, but it works fine for 3600 columns or less.  I suspect there may be a limitation in the report window generation causing an error.     Other things I've tried 1. Both the Fit Censored() and Fit Transform to Normal() functions are similar to the function I'm requesting, in that they both can be used to get the fit parameters.  They do not compute ppk or new limits, but I can use the fit parameters to  compute ppk and new limits myself.  However, these functions do support only a subset of distributions I would like to have.   2.  I'm currently exploring writing something in Python and incorporating that into my existing script, replacing the usage of the Distribution and Process Capability platforms.  This will take me a lot of time though.   Unfortunately the scripts to reproduce my problem are rather long.  I will provide on request, but hopefully my explanation of the problem above is sufficient.   My Specifics: JMP Pro 17.2.0 MacOS Ventura 13.6.1   ... View more

What inspired this wish list request?      Desirability is a highly effective concept for making a multi-criteria choice. For the moment, JMP only allows this concept to be used on the basis of a model. It would be very useful to be able to use it on a finite list of options (e.g. finding the best possible flat to rent from a list of offers).   What is the improvement you would like to see?    the manage limits tool allows you to manage specs limits efficiently. It would be very useful if it could also manage responses limits. Ideally, it should also be able to save the desirabilities one by one as well as the overall desirability.       Why is this idea important?    Stephane George (JMP system engineer) created a script for that purpose. Its addin meets the need perfectly well.     ... View more

What inspired this wish list request?  To my knowledge to change the FONT size for the legend in a graph (for example using Bivariate platform) the user changes the Heading Fonts size in the Files>Preferences>Fonts GUI. However, this also changes the font size in the data table for the column headings.    What is the improvement you would like to see?  Add an option to File > Preferences > Fonts GUI to enable user to customize the font size for a graph and this option would not change the data table column heading font size. Perhaps there is also a way to jsl script the customization of the graph legend font size, but I've not figured out a way to that so far.    Why is this idea important?  For presentations and graph readability a large legend font size of ~18 or larger is used. However, this makes data column headers large and makes the data table more difficult to work with and can make column headings become only partially veiwable in certain GUI windows, or sub windows with a GUI. User then needs to stretch the window to be able to read the full column name. Unfortunately, sometimes column names get long in attempt to fully describe the given column's content details.   ... View more

What inspired this wish list request? We produce extensive excel datatables with data. some of that data is trended in excel, and other is used specifically for analysis. For this we only use a few columns.     What is the improvement you would like to see? Exclude option on the JMP import wizard to ommit or delete columns from the final JMP datatable. OR, an "select columns to import" function     Why is this idea important? it is not critical since the columns can be deleted later or selected in excel and then use the excel add-in to import. It would make the work more intuitive and streamlined. I also noticed that the "datatable" JMP add-in in excel does not record to Workflow builder. So if I wanted to create a script for deleting columns, I would do it by selecting by hand since it is not possible to use the excel add in.     ... View more

What inspired this wish list request?  There is lacking documentation on how to use this feature.   What is the improvement you would like to see?  I would like the full documentation of "add rows" to be added to Scripting Index. This is the "add rows" function that is used in JMP JSL like: dt << add rows(1); I would like to know how to add rows to the end of the data table.   Why is this idea important?  All users need to have documentation of features to use JMP effectively.   ... View more

Would be nice to have a JSL option to open/close table script groups (as we can with an outline box) Would be nice to allow table script groups with only one member. Sometimes these are created dynamically and we cannot anticipate if a group of table scripts will have one or more than one members ... View more

What inspired this wish list request?  I am trying to round some columns based on the number of decimals places in another column.    What is the improvement you would like to see?  I would like to see a Number of Decimals counter   Why is this idea important?  Other scripting languages have this function available. It is important to the situation to automatically round decimals to minimize human error when rounding values to put into tables in Word.   I have to use the Mod function within If() which does not account for all possibilities for rounding.    dt3 << New Column("EAC", Numeric, "Continuous", Formula(If(:Delta > k_EAC_value, Round(k_EAC_value*:StdDev, if( or(mod(:LSL, 1) < 1, mod(:USL, 1) < 1), 1, 0) ) ) ) );   ... View more