Table Filter, Charts & Spreadsheets for Confluence Current: How to use Table Toolbox macro PDF Download PDF Download page How to use Table Toolbox macro. Current page All pages How to use Table Toolbox macro 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. Add Table Toolbox macro on the page Step 1. Insert the macro on the page: Read more: How to insert and remove the macrosStep 2. Place one or multiple tables within the Table Toolbox macro body: Read more: How to insert and remove the macrosStep 3. Select the macro and click Edit. Drag and drop macros icons to combine them: Step 4. Configure Table Filter, Table Transformer, Pivot Table and Chart from Table macros in one dialog: Read more: Table filtrationConfiguring the pivot tableHow to use Chart from Table macroHow to use Table Transformer macroStep 5. Remove or replace unneccessary macros: Read more: How to insert and remove the macrosStep 6. Save the macro and publish the page: Read more: Sorting, freezing and other table viewing options How to export macros and results Filter tables with the help of the various filter types Table filtrationSorting, freezing and other table viewing optionsCalculations in tablesConfiguring the filtration pane Create a pivot table from your table, calculate and aggregate data Configuring the pivot tableAggregation by date period and number rangeManaging pivot table options Merge multiple tables, perform complex calculations and custom transformations Default automatic presetsGeneral syntax and SQL functions availableCustom Transformation - use cases with advanced SQL queriesAdvanced table cells formatting Build various charts based on your table Gantt chart typePie and Donut chart typesBubble Pie chart typeColumn, Stacked Column, Bar, Stacked Bar chart typesLine, Area, Stacked Area chart typesTime Line, Time Area, Stacked Time Area chart typesRadar (Spider) chart typeContiguity / Barcode chart (use case)Scatter plot (use case)Punchcard (use case)Comparison of Chart macro against Chart from Table macro Output tables from CSV ×
