Summarize and format data - 8.x

Overview

All the featured macros of Advanced Tables for Confluence offer many formatting options such as applying date formats, setting languages, performing calculations on numeric columns and many more. This section explains how to leverage these table formatting options for a better readability. 

Consider Monthly temperatures table, for which you want to perform 'Max', 'Min' and 'Average' operation on the columns and set background colors.

Select this macro

Macro nameTable Plus
Macro syntax{table-plus}

Define these parameters/values

Column settings > Formatting > Column Styles (1

2

3

4)

background:lightgrey

background:lightblue

background:lightyellow

background:lightblue

Column settings > Formatting > Column type (1

2

3

4)

String (S)

Numeric and float values (F)

Numeric and float values (F)

Numeric and float values (F)

Column settings > Formatting >  Total type (1

2

3

4)

Max Min Avg

Max

Min

Average

Column settings > Numbering & Totaling > Insert auto number columnOn
Column settings > Numbering & Totaling > Auto total numeric columnsOn

Screenshot

Example result

The same configurations, as shown above, can be set up for Advanced Tables for Confluence - CSV Table, JSON Table, JQL Table, and Attachment Table macros.

Other examples