Table Filter and Charts for Confluence add-on allows you to filter the data presented in tables. Data filtration can be applied to one or several columns at a time. Just paste your table into the Table Filter macro and set the required columns for filtration. Besides table data filtration you can create dynamic charts and generate a pivot table with summarized and aggregated values with the capability to manage their settings while viewing Confluence pages.
Table Filter and Charts add-on includes three useful macros for efficient manipulations on table data:
Table Filter
Table Filter macro allows you to filter any type of table data with the available set of filters. Different types of filters can help you filter records listings, financial reports, tables containing dates and media assets.
Chart from Table
Chart from Table macro allows you to create dynamic and visually appealing charts on Confluence. A variety of avalable charts types can help you present your table in the way you want and like.
Pivot Table
Pivot Table macro allows you to summarize your data or aggregate it against the specific parameter. It can help you to cope with the tables containing repeated values so you can quickly count, sum or get the average, minimal or maximal values for a specific parameter.
Try the following use cases:
- Generic table data filtration
- Default values for filtration and regular expressions
- Table filtration by the user-entered keyword
- Global filter
- Filtering multiple tables at once
- Filtering the number range
- Filtering the date range
- Changing the width of the filter boxes
- Hiding the filters
- Fitting table to the screen area
- Hiding table columns
See the following pages for details on advanced usage of Table Filter and Charts add-on and check its compatibility with other add-ons and macros:
Changing the width of the filter boxes
Please note that Table Filter macro allows you to alternate width of filters on the filtration pane.
Last Name | First Name | Occupation | City |
---|---|---|---|
Doe | John | Developer | London |
Fry | Philip | Delivery boy | New York City |
Doe | Janet | Scientist | Tokyo |
Farnsworth | Hubert | Scientist | New York City |
Farnsworth | Cubert | Student | New York City |
Hiding the filters
Please note that Table Filter macro allows you to hide or show the filtration pane on the page. Click Show filter to expand the filtration pane and Hide filter to collapse it.
Last Name | First Name | Occupation | City |
---|---|---|---|
Doe | John | Developer | London |
Fry | Philip | Delivery boy | New York City |
Doe | Janet | Scientist | Tokyo |
Farnsworth | Hubert | Scientist | New York City |
Farnsworth | Cubert | Student | New York City |
Fitting table to the screen area
Please note that Table Filter macro allows you to automatically fit long tables to your screen area.
First Name | Last Name | Transaction amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number |
---|---|---|---|---|---|---|---|
Reuben | Barnett | $129.42 | Guápiles | Tunisia | Blocked | Yes | 8 |
McKenzie | Cleveland | $216.75 | Savannah | United States | Blocked | Yes | 1 |
Portia | Lang | $422.53 | Meerut | Côte D'Ivoire (Ivory Coast) | Rejected | No | 5 |
Eagan | Mcgee | $253.03 | Orangeville | Afghanistan | Approved | No | 2 |
Rahim | Velazquez | $454.06 | Lac-Serent | Georgia | Approved | Yes | 6 |
Roth | Hull | $142.57 | Luziânia | Sao Tome and Principe | Blocked | No | 4 |
Jack | Griffin | $146.60 | Georgia | Bahamas | Blocked | No | 4 |
Faith | Newton | $324.96 | Okigwe | Sri Lanka | Rejected | Yes | 1 |
Basia | Ray | $260.39 | Valcourt | Equatorial Guinea | Rejected | Yes | 4 |
Leandra | Duncan | $380.33 | My | Swaziland | Rejected | No | 6 |
Cameran | Velasquez | $144.75 | Schiltigheim | Bangladesh | Rejected | Yes | 8 |
Amery | Poole | $418.48 | Zolder | Azerbaijan | Rejected | Yes | 1 |
Owen | Welch | $279.12 | Springdale | Benin | Rejected | Yes | 4 |
Germaine | Hines | $347.08 | Bellingen | Algeria | Approved | No | 6 |
Thane | Cortez | $338.56 | Penrith | Tunisia | Approved | Yes | 1 |
Sean | Delacruz | $421.67 | Vietri di Potenza | Libya | Rejected | No | 4 |
Willow | Skinner | $216.70 | Ham-sur-Sambre | Venezuela | Approved | No | 1 |
Camilla | Good | $311.10 | Saint-Hilarion | Malawi | Rejected | No | 7 |
Ingrid | Horne | $365.20 | Crato | Dominica | Approved | Yes | 4 |
Claire | Raymond | $126.99 | Wieze | Western Sahara | Blocked | Yes | 9 |
Akeem | Holder | $131.59 | Sutton | Samoa | Blocked | Yes | 7 |
Yuli | Hubbard | $107.57 | Hudson Bay | Bolivia | Rejected | No | 4 |
Gregory | Sampson | $339.91 | Stroud | Mozambique | Blocked | No | 1 |
Freya | Osborn | $198.86 | Rexton | Luxembourg | Approved | Yes | 5 |
Kylan | Dillard | $264.70 | Market Drayton | Yemen | Rejected | No | 3 |
Curran | Dickson | $360.20 | San Francisco | Saint Martin | Blocked | No | 7 |
Sylvester | Campos | $338.44 | Riparbella | Armenia | Blocked | Yes | 5 |
Hadley | Gates | $363.39 | Chelmsford | New Zealand | Rejected | Yes | 7 |
Willa | Stevens | $137.89 | Glabais | Japan | Approved | No | 2 |
Keelie | Byers | $236.10 | Cavaion Veronese | Palestine, State of | Approved | No | 3 |
Jordan | Weber | $249.33 | Shepparton | Anguilla | Blocked | Yes | 9 |
Karly | Walls | $200.81 | Charlottetown | Guatemala | Approved | Yes | 7 |
Octavius | Cervantes | $235.63 | Merksem | Dominica | Approved | Yes | 4 |
Tyrone | Alvarez | $303.65 | Thame | Iraq | Blocked | Yes | 5 |
Jolene | Howe | $321.67 | Maple Creek | Togo | Blocked | No | 3 |
Cody | Ross | $219.44 | Gent | Austria | Blocked | Yes | 6 |
Chase | Bryant | $493.65 | Moustier-sur-Sambre | Czech Republic | Approved | No | 9 |
Lynn | Cummings | $484.17 | Metairie | Liechtenstein | Approved | No | 3 |
Lars | Shaw | $170.60 | Pittsburgh | British Indian Ocean Territory | Rejected | No | 4 |
Cassidy | Porter | $142.39 | Saint-Maur-des-Fossés | Zambia | Approved | Yes | 3 |
Whilemina | Goodwin | $255.81 | Amaro | Guinea | Rejected | No | 3 |
Jordan | Mullen | $151.41 | Alajuela | Eritrea | Approved | No | 9 |
Curran | Bond | $207.97 | Wattrelos | Belize | Approved | Yes | 4 |
Shad | Shelton | $177.90 | Salt Lake City | Estonia | Rejected | No | 4 |
Eve | Hines | $113.99 | Montpellier | Netherlands | Rejected | No | 7 |
Amir | Odom | $203.43 | Manavgat | Albania | Blocked | Yes | 5 |
Evan | Coffey | $489.53 | Prince Albert | Brunei | Rejected | No | 5 |
Quynn | King | $393.43 | São Luís | Chile | Blocked | No | 9 |
Ivy | Alvarado | $198.75 | Guwahati | Cape Verde | Approved | No | 2 |
Seth | Vasquez | $333.66 | Greater Hobart | Malaysia | Blocked | No | 3 |
Guy | Cotton | $168.20 | Saint-Pierre | Denmark | Blocked | No | 4 |
Xyla | Spears | $368.74 | Jamoigne | Guernsey | Rejected | No | 2 |
Haviva | Hancock | $136.33 | Chelsea | Zimbabwe | Approved | No | 5 |
Juliet | Barlow | $326.73 | Solingen | Iran | Approved | Yes | 7 |
Kay | Cole | $158.75 | Clare | Netherlands | Approved | Yes | 2 |
Zenaida | Kirkland | $315.19 | Yellowhead County | Mongolia | Blocked | No | 4 |
Ryan | Ware | $367.76 | Tuticorin | Armenia | Rejected | Yes | 8 |
Maite | Lowe | $256.17 | Muno | Poland | Blocked | No | 1 |
Sandra | Schultz | $273.51 | Nampa | Colombia | Approved | Yes | 9 |
Karina | Horton | $443.37 | Esslingen | Taiwan | Rejected | Yes | 2 |
Lysandra | Black | $322.36 | Strombeek-Bever | Swaziland | Blocked | Yes | 8 |
Alden | Buckner | $249.18 | San Marcello Pistoiese | Hungary | Blocked | No | 1 |
Levi | Nolan | $478.53 | Chambord | Ukraine | Rejected | No | 7 |
Buckminster | Ewing | $239.77 | Haren | Argentina | Blocked | No | 1 |
Aidan | Henson | $340.93 | Valpelline | Jersey | Approved | No | 3 |
Howard | Crosby | $201.61 | Chambave | Cameroon | Blocked | No | 2 |
Ginger | Castro | $473.40 | Isle-aux-Coudres | Latvia | Approved | No | 4 |
Hyatt | Mullins | $450.40 | Oldenzaal | Slovenia | Rejected | No | 4 |
Rachel | Head | $166.15 | Bautzen | Nauru | Blocked | No | 7 |
Shoshana | Underwood | $336.12 | Parkland County | Liechtenstein | Blocked | No | 2 |
Colt | Kent | $482.74 | Jalgaon | Grenada | Approved | Yes | 3 |
Amethyst | Dunn | $313.64 | Dipignano | Western Sahara | Approved | Yes | 9 |
Plato | Duke | $229.55 | Exeter | India | Blocked | Yes | 1 |
Jared | Dale | $391.90 | Béziers | Mauritius | Approved | Yes | 3 |
Luke | Vang | $375.44 | Vorselaar | Jersey | Blocked | Yes | 1 |
Phillip | Reed | $431.70 | Chittoor | Christmas Island | Approved | Yes | 6 |
Brandon | Lowery | $213.54 | Cork | Chad | Rejected | Yes | 1 |
Rafael | Elliott | $281.05 | Little Rock | Jamaica | Approved | Yes | 4 |
Lyle | Black | $437.51 | Mold | Palau | Rejected | Yes | 6 |
Wendy | Rosa | $219.66 | Fortaleza | Egypt | Approved | No | 7 |
Priscilla | Dodson | $414.83 | Polpenazze del Garda | Christmas Island | Approved | Yes | 1 |
Quamar | Crawford | $465.99 | Treglio | Suriname | Blocked | Yes | 2 |
Shad | Flores | $442.84 | Vezirköprü | Guyana | Blocked | Yes | 6 |
Lana | Wheeler | $202.64 | St. Neots | Palau | Rejected | No | 1 |
Vanna | Farmer | $351.21 | Millport | Maldives | Approved | Yes | 9 |
Cadman | Ray | $352.24 | Cheyenne | South Sudan | Blocked | No | 7 |
Kimberley | Savage | $429.55 | Miami | Vanuatu | Approved | No | 9 |
Armand | Sears | $477.13 | Mussy-la-Ville | Saint Vincent and The Grenadines | Approved | No | 8 |
Sawyer | Vance | $492.63 | Davoli | Benin | Rejected | No | 4 |
Tanek | Lyons | $172.85 | Rocky View | Afghanistan | Approved | No | 9 |
Nayda | Hickman | $295.47 | Newcastle-upon-Tyne | Kiribati | Blocked | No | 3 |
Aileen | Waters | $202.47 | Idar-Oberstei | Slovakia | Blocked | Yes | 3 |
Forrest | Larsen | $269.64 | Gulfport | Korea, North | Blocked | Yes | 3 |
Willa | Kemp | $239.89 | Somma Lombardo | Wallis and Futuna | Approved | Yes | 2 |
Eugenia | Byrd | $466.08 | Caruaru | Northern Mariana Islands | Rejected | Yes | 8 |
Kato | Beck | $396.49 | Khanpur | Solomon Islands | Approved | Yes | 2 |
Hiding table columns
Please note that Table Filter macro allows you to hide columns if you have a too wide table. Select one or multiple columns to hide in the table below.
First Name | Last Name | Contact Phones | Last Transaction Date | Bank Account Number | Transaction amount | Tax Amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number |
---|---|---|---|---|---|---|---|---|---|---|---|
Reuben | Barnett | 0500 009888 | 12/14/14 | DO07819385109432271545550865 | $129.42 | $10.28 | Guápiles | Tunisia | Blocked | Yes | 8 |
McKenzie | Cleveland | 07624 785373 | 09/15/14 | CH6046131558340157475 | $216.75 | $46.19 | Savannah | United States | Blocked | Yes | 1 |
Portia | Lang | (011247) 04420 | 09/27/14 | EE967962637165872502 | $422.53 | $16.29 | Meerut | Côte D'Ivoire (Ivory Coast) | Rejected | No | 5 |
Eagan | Mcgee | 07212 430492 | 09/19/14 | MK83589588636375406 | $253.03 | $26.26 | Orangeville | Afghanistan | Approved | No | 2 |
Rahim | Velazquez | 0325 526 8440 | 12/31/14 | FO0682149824230550 | $454.06 | $27.73 | Lac-Serent | Georgia | Approved | Yes | 6 |
Roth | Hull | 0500 311844 | 10/11/14 | LU056987267796106873 | $142.57 | $14.14 | Luziânia | Sao Tome and Principe | Blocked | No | 4 |
Jack | Griffin | 07624 307488 | 09/04/14 | BA714509342088998370 | $146.60 | $34.55 | Georgia | Bahamas | Blocked | No | 4 |
Faith | Newton | 0800 1111 | 09/24/14 | LU521764205226552485 | $324.96 | $24.60 | Okigwe | Sri Lanka | Rejected | Yes | 1 |
Basia | Ray | 0346 983 8340 | 08/13/14 | TR280491289079508593611789 | $260.39 | $45.19 | Valcourt | Equatorial Guinea | Rejected | Yes | 4 |
Leandra | Duncan | 0359 889 6822 | 01/11/15 | CR0942393063075420342 | $380.33 | $34.57 | My | Swaziland | Rejected | No | 6 |