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 click Edit.
3. Locate the Sparkline charts option and select it.
   
4. Specify the appropriate name for the column outputting sparkline charts or leave it as is.
5. Click Save.
6. Once you save the page, you will see sparkline charts in the table column.
   

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.

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 the Automatic Row Numbering box and select the appropriate row numbering option.

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.

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.

Fitting the table to screen area

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Select the Fit Table to Screen Area option.
4. Save the macro and page.

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

Hiding filter labels

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Select the Hide Filter Labels option.
4. Save the macro and page.

Collapsing / expanding the filtration pane 

1. Open the page with Table Filter macro.
2. Point to the bottom of the filtration pane.
   
3. Click the collapse bar.
4. Point to the header of the table.
   
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.
3. Click Set Width of filters.
4. Enter the appropriate width in pixels for filters.
5. Save the macro and page.

Disabling / Enabling filters

1. Open the page with Table Filter macro.
2. On the filtration pane, locate and click the Disable all filters  icon.
   
3. On the filtration pane, locate and click the Enable all filters  icon.