Table Filter, Charts & Spreadsheets for Confluence Current: How to use Table Filter macro PDF Download PDF Download page How to use Table Filter macro. Current page Include child pages All pages How to use Table Filter macro Table Filter is one of the macros bundled in the Table Filter, Charts & Spreadsheets for Confluence app. The macro allows you:To filter all kinds of table dataTo calculate totals and visualize table dataTo sort tables, freeze rows and columns and apply other table viewing options Add Table Filter on the page Try live filtration in table headers Filter table data on the fly in table headers: Enable the filtration panel displayStep 1. Add the macro to your table. Choose the handy way to do this: Read more:How to insert and remove the macrosHow to use Table Excerpt and Table Excerpt Include macrosHow to use Table from CSV macroStep 2. Add filters to the columns of your table: Read more:Table filtrationStep 3. Filter your table and save changes: Read more:Configuring the filtration paneStep 4. Make your table more organized: Read more:Sorting, freezing and other table viewing options How to export macros and results Find the answer to your question among the related FAQ What can I do if I can't find and add the macros? How can I remove the macro accidentally added to a table? Can I use the app for a table with merged cells? Can I filter an already existing table? Can I use the filter for a table generated by another macro? How can I filter not equal values in the table? How can I freeze rows and/or columns of the table? Supported date formats Create a pivot table from your table, calculate and aggregate data Configuring the pivot tableAggregation by date period and number rangeManaging pivot table options 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 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 Use only one source table to build multiple charts and pivot tables Output tables from CSV or JSON Combine all the macros with each other and with built-in and third-party macros ×
