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

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

Thierry_S — Sat, 10 Jun 2023 20:51:48 GMT

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,

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

Mark_Bailey — Wed, 03 Aug 2022 17:39:34 GMT

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

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

ih — Wed, 03 Aug 2022 19:55:38 GMT

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:

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 )
		)
);

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

hogi — Thu, 04 Aug 2022 17:57:05 GMT

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?

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

hogi — Wed, 23 Nov 2022 12:29:43 GMT

@Jonas_Rinne

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

hogi — Fri, 15 Sep 2023 12:36:32 GMT

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:

and not

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(

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

hogi — Sat, 22 Jun 2024 20:08:56 GMT

@Mark_Bailey wrote:
I do not see why not after reading the on-line help starting here.

Besides adding new custom functions ....
Is there a functionality to add existing functions?

e.g.: can I add "is missing" to the new formula column menu?

The target: via right click menu generate a column

New Column( "missing(name)",	Formula( Is Missing( :name ) ))

up to now I just managed to generate a column

New Column( "my is missing[name]",	Formula( hogi:my is missing( :name ) ))

[same functionality, but less useful]

via

Add Custom Functions(
	New Custom Function(
		"hogi",
		"my is missing",
		Function( {col},is missing(col)	), 
		<<Transform Category( "hogi" ),
		<<Description( "is missing for the new column formula menu" )
	)
);

So, with other words, is there are transform category functionality outside of the context of new custom functions?

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

hogi — Mon, 08 Jul 2024 16:16:20 GMT

JMP Support: TS-00152405

Existing functions cannot be added to the menu by name. You will need to create a custom function that utilizes the existing function as you have already done.