662839_en-US

liliconcom

Tabulate - change format?

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

Data Blending and CleanupData Exploration and VisualizationRe: Tabulate - change format?

---

@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 )
);