422442_en-US

liliconcom

Tabulate specific values from column

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?

 

Data TableGraphicsOtherScriptingRe: Tabulate specific values from column

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

1. Create the Tabulate as you have above
2. Make the Tabulate display into a data table.  Go to the red triangle and select "Make into Data Table"
3. In the new table, select the rows for Alaska, America West and American.
4. Subset the data table using   Tables=>Subset  and keep only the selected rows
5. 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 ) )
 )
);