The Table Excerpt and Table Excerpt Include macros were designed to improve the performance and response of pages storing large tables. You can work with the original table without creating multiple copies of it for filtering and building several pivot tables or charts on its basis. You can use the macros both within one page and within several pages of your Confluence instance. |
The macros are available in Confluence Server only. There are two facts that you should know about Table Excerpt and Table Excerpt Include macros:
The macros do not create a copy of the table. The Table Excerpt macro creates a reference to the source table and the Table Excerpt Include macro inserts the reference into the other macros.
The main objectives of using the macros are:
providing dynamic changing of multiple pivot tables and charts when the source table changing;
avoiding loss of productivity when working with large tables (compared to multiple copies of the table);
Adding the Table Excerpt macro to a page:
You will be able to reference the marked table by inserting the Table Excerpt Include macro (on the same page only) and entering the specified unique name. |
Speeding up macro entry with autocomplete: type { and the beginning of the macro name 'Table Excerpt", to see a list of suggested macros. Select the Table Excerpt macro from the prompted results. |
Adding a Table into the Table Excerpt Macro
Adding the Table Excerpt Include macro to a page and specify the settings:
Speeding up macro entry with autocomplete: type { and the beginning of the macro name 'Table Excerpt Include', to see a list of suggested macros. Select the Table Excerpt Include macro from the prompted results. |
You can use the Table Excerpt Include macro without showing the source table within the Pivot Table macro and the Chart from Table macro because a pivot table and a chart can be built without displaying a source table. On the other hand, if you want to use the Table Excerpt Include macro within the Table Filter macro you should select the "Show copy of source table" checkbox because this macro requires a table for its correct work. |
As the result, you will receive multiple charts generated on the basis of the same data table.