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 name | Table 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 column | On |
| Column settings > Numbering & Totaling > Auto total numeric columns | On |
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
- Visit our full list of product examples for additional inspiration!
Log a request with our support team.
Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.