Table Filter and Charts for Confluence add-on allows you to set the number of table rows to show, enable static or dynamic row numbering and apply the default sorting order to each table column. Additionally, you can regulate width of filter boxes, enable fitting the table to the allocated screen area or enable hiding the filtration pane.
Starting from version 3.6.0 Table Filter and Charts add-on allows you to embed sparkline charts into the table column. Sparkline charts allows you to quickly visualize your data sets and see the data movements at once.
If your table contains decimal numbers, you may need to specify the correct decimal separator on the Filtration tab.
Starting from version 3.1.0 Table Filter and Charts add-on allows you to apply default sorting order to values in multiple columns. You can sort one or multiple table columns in the ascending or descending order.
You can also reset the applied sorting order for columns by selecting Reset column sorting on the filtration pane.
Table Filter add-on allows you to enable either dynamic or static row numbering. The difference between these numbering types is in the following:
You can enable automatic row numbering if you have a large data table.You can choose among the following options:
After saving the page, the table will show only the specified number of rows.
From version 3.9.10, you can use the dynamic modificator N+. For example, you can set it as '2+'. In this case it will show 2 table rows by default when you use no filtration. If you apply some filtration criteria, the set of filtered results will be expanded to show all the matches.
From version 3.10.8, you can use the modificator ' * ' (asterisk) to preserve the first rows of the table even when they do not match the specified filtration criteria.
For example, if you want to show the first 3 rows of your table all the time, just enter '3*'. The table header will be included automatically.
This functionality replaces the existing Fit table to screen area option. It is available since the release of Table Filter and Charts 3.10.0.
This option allows you to keep the relevant table rows and columns visible while you are scrolling your table horizontally or vertically.
To enable the hiding of table columns:
To hide specific columns:
The filtration pane will be hidden.
The filtration pane will be expanded.
Filters are hidden on the filtration pane.
In situations when you want to load the page with the disabled filters by default, you can use the Disable filtration at start option.
Starting from 3.10.0 version, Table Filter and Charts add-on allows you to output the Total column with the Table Filter macro. The following operations are available:
To enable the Total column for the table:
To rename the Total column:
The Table Filter and Charts app allows you to count totals for specific columns in your tables. The following operations are available:
To enable the totals for a column: