Skip to end of banner
Go to start of banner

Summarize and format data - 8.x

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Current »

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

  • No labels