This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

New Formula column - new entry: draft function

Status: Acknowledged Submitted by on ‎01-13-2023 03:09 AM
3 Comments (3 New)

What inspired this wish list request? 

The New Formula column submenu in the column right click context menu is very useful to quickly generate new formula columns.

But the user is somehow "lost" if the desired function is not available or if he want to generate a special function.
Then he has to generate a new column, and add a formula manually manually.
hogi_2-1673596465221.png

 
No big issue ...
But let's look at the Filter Col Selector right click context menu, e.g. by right clicking on a column entry in the Summarize Dialog.
There is an additional entry: Formula ...
which allows the user to create a "draft" new formula column, just starting with the identity formula and waiting for further user input.
 hogi_3-1673596623486.png

 

What is the improvement you would like to see? 
Add such a Formula ... entry also to the New Formula Column submenu of the column right click context menu.

The new column should be called orignalColumn 2
- Transform[originalColumn] (like in the Filter Col Selector) is too long

 

Why is this idea important?

It gets much easier to generate a new formula column.

The identity function is an ideal starting point.

 

 

 

 

more wishes submitted by  hogi_2-1702196401638.png

3 Comments
Sarah-Sylvestre
Staff
Staff
‎02-09-2023 05:14 PM
‎02-09-2023 05:14 PM
Status changed to: Acknowledged

Thank you for submitting this wish @hogi! Your feedback is critical in helping us make JMP even better, and we are grateful you took the time to share your ideas. Your request has been documented and will be prioritized. 

hogi
Level XI
2 weeks ago
2 weeks ago

@Sarah-Sylvestre , thanks for delivering :

hogi_0-1719474316942.png


... and much more powerful than I imagined - even with Replace function!

hogi_1-1719474362751.png

 

shampton82
Level VII
2 weeks ago
2 weeks ago

Morning @Sarah-Sylvestre !  This is a great add but has a weird behavior in that it places the new column at the end of the data table vs next to the column you are referencing (like all the other functions do).  If I wanted to ask that the new functionality places the column next to the reference column or adds an option where the user can choose where to place the column (like next to this toolbar)

shampton82_0-1719497863740.png

can that request live here or should I put in a new wish list item for it?

 

Thanks for any guidance!

 

FYI for @hogi