cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

New Formula column - new entry: draft function

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

4 Comments
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 XII

@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

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 

 

Status changed to: Delivered

Hey @shampton82, thank you for the feedback! I have already passed that feedback on to the developer, but I am going to mark this wish as delivered. If you want to be sure to be notified of any updates on your suggestion, I would create a new wish list item for that so we can update the status if anything changes.