Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Inserting the macros

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

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

In the page view mode

Cloud (the Table Filter macro)

To enable live filtration in headers:

  1. Click the Image Added button on the top right corner of the page beside the Edit button.
  2. Click Enable in the dialog.
  3. Start filtering data in table headers

    Handy Tip
    id34860480447012954

    Learn more on this page.

    Image Added



Handy Carousel

Image AddedImage Added


Data Center (Server)

Learn more about live table filtration in headers on this page.

To insert the macros:

  1. Open a page with a table.
  2. Hover over the table.
  3. Click the Image Addedicon.
  4. Select one of the options:
    • Filter table data Image Modified
    or
    •  (to display the filtration panel)
    • Create a pivot table Image Modified
    or
    • Create a chart from data series Image Modified
    icon on the panel that appears to the right side of the table
    • .
Image Removed
Info
Inserting

You can disable the

macro through

inline macro insertion and live filtration on a global or individual basis.


Image Added


Through the action icon

on

in the editor

paneThe feature is not available in Cloud versionImage Removed

(Data Center/Server only)

  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

entrying

  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}
    .
    • (in Data Center (Server) and the legacy editor in CLoud)
    • /Table Filter, /Pivot Table, /Chart from Table, /Table Transformer, /Table Excerpt, /Table Excerpt Include, /Table from CSV, /Table Toolbox (in the new Cloud editor)
  4. From the prompted list of macro choices, select the macro.
  5. Place the table within the macro.
InfoIn the new Confluence Cloud editor add /Table Filter or /Pivot Table or /Chart from Table or /Table Transformer query on the page
  1. .
 


Selection of the macros

Selecting in the Select

Macro

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 versionImage Removed

macros (Data Center/Server only)

  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.
Info

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

Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleCopying a table in Confluence Cloud




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

In the page view mode (Table Filter, Pivot Table, Chart from Table)

  1. Click the cogwheel icon on the filtration panel or on the pivot table or chart control panel.
  2. Select the Remove the macro option.
  3. Click Remove in the dialog.

Image Added

In the page edit mode (all the macros)

Data Center (Server)

  1. Switch Confluence page to the edit mode.
  2. Select the Table Filter macro with the table or macro outputting the table/Pivot Table/Chart from Table/Table Transformer/Table Excerpt macro.
  3. Click Unwrap.
To remove the macro from the table in Confluence Cloud copy
Info

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

Info

Cloud

  1. Switch Confluence page to the edit mode.
  2. Copy the table and paste it outside the macro body.
  3. Select the macro
with the table
  1. and click Remove.
Image Removed


Configuring inline macro insertion and live filtration
(Data Center/Server only)

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/live filtration 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/live filtration.
    • Individual users - enter the names of individual users who can use the inline macro insertion/live filtration.
    • Anonymous - check the box to allow anonymous users to use the inline macro insertion/live filtration.

To disable inline macro insertion/live filtration:

  1. Clear the Inline macro insertion box.

To disable inline macro insertion/live filtration for the group/user:

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


Handy Carousel

Image AddedImage Added



On the user's level

To enable inline macro insertion/live filtration:

  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 optioninsertion or live filtration options.

To disable inline macro insertion/live filtration:

  1. Clear the Inline macro insertion option.
Info

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

Image Removed

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

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:

Note

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.

Image Removed


Hiding inline insertion

Image Added


Hiding inline macro insertion and live filtration buttons

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

To hide all inline insertion buttons hide all buttons:

Code Block
.tfac #tfac-macro-inserter, #tfac-macro-inserter-container, .tf-inline-filter:not(.btn, .trigger) {
    display: none !important;
 } 
 To

To hide one of three inline insertion buttons:

  • Table Filter button
Code Block
.tfac#tfac-macro-inserter .aui-icon.[data-macro="table-filter-inserter"] {
display: none !important;
} 
  • Pivot Table button
Code Block
.tfac#tfac-macro-inserter .aui-icon.[data-macro="pivot-table-inserter"] {
display: none !important;
}
 
  • Chart from Table button

Code Block
.tfac#tfac-macro-inserter .aui-icon.[data-macro="table-chart-inserter"] {
display: none !important;
}   


Info

You can combine CSS to hide two of three buttons.


Info

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

Code Block
<style>
 .tfac#tfac-macro-inserter, #tfac-macro-inserter-container, .tf-inline-filter:not(.btn, .trigger) {
    display: none !important;
 }
</style>




Handy Carousel

Image Removed

Image Removed

Image Removed

Image Removed

Image Added

Image Added

Image Added



Removing all the macros from pages (Data Center/Server only)

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:

Note

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.

Image Added