Page History

Outputting Sparkline Charts within Tables

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.

1. Switch the page to the edit mode.
2. Select the macro and

1. click Edit.
2. Locate

1. the Sparkline charts

1.  option and select it.
   Image Modified
2. Specify the appropriate name for the column outputting sparkline charts or leave it as is.

1. Click Save.
2. Once you save the page, you will see sparkline charts in the table column.
   Image Modified

Applying the default sorting order to columns

Starting from version 3.1.0 Table Filter and Charts add-on allows you to apply default sorting order to values in multiple columns.

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Locate the Default Sorting box.
4. Click it and select the columns with the appropriate sorting order in them. Once you have saved the macro and the page, the defined sorting order is automatically applied to the selected columns.

Image Added

Adding automatic row numbering

Table Filter add-on allows you to enable either dynamic or static row numbering. The difference between these numbering types is in the following:

• If you

• use dynamic row numbering, row numbering is updated each time you filter the table. So all the time your row numbers will look like 1, 2, 3 and so on.
• If you

• use static row numbering, rows are numbered one time and row numbers are preserved all the time you filter the table. So after filtration your rows may be numbered like 2, 5, 6, 8 and so on.

You can enable automatic row numbering if you have a large data table.You can choose among the following options:

• Dynamic Ascending
• Dynamic Descending
• Static Ascending
• Static Descending

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Locate

1. the Automatic Row Numbering box and select the appropriate row numbering option.

Image Added

Hiding table columns

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Select the Hide columns option.
4. Click the Filters' Default Values button.
5. Locate the Hide columns box and select the columns you want to hide.
6. Click Save.
7. Save the macro and page.

Image Added

Changing order of filters

You can change order of filters of the same type. Order of filters of different types cannot be changed.

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Locate the filter type in which you want to change order of filtered columns
4. Drag the column label to the appropriate place in the filter box.

Image Modified

Fitting the table to screen area

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Select

1. the Fit Table to Screen Area

1.  option.
2. Save the macro and page.

Image Modified

Once you save the page, the table will automatically fit the screen area.

Image Modified

Hiding filter labels

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Select

1. the Hide Filter Labels

1.  option.
2. Save the macro and page.

 Image Modified

Collapsing / expanding the filtration pane 

1. Open the page with Table Filter macro.
2. Point to the bottom of the filtration pane.
   Image Modified
3. Click the collapse bar.
4. Point to the header of the table.
   Image Modified
5. Click the expand bar.

Setting default width for filter boxes

1. Switch the page to edit mode.
2. Select the macro and click Edit.

1. Click Set Width of filters.
2. Enter the appropriate width in pixels for filters.
3. Save the macro and page.

Image Modified

Disabling / Enabling filters

1. Open the page with Table Filter macro.
2. On the filtration pane, locate and click

1. the Disable all filters Image Modified icon.
   Image Modified
2. On the filtration pane, locate and click the Enable all filters Image Modified icon.