topic Re: Tabulate - change format? in Discussions

Tabulate - change format?

hogi — Fri, 28 Jul 2023 19:50:19 GMT

Tabulate is great to generate an overview table with a few mouse clicks.

How can I change the format of a tabulate report in my Dashboard?

rotate column titles -> vertical
reduce font size
change column titles - esp: split a column title into two lines
(unfortunately, tabulate ignores line breaks in the column names)
change entries (replace text)
make grouping entries selectable (for copy & paste)
add a String Col Edit Box as an additional column
convert to a table box

Re: Tabulate - change format?

hogi — Sat, 29 Jul 2023 20:54:45 GMT

@hogi wrote:
unfortunately, tabulate ignores line breaks in the column names

same for Tables/Split which ignores everything including/after the first line break:

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

: sex << set name("1st line \!n 2nd line");

Data Table( "Big Class" ) << Stack(
	columns( :name, :"1st line 
 2nd line"n )
);