topic Re: User Input Tabulate Column in Discussions

User Input Tabulate Column

UserID16644 — Sun, 11 Jun 2023 11:22:44 GMT

Is it possible to have a user-based column when tabulating data? I have a tabulated table but the grouping columns need to be based on the user input. I can't think of ways to do it, is it possible? pls help

Re: User Input Tabulate Column

txnelson — Wed, 16 Mar 2022 04:36:17 GMT

JMP has the functionality to request user input and then pass that information into whatever scripting is required. I recommend that you take the time to read through the Scripting Guide.

Here is a very simple example to do what you want. Far better interfaces can be developed, but this should give you a start

Names Default To Here( 1 );
// Open Data Table: big class.jmp
// → Data Table( "big class" )
dt = Open( "$SAMPLE_DATA/big class.jmp" );

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
nw = New Window( "Col List Box Example",
	Text Box( "Select the Grouping Columns" ),
	Col List Box( all, width( 250 ), maxSelected( 1 ) ),
	fontobj = lb = Col List Box( character ),
	OKbb = Button Box( "OK",
		theColumns = lb << get items;
		nw << close window;

		Tabulate(
			Show Control Panel( 0 ),
			Add Table(
				Column Table( Analysis Columns( :height, :weight ), Statistics( Mean ) ),
				Row Table( Grouping Columns( eval(theColumns) ) )
			)
		);
	)
);

Re: User Input Tabulate Column

UserID16644 — Wed, 16 Mar 2022 05:59:12 GMT

Not sure if it's my JMP Version (JMP15) but it's not working for me

Re: User Input Tabulate Column

txnelson — Wed, 16 Mar 2022 06:05:48 GMT

It works fine under JMP 15, running Windows 10.

Here is the first screen

I then select columns Name and Age and move them into the selection area

Finally I click on OK and get the following results

Re: User Input Tabulate Column

UserID16644 — Wed, 16 Mar 2022 08:31:57 GMT

Worked well. Thanks!