On this page you will learn about:


Inserting the macros

Inserting the macro in the page view modeThe feature is not available in Cloud version

You can disable the inline macro insertion on a global or individual basis.

  1. Open a page with a table.
  2. Hover over the table.
  3. Click the Filter table data or Create a pivot table or Create a chart from data series icon on the panel that appears to the right side of the table.


Inserting the macro through the action icon on the editor paneThe feature is not available in Cloud version

  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer within the table.
  3. On the editor pane, click the Filter table data or Create a pivot table or Create a chart from data series icon.


Manual entry of the {Table Filter} or {Pivot Table} or {Chart from Table} query on the page

  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer in the appropriate place on the page.
  3. Start entering {Table Filter}, {Pivot Table}, {Chart from Table}, {Table Transformer}, {Table Excerpt}, {Table Excerpt Include}, {Table from CSV}.
  4. From the prompted list of macro choices, select the macro.
  5. Place the table within the macro.

In the new Confluence Cloud editor add /Table Filter or /Pivot Table or /Chart from Table or /Table Transformer query on the page. 



Selection of the macros in the Select Macro form

  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer in the appropriate place on the page.
  3. On the editor pane, click Insert more content -> Other macros.
  4. In the Select Macro form, find the macro and insert it on the page.
  5. Place the table within the macro.


Copying a table into the macros The feature is not available in Cloud version

  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer into any cell of the table you want to copy.
  3. Click the Copy Table icon on the editor pane.
  4. Paste the table into the Table Filter / Pivot Table / Chart from Table macro on the same or on a new page.

To copy a table into the macro in Confluence Cloud highlight the table (as shown in the screencast below), copy and paste it into the macro body:




Removing the macros from tables The feature is not available in Cloud version

  1. Switch Confluence page to the edit mode.
  2. Select the Table Filter macro with the table or macro outputting the table.
  3. Click Unwrap.

You can remove all the macros bundled with the app from your pages on the global level.


To remove the macro from the table in Confluence Cloud copy the table and paste it outside the macro body.

Select the macro with the table and click Remove.



Configuring inline macro insertion

On the global level

  1. Navigate to Confluence administration console.
  2. On the sidebar, locate the Table Filter and Charts menu group. Select Configuration.
  3. To enable inline macro insertion globally, check the corresponding box.
  4. Define additional parameters, as follows:
    • Groups - enter the names of user groups who can use the inline macro insertion.
    • Individual users - enter the names of individual users who can use the inline macro insertion.
    • Anonymous - check the box to allow anonymous users to use the inline macro insertion.

To disable inline macro insertion:

  1. Clear the Inline macro insertion box.

To disable inline macro insertion for the group/user:

  1. Click the  icon for a specific user or groupю


On the user's level

To enable inline macro insertion:

  1. In the top-right part of the screen, locate your profile picture and click it.

  2. Select Settings.

  3. On the navigational sidebar, select Table Filter and Charts.

  4. Select the Inline macro insertion option.

To disable inline macro insertion:

  1. Clear the Inline macro insertion option.

This modification will override the global configuration settings for user groups you are associated with.



Removing all the macros from pages The feature is not available in Cloud version

The Table Filter and Charts app allows you to remove all the macros bundled with the app, including the following:

  • Table Filter
  • Pivot Table
  • Chart from Table
  • Table Transformer
  • Table Excerpt
  • Table Excerpt Include

The source data tables and macros outputting table data will not be affected anyhow and will be preserved in your Confluence after completion of the procedure.

To remove all app macros from Confluence pages:

Please perform the full Confluence backup prior to running this procedure. This operation may require some time depending on the size of your Confluence and number of app's macros on your Confluence pages.

  1. Switch to the Add-on Macro Cleanup tab.
  2. Click Clean up.
  3. Confirm the operation.


Hiding inline insertion buttons

Add the following CSS to the global, space stylesheet or a page with the HTML macro to hide inline insertion buttons for the whole instance, for a space or the specific page.

To hide all inline insertion buttons 

.tfac-macro-inserter {
    display: none;
 }

 To hide one of three inline insertion buttons:

Table Filter button

.tfac-macro-inserter .aui-icon.table-filter-inserter {
display: none;
}

Pivot Table button

.tfac-macro-inserter .aui-icon.pivot-table-inserter {
display: none;
}

Chart from Table button

.tfac-macro-inserter .aui-icon.table-chart-inserter {
display: none;
}

You can combine CSS to hide two of three buttons.


Add <style> ...</style> to CSS in the HTML macro:

<style>
 .tfac-macro-inserter {
    display: none;
 }
</style>