Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- How would you improve the Formula Editor?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

How would you improve the Formula Editor?

Feb 10, 2016 6:29 AM
(5324 views)

We're working on some improvements to the Formula Editor and we want your input.

What do you like about the Formula Editor and wouldn't want to see changed?

What bothers you?

What parts do you use most often?

What confused you the first time you used it?

What would make it more efficient?

How often do you double-click the formula and type the formula by hand?

We want your feedback regardless of how long you've used JMP. Whether you're a first-time user or longtime JMP jockey, your opinion is valuable.

Post your replies here. Please be as detailed as possible.

Thanks!

-Jeff

-Jeff

49 REPLIES 49

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How would you improve the Formula Editor?

Feb 10, 2016 7:12 AM
(3682 views)
| Posted in reply to message from Jeff_Perkinson 02/10/2016 09:29 AM

Some of my formulas are too complex, so I double-click on the window and type the formula in by hand. Initially the window we're given to enter a formula in is too small, and the font is too small as well. (Must be getting old). I would suggest making it bigger.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How would you improve the Formula Editor?

Feb 10, 2016 7:28 AM
(3682 views)
| Posted in reply to message from Jeff_Perkinson 02/10/2016 09:29 AM

some tables have a long list of variables. it would be nice to have the Filter Col Selector in hand when generating a formula. This feature is available in the distribution and the fit Y by X platform and is very useful.

By the way, it would be good to add it to the fit model platform and actually any platform.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How would you improve the Formula Editor?

Feb 10, 2016 7:45 AM
(3682 views)
| Posted in reply to message from Jeff_Perkinson 02/10/2016 09:29 AM

add in an autofill for the column or function names. it can be a pain to keep scrolling to find the right column, and typing it can be tough if you forget how it is spelled. It would be nice if there was a feature that would autofill the possible columns or functions based on what you typed. Sort of like what Google does with autofilling a search, except the only possibilities are the column headings or function names.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How would you improve the Formula Editor?

Feb 10, 2016 9:12 AM
(3682 views)
| Posted in reply to message from Jeff_Perkinson 02/10/2016 09:29 AM

Using Parameter() in formula editor for nonlinear modeling.

If you try to edit parameters by hand after the formula has been made, you have to go to parameters and right click->edit. A single left click will replace your whole formula with just that parameter. Not the end of the world to press ctrl+Z, just a minor annoyance.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How would you improve the Formula Editor?

Feb 10, 2016 12:43 PM
(3682 views)
| Posted in reply to message from Jeff_Perkinson 02/10/2016 09:29 AM

It would be nice if when you double click on the formula to go into editor mode, that a small jsl window, with all of it's functionality popup.

There needs to be a way to access all of the elements of a function without having to go into the editor mode. An example of this is the Worrd() function. The delimiter element has to be manually added.

when selecting a function, there should be a button beside each function that when clicked goes directly to the Scripting Index help for that function

There needs to be more space between the elements in the picture version of the formula, so that selecting of the different elements within the formula isn't sooooooo difficult

translator from Excel functions to jmp functions.

I use the manual editor a lot

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How would you improve the Formula Editor?

Building on Jim's thoughts - how about if the JSL editor does more auto-completion of built-in functions, like you get in Visual Studio or when entering an Excel formula?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How would you improve the Formula Editor?

I was thinking something very similar Jim! Sometimes formula get complex and messy in the formula editor. I often write a script in these cases because it is just easier for me to see what I am doing.

Maybe you could call formula editor formula builder (like the other interactive builders -sql, graph) and have an entirely different option for formula script

Jason Wiggins

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How would you improve the Formula Editor?

Feb 11, 2016 6:28 AM
(3682 views)
| Posted in reply to message from Jeff_Perkinson 02/10/2016 09:29 AM

When building long and complex formulas (with 2000+ terms), I start with multiple intermediate columns with formulas. In this case it would be extremely helpful to do a wholesale replace of the column reference with the formula in that column in the formula editor window. In other words, I am suggesting you give the ability to collapse sequential formula columns into a single column.

I often use the feature of copy and pasting formulas between a script window and the formula editor.

Laura

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How would you improve the Formula Editor?

Feb 11, 2016 7:51 AM
(3682 views)
| Posted in reply to message from Jeff_Perkinson 02/10/2016 09:29 AM

**Please please please** add the Robust Mean and Robust Standard Deviation functions to the Formula Editor and to available JSL functions!