cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to move from signal modeling to system modeling at the first JMP Aerospace Analytics webinar. Register. June 18, 1 p.m. US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
hogi
Level XIII

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
1 REPLY 1
hogi
Level XIII

Re: 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 )
);

Recommended Articles