nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

86240_en-US

liliconcom

Re: Graph Builder. Show Standardized column with exclusions and grouping

Col Standardize seems not to support optional by arguments. And the Col Stat() functions generally ignore row states.

Try this:

Names Default To Here(1); dt = Open("$SAMPLE_DATA\Big Class.jmp"); dt << Graph Builder( Size(528, 448), Show Control Panel(0), Variables( X(:age), Y(:height), Y( Transform Column( "Standardize[height]", Formula((:height - Col Mean(:height, :age, Excluded(Row State()))) / Col Std Dev(:height, :age, Excluded(Row State()))) ) ) ) );

Re: Graph Builder. Show Standardized column with exclusions and grouping

Brilliant mate. This is exactly what I want.

Re: Graph Builder. Show Standardized column with exclusions and grouping

Great to see another way to combine the row state excluded within a formula. Thanks ms.

Graph Builder. Show Standardized column with exclusions and grouping

I'm trying to show a standardized value that is standardized for each X using graph builder. I would also like it to update on exclusions (recalc the mean and stdDev). The problem with this script is that it doesn't do either. I could make two charts using a summary table but even then, summary tables don't update on exclusion.

Names default to here(1); dt = open("$SAMPLE_DATA\Big Class.jmp"); dt << Select Where(:height < 60) << exclude(1); dt << Clear select; dt << Graph Builder( Size( 528, 448 ), Show Control Panel( 0 ), Variables( X( :age ), Y( :height ), Y( Transform Column( "Standardize[height]", Formula( Col Standardize( :height ) ) ) ) ), );