topic Re: Tabulate specific values from column in Discussions

Tabulate specific values from column

29755 — Sun, 11 Jun 2023 11:17:51 GMT

Hi all,

I have this Air Traffic.jmp file as my example, so what I wanted to do is to tabulate the data with only the specified values needed but it need to retain its original Column % value.

I tried selecting the needed values then subset into another table but ends up having 100 Column % value. I also tried hiding and excluding but also got 100 Column % value.

In my attached file, my needed values for tabulating are Alaska, America West and American only.

Is there any ways to do this?

Re: Tabulate specific values from column

txnelson — Thu, 30 Sep 2021 11:28:55 GMT

You will need to run Tabulate twice, and subset the desired airline data between the tabulates

Create the Tabulate as you have above
Make the Tabulate display into a data table. Go to the red triangle and select "Make into Data Table"
In the new table, select the rows for Alaska, America West and American.
Subset the data table using Tables=>Subset and keep only the selected rows
On the new data table run the Tabulate platform.
1. Drag the Airline column to the Drop Zone for Rows
2. Drag the Column % column to the N in the Statistic column
3. Right click on the Column % label and select "Remove Column Label"
4. Right click on the Sum label and select "Change Item Label"
5. Change the label to "Column %"

Below is a script that performs the above operations

names default to here(1);

// Open Data Table: Air Traffic.jmp
// → Data Table( "Air Traffic" )
dt = Open( "$SAMPLE_DATA/Air Traffic.jmp" );

tab = dt << Tabulate(
	Add Table(
		Column Table( Statistics( Column % ) ),
		Row Table( Grouping Columns( :Airline ) )
	)
);
dtCalc = tab << make into data table;

dtCalc << select where( :Airline == "Alaska" | :Airline == "America West" | 
	:Airline == "American"
);

dtSub = dtCalc << Subset( selected rows( 1 ), selected columns( 0 ) );

dtSub << Tabulate(
	Remove Column Label( Analysis Columns( Column % ) ),
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Analysis Columns( :Column % ), Statistics( Column % ) ),
		Row Table( Grouping Columns( :Airline ) )
	)
);

Re: Tabulate specific values from column

29755 — Thu, 30 Sep 2021 23:54:41 GMT

Hi txnelson, thank you for your response.

However, is it possible that the Column% values would still be like this?

Re: Tabulate specific values from column

txnelson — Fri, 01 Oct 2021 01:52:59 GMT

My Error or rather JMP's funky interpretation. Because of the way Tabulate works, it uses the specific names to key actions, and by changing the label name to Column %, Tabulate recalculated the value. So if the label is changed to "The Column %" it does not do the recalcuation.

names default to here(1);

// Open Data Table: Air Traffic.jmp
// → Data Table( "Air Traffic" )
dt = Open( "$SAMPLE_DATA/Air Traffic.jmp" );

tab = dt << Tabulate(
	Add Table(
		Column Table( Statistics( Column % ) ),
		Row Table( Grouping Columns( :Airline ) )
	)
);
dtCalc = tab << make into data table;

dtCalc << select where( :Airline == "Alaska" | :Airline == "America West" | 
	:Airline == "American"
);

dtSub = dtCalc << Subset( selected rows( 1 ), selected columns( 0 ) );

dtSub << Tabulate(
	Change Item Label( Statistics( Sum, "The Column %" ) ),
	Remove Column Label( Analysis Columns( Column % ) ),
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Analysis Columns( :Column % ) ),
		Row Table( Grouping Columns( :Airline ) )
	)
);