Versions Compared

Old Version 3

changes.mady.by.user Nikita Kamai

Saved on

compared with

New Version Current

changes.mady.by.user Katerina Kovriga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space TFAC and version Draft
Excerpt
hiddentrue

Combine a variety of macros from Table Filter, Charts & Spreadsheets.

Table Toolbox is one of the macros bundled in the Table Filter, Charts & Spreadsheets for Confluence app. The macro allows you to combine (nest) multiple macros included in the app in one tool and complete analytical tasks with ease.

Note

The Table Toolbox macro was specifically developed to overcome the nesting limitations of the new Cloud editor. Without this macro, it is impossible to wrap macros with bodies one into another.

Add Table Toolbox macro on the page

Section
Column
width700px

Image Removed

Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 1. Insert the macro on the page:
Column
Read more:
Section
Wrap tables or table macros with Table Toolbox in the edit mode:

Multimedia
nameToolbox adding (Cloud).mp4
width600
height400

Image Removed

Column
width700px
Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 2. Place one or multiple tables within the Table Toolbox macro body:
Column
Read more:
Section
Column
width700px
Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 32. Select the macro and click Edit. Drag and drop macros icons to combine them:

Multimedia
nameToolbox macro adding (Coud).mp4
width600
height400
Image Removed

Column


Section
Column
width700px
Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 43. Configure Table Filter, Table Transformer, Pivot Table and Chart from Table multiple macros in one dialog:

Multimedia
nameToolbox macro tuning (Coud).mp4
width600
height400
Image Removed

Column
Read more:


Section
Column
width700px
Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 54. Remove or replace unneccessary macros:

Multimedia
nameToolbox macro removing (Coud).mp4
width600
height400
Image Removed

Column
Read more:


Section
Column
width700px
Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 65. Save the macro and publish the page:

Multimedia
nameToolbox saving (Coud).mp4
width600
height400
Image Removed

Column
Read more:


Available macros within the Table Toolbox macro

Inside its shell, the Table Toolbox macro operates with the following macros with bodies:

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

These macros can be added and rearranged in various sequences to complete custom use cases.

Manually created and bodiless macro generated (for example, Table Excerpt Include, Jira Issues, Page Properties Report, etc.) tables should be wrapped into the Table Toolbox macro directly on the page.

Image Added

These tables are recognized as source tables and shown inside the Table Toolbox macro shell.

Section
Column
width170px

Column

Filter tables with the help of the various filter types

Section
Column
width170px

Column

Create a pivot table from your table, calculate and aggregate data

Section
Column
width170px

How to use Table Transformer macroImage Added

Column

Merge multiple tables, perform complex calculations and custom transformations

Section
Column
width170px

Column

Build various charts based on your table

Section
Column
width170px

How to use Table from CSV macroImage Added

Column

Output tables from CSV