Table summary - Subgroups

hogi

The Subgroup option in Table/Summary is cool to get separate statistics for subgroups of the selected groups.

 

When several columns are selected as subgroups, all possible combinations show up in an hierarchical list.

For the example below, every single day of the week X every single day of the month gets a subgroup, ending up with 7 * 31 = 271 subgroups (dom, dow)

 

Is there an option to tell Table/Summary that subgroups should not be hierarchical/intersected, but just put next to each other?
Or do I have to generate the summary tables separately and join them later to get such a summary?

 

 

Open( "$SAMPLE_DATA/Airline Delays.jmp" );


Data Table( "Airline Delays" ) << Summary(
	Group( :Airline ),
	N,
	Subgroup( :Day of Week, :Day of Month  ),
	Freq( "None" ),
	Weight( "None" )
);

 

txnelson

Yes you would have to run separage Summary Platforms and then Join them together to get what you want, or you  could run a Tabulate Platform and get what you want in one step.

Names Default To Here( 1 );
dt = New Table( "year/day",
	add rows( 200 ),
	New Column( "Airline",
		character,
		set each value(
			aList = {"Delta", "Northwest"};
			aList[Random Integer( 1, 2 )];
		)
	),
	New Column( "day",
		character,
		set each value(
			dList = {"Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"};
			dList[Random Integer( 1, 7 )];
		)
	),
	New Column( "n", ordinal, set each value( Random Integer( 1, 12 ) ) )
);

tab =Tabulate(
	Add Table(
		Column Table( Grouping Columns( :day ) ),
		Column Table( Grouping Columns( :n ) ),
		Row Table( Grouping Columns( :Airline ) )
	)
);
tab<<make into data table;