topic Pareto Analysis - generate table in Discussions

Pareto Analysis - generate table

hogi — Thu, 19 Oct 2023 18:12:16 GMT

What is the fastest/easiest way to generate a table with he information that I get via % of total in Graph Builder?

Unfortunately, % of total in Summary and Tabulate take all rows of the table as a references.

But I need a separate analysis for each group - like in Graph Builder or in Pareto.

Per Unit Rates in Pareto gives the correct list - but unfortunately, it's into 2 DisplayBoxes.

As this is a very common task, I guess there is a direct way to generate such a list, but I couldn't find it ....

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << Pareto Plot(
	Cause( :age ),
	X( :sex ),
	Percent Scale( 1 ),
	Show cumulative Percent Curve( 0 ),
	Per Unit Rates( 1 )
);

dt << Graph Builder(
	Variables( X( :age ), Group X( :sex ) ),
	Elements(
		Bar( X, Summary Statistic( "% of  Total" ) )
	)
);

dt  << Summary(
	Group( :sex ),
	"% of Total"n( :sex ),
	Subgroup( :age )
);

dt << Tabulate(
	Add Table(
		Column Table( Grouping Columns( :age ), Statistics( "% of Total"n ) ),
		Row Table( Grouping Columns( :sex ) )
	)
)

Re: Pareto Analysis - generate table

jthi — Thu, 19 Oct 2023 18:21:29 GMT

Tabulate most likely

Re: Pareto Analysis - generate table

jthi — Thu, 19 Oct 2023 18:22:30 GMT

Or distribution

Re: Pareto Analysis - generate table

hogi — Thu, 19 Oct 2023 18:32:17 GMT

@jthi wrote:
Tabulate most likely

Nice, thanks.

On a discovery summit there was a discussion about the pros and cons of Analyze/Tabulate and Tables/Summary.

So, + 1 Point for Tabulate.

It's interesting that the functionality is so "distributed" over the Platforms.
I would expect that each platform provides all possibilities and that the user can choose the platform by some personal preferences.

Distribution has the same issue as Pareto: Result is split over several Display Boxes.

-> I will stick to Tabulate.