topic Re: GraphBuilder Plot: Labels? in Discussions

GraphBuilder Plot: Labels?

hogi — Thu, 02 Nov 2023 22:23:00 GMT

Hi, I know how to enable Labels for Heatmaps:the labels are nicely aligned with the heatmap cells and the values correspond to the column values which are used as color.

I also know how to enable labels for point plots - where the labels can be chosen independent of the "color" column:

Is it possible to combine both approaches:
Heatmap labels, where a column is used as labels which is NOT THE SAME as the column used for color?

Application case:
use a meaningful, normalized value as color [e.g. mortality rate] - but show the actual counts [e.g. Covid 19 victims] as labels.

Add-on question: is it possible to use Character Labels?

e.g. a combination of

and

... something like:

so, similar to adding point labels to a heatmap plot, but with the text nicely confined to the heatmap cells?

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt  << New Formula Column(
	Operation( Category( "Distributional" ), "Rank" ),
	Columns( :height ),
	Group By( :age, :sex )
);


dtsplit = dt << Split(
	Split By( :"Rank[height][age,sex]"n ),
	Split( :name ),
	Group( :age, :sex ),
	Remaining Columns( Drop All )
);

dtCombine = dtsplit << Combine Columns(
	columns( :"1"n, :"2"n, :"3"n, :"4"n, :"5"n, :"6"n, :"7"n ),
	Column Name( "Students" ),
	Delimiter( "," )
);

New Column( "N_students",
	Formula( N Items( Words( :Students, "," ) ) )
);

Graph Builder(
	Variables( Y( :age ), Group X( :sex ), Color( :N_students ) ),
	Elements( Heatmap( Y ) )
);

dtCombine << Split(
	Split By( :sex ),
	Split( :Students ),
	Group( :age ),
	Remaining Columns( Drop All )
)

Re: GraphBuilder Plot: Labels?

BHarris — Tue, 14 Nov 2023 18:59:39 GMT

I was about to request this -- we would use this *all the time*.

[update -- Jarmo showed that JMP already does this -- kudos!]

Re: GraphBuilder Plot: Labels?

jthi — Fri, 03 Nov 2023 18:14:52 GMT

Set column as label and label by row?

Re: GraphBuilder Plot: Labels?

hogi — Fri, 03 Nov 2023 18:30:38 GMT

With some cheating (manually adding some linebreaks in the table), the best I can offer at the moment:
a combination of heatmap and points.
... unfortunately with the labels placed somehow arbitrarily

There is an entry in the wish list to solve such issues, but unfortunately it got archived :(

dtSplit << Graph Builder(
	Variables( Y( :age ), Group X( :sex ), Color( :N_students ) ),
	Elements(
		Heatmap( Y, Legend( 1 ) ),
		Points( Y, Color( 0 ), Legend( 2 ) )
	),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				2,
				Properties( 0, {Marker Size( 0 )}, Item ID( "age", 1 ) )
			)}
		)
	)
)

Re: GraphBuilder Plot: Labels?

hogi — Fri, 03 Nov 2023 18:38:13 GMT

What a wonderful day - it's already there :)

Quite hidden feature!
The labels don't change when rows or columns get added as labels,

The labels just update when the user switches back and forth the label setting.

Re: GraphBuilder Plot: Labels?

hogi — Fri, 03 Nov 2023 20:27:55 GMT

So, actually

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
:name << Label( 1 );
Graph Builder(
	Variables( X( :sex ), Y( :age ) ),
	Elements( Heatmap( X, Y, Label( "Label by Row" ) ) )
)

... will do the job.

Is there a setting to get the entries separated by newlines instead of semicolons?

Re: GraphBuilder Plot: Labels?

jthi — Fri, 03 Nov 2023 21:01:22 GMT

Use the earlier script you did use and use \!N as separator

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Formula Column(Operation(Category("Distributional"), "Rank"), Columns(:height), Group By(:age, :sex));


dtsplit = dt << Split(Split By(:"Rank[height][age,sex]"n), Split(:name), Group(:age, :sex), Remaining Columns(Drop All));

dtsplit << Combine Columns(columns(:"1"n, :"2"n, :"3"n, :"4"n, :"5"n, :"6"n, :"7"n), Column Name("Students"), Delimiter("\!N"));
//dtCombine << get name;

dtsplit << New Column("N_students", Formula(N Items(Words(:Students, "\!N"))));
Column(dtsplit, "Students") << Label(1);

gb = dtsplit << Graph Builder(
	Variables(Y(:age), Group X(:sex), Color(:N_students)),
	Elements(Heatmap(Y, Legend(1), Label("Label by Row")))
);

Re: GraphBuilder Plot: Labels?

hogi — Sat, 04 Nov 2023 08:40:31 GMT

1:0 for JSL vs. GUI :)

Delimiter("\!N")