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

Is it possible to customize the Add Formula Column menu to include customize functions?

Hi JMP Community,

I want to customize the Add Formula Column menu with a few functions I frequently use. Is this menu modifiable, and if it is, what is the correct method to do so?

Thank you.

Best,

TS

Thierry R. Sornasse
2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: Is it possible to customize the Add Formula Column menu to include customize functions?

I do not see why not after reading the on-line help starting here.

View solution in original post

ih
Super User (Alumni) ih
Super User (Alumni)

Re: Is it possible to customize the Add Formula Column menu to include customize functions?

I am blind, it is right there under Custom Transform.  Thanks!

 

@Thierry_S are you referring to the menu presented when right clicking on a column header? If so I don't know of a way to do that, @Mark_Bailey if it is in that reference I must be blind because I am missing it!

 

This is the menu I think @Thierry_S refers to:

ih_0-1659556335928.png

Example from help:

Add Custom Functions(
	New Custom Function(
		"custom", 	// namespace in which new function resides
		"x1000", 	/* function name. The completely scoped name is
			"custom:x1000".*/
 
		Function( {x}, x * 1000 ),// function definition
 
// optional message to enables this as a custom transform

		<<Transform Category( 1 )
		)
);
 

ih_2-1659556522856.png

 

View solution in original post

5 REPLIES 5

Re: Is it possible to customize the Add Formula Column menu to include customize functions?

I do not see why not after reading the on-line help starting here.

ih
Super User (Alumni) ih
Super User (Alumni)

Re: Is it possible to customize the Add Formula Column menu to include customize functions?

I am blind, it is right there under Custom Transform.  Thanks!

 

@Thierry_S are you referring to the menu presented when right clicking on a column header? If so I don't know of a way to do that, @Mark_Bailey if it is in that reference I must be blind because I am missing it!

 

This is the menu I think @Thierry_S refers to:

ih_0-1659556335928.png

Example from help:

Add Custom Functions(
	New Custom Function(
		"custom", 	// namespace in which new function resides
		"x1000", 	/* function name. The completely scoped name is
			"custom:x1000".*/
 
		Function( {x}, x * 1000 ),// function definition
 
// optional message to enables this as a custom transform

		<<Transform Category( 1 )
		)
);
 

ih_2-1659556522856.png

 

hogi
Level XI

Re: Is it possible to customize the Add Formula Column menu to include customize functions?

When I define a custom function, is  it possible to access the columns that were previously selected by NewFormulaColumn/GroupBy and use them as well as group by entries?

hogi
Level XI

Re: Is it possible to customize the Add Formula Column menu to include customize functions?

hogi
Level XI

Re: Is it possible to customize the Add Formula Column menu to include customize functions?

One one hand, it's very cool that 

Add Custom Functions(
	New Custom Function(
		"custom", 	// namespace in which new function resides
		"x1000", 	/* function name. The completely scoped name is
			"custom:x1000".*/
 
		Function( {x}, x * 1000 ),// function definition
 
// optional message to enables this as a custom transform

		<<Transform Category( 1 )
		)
);

puts MY OWN formula into jmp and that it really shows up in the Formula editor:

hogi_0-1694781137991.png

 

 and not 

hogi_1-1694781166921.png

 

But actually, I would prefer the latter one.
Next time Jmp is started, the new function will be gone. Same for the computer of my colleague or the computer of the person @ Jmp support.

 

Is there a way to get a command into the New formula Column right click menu which produces a column with the second formula?
e.g. via an additional argument forAdd Custom Functions( or New Custom Function(