...
...
...
...
Overview
The Advanced Table Viewer macro allows you to import, format, and display data from various data sources in a table format using predefined profiles.
...
The Sum-up option in Beta provides only sum and average calculation and is applicable only for columns with numeric data.
To be done (let me know if we want to include anything else here)
Future enhancements:
Future releases will support additional data sources, such as JSON. (need inputs on what other data sources will be supported)
The macro will support more advanced options to interact with your data, such as text filtering, searching in the table, exporting, and more.
Pre-requisite: Profiles and configuration
✅ The Advanced Table Viewer macro imports data from data sources using profiles. It currently supports the CSV data connector.
✅ Make sure you have access to the required profiles, or contact your Administrator to define them. To configure profiles, refer to Configuration-Cloud.
Macro basic use
Insert the macro
You can add the macro to a Confluence page using one of the following methods:
Select from the macro browser | Advanced Table Viewer  |
|---|---|
Markup shortcut (Old editor) | {Advanced Table Viewer} |
Markup shortcut (New editor) | /Advanced Table Viewer  |
Configure the macro
Insert the macro and select the data connector. By default, CSV is selected.
The Select a Profile drop-down macro displays the list of profiles. Select the profile from which you want to import the data as a Confluence table.
The Select Columns drop-down displays the list of column names to output in the table.
You can select, remove, and order the column names as needed. The selected order of the column names is displayed in the confluence table.
...
When you insert the macro on a Confluence page without configuration, it displays a welcome note.
Macro features
The Advanced Table Viewer macro offers quick formatting options when viewing tables on the Confluence page. You can work with the data and create customizable views.
...
Sorting: Sort table data by clicking on column headers to switch between ascending and descending order. For more information, refer to Sorting with Advanced Table Viewer macro.
Sum-up row: Automatically calculate and display the sum (SUM) or average (AVG) for columns containing only numeric data. For more information, refer to Summarize numeric column values with Advanced Table Viewer macro.