Table Filter and Charts for Confluence add-on allows you to manage filtration parameters and adjust them to your actual needs.

 

 

Setting the Decimal Separator

You may need to set the correct decimal separator when using the number range filters or enabling sparkline charts if your table contains decimal numbers.

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Locate the Decimal separator box.
  5. Select the correct decimal separator from the list, as follows:
    • Point
    • Comma
  6. Save the macro and the page.

 

 

Setting the Date Format

You may need to set the correct date format when using the date range filters. Filtration of dates may work incorrectly if the incorrect date format is specified.

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Locate the Date format box.
  5. Select the correct date format from the list or manually specify the needed format.
  6. Save the macro and the page.

For the details on specifying date formats, see our FAQ.

 

 

Setting default width for filter boxes

You may need to increase or decrease of filter boxes shown on the filtration pane.

To set width for filter boxes:

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Click Set width of filters.
  5. Enter the appropriate width in pixels for available filters.
  6. Save the macro and the page.

For the details on how set width of filter boxes in the page view mode, see this.

 

 

Disabling the Change Saving

You may need to disable the saving changes after filtration. This can be useful when you share some table with other people and set the default values for filtration, and do not want them to be overwritten.

To disable the change saving:

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Locate and select the Disable the change saving option.
  5. Save the macro and the page.

 

 

 

 

 

 


Sharing the Filtered Results via Link

You can copy the link to the currently used filters and applied values and further share it with your colleagues, so they can quickly open the filtered data series even when the initial filtration has been changed since then.

  1. On the filtration pane, click the cogwheel button.
  2. Select Copy the filter URL.

The link to the current filtered data series will be copied to the buffer.


Hiding table columns

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Select the Hide columns option.
  4. Click the Filters' Default Values button.
  5. Locate the Hide columns box and select the columns you want to hide.
  6. Click Save.
  7. Save the macro and page.

Changing order of filters

You can change order of filters of the same type. Order of filters of different types cannot be changed.

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Locate the filter type in which you want to change order of filtered columns
  4. Drag the column label to the appropriate place in the filter box.

Hiding filter labels

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Select the Hide Filter Labels option.
  4. Save the macro and page.

 

Collapsing / expanding the filtration pane 

  1. Open the page with Table Filter macro.
  2. Point to the bottom of the filtration pane.
  3. Click the collapse bar.
  4. Point to the header of the table.
  5. Click the expand bar.

Disabling / Enabling filters

  1. Open the page with Table Filter macro.
  2. On the filtration pane, locate and click the Disable all filters  icon.
  3. On the filtration pane, locate and click the Enable all filters  icon.