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/528641 https://community.jmp.com/t5/Discussions/Color-Cells-based-on-formula-result-and-display-using-tabulate/td-p/56954 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 (?): 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
... View more