...
Overview
The Advanced Table Viewer macro allows
| Status | ||||
|---|---|---|---|---|
|
| Note | ||||||
|---|---|---|---|---|---|---|
Beta release notice: The Advanced Table Viewer
While we strive to deliver a seamless experience, some features are subject to change, and minor issues can arise. We encourage you to explore the macro and share your feedback to help us improve the final release. Thank you for your support and understanding! |
...
What’s in the beta release?
The macro currently supports importing data only from the CSV files.The macro offers data connector.
We have included a simplified version of the two formatting features, Sorting and Sum-up row formatting options.
Future enhancements:
...
Future releases will support additional data sources, such as JSON and Excel. (need inputs on what other data sources will be supported)
...
Beta limitations:
The Sum-up option in beta provides only sum and average calculation and is applicable only for columns with numeric data.
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.
Watch the Video for a quick overview of the Advanced Table Viewer macro
...
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 | Markup Advanced Table Viewer  |
|---|---|
Markup shortcut (Old editor) | {Advanced Table Viewer} To be done |
 | |
Macro shortcut (New editor) | /Advanced Table Viewer   |
Configure the macro
Insert the macro and select the data connector. By default, CSV is selected.
...
To learn more about the Advanced Table Viewer macro, click Help.
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.
To clear all the selected column names, click Clear All (
)in the drop-down. 
To remove any specific column name from the list, next to the column name, click
.After clearing selections, to select the column names again, click the drop-down and select the column names again in the required order.
Click
...
Save to import the data. The table with the selected column names and values will appear on the Confluence page.
...
With these simple steps, your data is now ready for collaborative use and enhanced analysis directly within Confluence.
...
When you save the macro on a Confluence page without configuration, it displays a welcome note.
Macro features
The Advanced Table Viewer
| Status | ||||
|---|---|---|---|---|
|
The Beta release offers a simplified version of the Sorting and Sum-up row optionsfeatures:
Sorting: Sort the 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 [Beta].
Sum-up row: Automatically : Include the summarize option to automatically calculate and display the total 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 [Beta].