We continue our series of blog posts related to efficient management of table data in Confluence. In the recent posts we have already outlined the principles of work with the Page Properties Report macro, dynamic Scaffolding table, data fetched from external databases and JIRA issues. This time we will guide you through the options available in Table Filter and Charts add-on.
We will show you the way you can apply the options available in the Table Filter macro and adjust the look of your table or modify filtration parameters.
So fasten your belts, we start!
Parameters of Table Filter macro
The Table Filter macro is equipped with the range of parameters and options that users may not use or don’t know how to apply them in their everyday work.This blog post will lift the veil of mystery that hung over them and we will show you in what situations you can apply them.
First of all, the way of showing options and parameters was changed in Table Filter and Charts 3.8.0. We added the tabbed sections and separated filters from parameters and options. If you use the older versions of the add-ons, you will have only one panel with all filters and parameters on it, anyway the essentials will remain the same.
So what do we have here?
When you try to edit the Table Filter macro, you will see here that filtration options and parameters regulating the table look.
Filtration Options for Ease and Convenience
Once you edit the Table Filter macro, you will find the following filtration options:
- Decimal Separator – you can define the used decimal separator in numbers and apply it to sparkline charts.
- Date Format – you can select the appropriate date format or manually specify the correct one for the date range filter.
- Default Filter Values – you can set default filter values for each filter and these values will be automatically applied upon page reload.
- Filter Width – you can define the width for dropdown, free text, global and icon filters.
- Exclusive filters – you can set the inverted state for specific filters.
- Disable change saving – you can use this option to forbid the saving of filtration results, so users will be able to filter data but results will not be saved.
- Hide filter labels – you can hide the filter labels for saving a bit of space on the filtration pane.
- Hide filtration panel – you can use this option to hide the filtration panel and show only the needed filtration results.
- Hide control buttons – you can use this option to hide controls used for clearing filters, adding new ones and so on.
The way you may apply them differs on your specific objectives, but it is better to have a range of parameters than nothing at all.
Managing Look of the Table
Besides regulation of table data filtration, you also get a set of parameters to define the look of your tables, as follows:
- Show First N Rows – you can show the limited number of rows from your table.
- Row Numbering – you can enable the automatic row number either in ascending or descending order. Additionally, you can use the static or dynamic row numbering.
- Default Sorting – you can define the appropriate sorting order for multiple columns and get table data look the way you want it.
- Fit Table to Screen Area – you can fit large tables to the available screen area, so you will not have to scroll a long page all the time.
- Sparkline Charts – you can use convenient visualization of numerical values stored in your table.
With all these options available you get enough freedom to manage table data and manipulate it the way you actually need.
So, let’s see these features in real work.
If you have any questions, feature requests or problems with add-on configuration, drop an email to firstname.lastname@example.org and I will contact you.