cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Tabulate: Color Dopzone

What inspired this wish list request? 

Graph Builder has a DropZone to automatically adjust the color of Data Points, Bar charts, Heat Maps etc.

Whenever several rows of the data table are combined to produce one data point, bar, heatmap cell ... , the respective colors are blended. Very cool!

 

Unfortunately, Tabulate doesn't have a Color Dropzone:
https://community.jmp.com/t5/Discussions/Color-Tabulate-report-based-on-other-column-value/td-p/5286... 

https://community.jmp.com/t5/Discussions/Color-Cells-based-on-formula-result-and-display-using-tabul... 

 

 

What is the improvement you would like to see? 

and let Tabulate automatically adjust the background color of rows.

If several rows of the data table are combined to produce one row in Tabulate, the respective colors should be blended.

Like in Graph Builder, please add a function to adjust the transparency.

 

 

Why is this idea important? 

Just imagine how useful Tabulate could be with the new function

- for hierarchical groups, the main label could be used as color to give the table some structure

- a column could be used as color which is not directly used for Tabulate - to highlight some rows.

 

v18 (?):

hogi_0-1688669615641.png   hogi_1-1688669757176.png

 

 

Tabulate without colors (v17.1):

 

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Tabulate(
	Show Control Panel( 0 ),
	Add Table(
		Column Table(
			Analysis Columns( :height, :weight ),
			Statistics( Mean )
		),
		Row Table( Grouping Columns( :sex, :name ) )
	)
)

 

 

 

 

more wishes submitted by  hogi_2-1702196401638.png

3 Comments
hogi
Level XII

Besides such a 1-color-per-row approach, another idea (triggered by @bdr_jmp_team 
conditional formatting based on the individual values -- like Excel can do , or the process screening platform:

hogi_0-1709846209267.png

 

 

hogi
Level XII
Status changed to: Acknowledged