Tabulate specific values from column

Question

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?

txnelson · Answer

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

29755 · Answer

Hi txnelson, thank you for your response.

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

txnelson · Answer

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.* Drag the Airline column to the Drop Zone for Rows
* Drag the Column % column to the N  in the Statistic column
* Right click on the Column % label and select   "Remove Column Label"
* Right click on the Sum label and select  "Change Item Label"
* 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 ) )
	)
);