Page History

Table Filter and , Charts & Spreadsheets for Confluence add-on app 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.

IconbuttonTitleDocumentation
Handy Button
blank true
color Blue
link
URL
https://docs.stiltsoft.com/
display
tfac/
TableFilter/Table+Filter+for+Confluence?utm_source=demo&utm_medium=referral&utm_content=tf-landing-button&utm_campaign=table-filter-traffic-sources
dc-server/welcome-to-table-filter-charts-spreadsheets-for-confluence-42239760.html
name Documentation
width 200

Handy Button
blank true
color Blue
link https://marketplace.atlassian.com/apps/27447/table-filter-charts-spreadsheets-for-confluence?hosting=datacenter&tab=overview
name Try App for Free
width 200

Please select the macro you want to master and proceed to the corresponding page for training.

Table Filter
Image Added

Table Filter and Charts for Confluence
Button
Title Download Add-on
URL https://marketplace.atlassian.com/plugins/com.stiltsoft.confluence.plugin.tablefilter.tablefilter?utm_source=demo&utm_medium=referral&utm_content=tf-landing-download-button&utm_campaign=table-filter-traffic-sources

Button
Title Submit Idea
URL https://stiltsoft.customercase.com/forums/support-requests/ideas/create?utm_source=referral&utm_medium=demo&utm_content=table-filter-space-page&utm_campaign=table-filter-traffic-sources

Button
Title Report Issue
URL https://stiltsoft.customercase.com/forums/table-filter-for-confluence/ideas/create?utm_source=referral&utm_medium=demo&utm_content=table-filter-space-page&utm_campaign=table-filter-traffic-sources

Table Filter and Charts add-on includes three useful macros for efficient manipulations on table data:

Table Filter
Image Removed
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.
Table Spreadsheet
Image Added
Table Spreadsheet macro allows you to add Excel-like spreadsheets. You can work with them both in the page view and page edit mode.

Chart from Table
Image Removed
Image Added
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
Image Removed
Image Added
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:
Children Display
all true
Changing the width of the filter boxes
Info
Please note that Table Filter macro allows you to alternate width of filters on the filtration pane.
Table Filter
cell-width 100,150,200
column Last Name,First Name,Occupation
id 14412827707586c0f2523a350ba0b5a518e2d122a34fc
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
Info
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.
Table Filter
button true
column Last Name
id 14412827708196c0f2523a350ba0b5a518e2d122a34fc
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
Info
Please note that Table Filter macro allows you to automatically fit long tables to your screen area.
Table Filter
numbering true
column Customer Status,Suspicious Transaction Activity,Target Transaction City
id 1441282770894fc02ae92d220e111df089cb784761aa7
limitHeight true

First NameLast NameTransaction amountTarget Transaction CityTarget Transaction CountryCustomer StatusSuspicious Transaction ActivityTotal Transaction NumberReubenBarnett$129.42GuápilesTunisiaBlockedYes8McKenzieCleveland$216.75SavannahUnited StatesBlockedYes1PortiaLang$422.53MeerutCôte D'Ivoire (Ivory Coast)RejectedNo5EaganMcgee$253.03OrangevilleAfghanistanApprovedNo2RahimVelazquez$454.06Lac-SerentGeorgiaApprovedYes6RothHull$142.57LuziâniaSao Tome and PrincipeBlockedNo4JackGriffin$146.60GeorgiaBahamasBlockedNo4FaithNewton$324.96OkigweSri LankaRejectedYes1BasiaRay$260.39ValcourtEquatorial GuineaRejectedYes4LeandraDuncan$380.33MySwazilandRejectedNo6CameranVelasquez$144.75SchiltigheimBangladeshRejectedYes8AmeryPoole$418.48ZolderAzerbaijanRejectedYes1OwenWelch$279.12SpringdaleBeninRejectedYes4GermaineHines$347.08BellingenAlgeriaApprovedNo6ThaneCortez$338.56PenrithTunisiaApprovedYes1SeanDelacruz$421.67Vietri di PotenzaLibyaRejectedNo4WillowSkinner$216.70Ham-sur-SambreVenezuelaApprovedNo1CamillaGood$311.10Saint-HilarionMalawiRejectedNo7IngridHorne$365.20CratoDominicaApprovedYes4ClaireRaymond$126.99WiezeWestern SaharaBlockedYes9AkeemHolder$131.59SuttonSamoaBlockedYes7YuliHubbard$107.57Hudson BayBoliviaRejectedNo4GregorySampson$339.91StroudMozambiqueBlockedNo1FreyaOsborn$198.86RextonLuxembourgApprovedYes5KylanDillard$264.70Market DraytonYemenRejectedNo3CurranDickson$360.20San FranciscoSaint MartinBlockedNo7SylvesterCampos$338.44RiparbellaArmeniaBlockedYes5HadleyGates$363.39ChelmsfordNew ZealandRejectedYes7WillaStevens$137.89GlabaisJapanApprovedNo2KeelieByers$236.10Cavaion VeronesePalestine, State ofApprovedNo3JordanWeber$249.33SheppartonAnguillaBlockedYes9KarlyWalls$200.81CharlottetownGuatemalaApprovedYes7OctaviusCervantes$235.63MerksemDominicaApprovedYes4TyroneAlvarez$303.65ThameIraqBlockedYes5JoleneHowe$321.67Maple CreekTogoBlockedNo3CodyRoss$219.44GentAustriaBlockedYes6ChaseBryant$493.65Moustier-sur-SambreCzech RepublicApprovedNo9LynnCummings$484.17MetairieLiechtensteinApprovedNo3LarsShaw$170.60PittsburghBritish Indian Ocean TerritoryRejectedNo4CassidyPorter$142.39Saint-Maur-des-FossésZambiaApprovedYes3WhileminaGoodwin$255.81AmaroGuineaRejectedNo3JordanMullen$151.41AlajuelaEritreaApprovedNo9CurranBond$207.97WattrelosBelizeApprovedYes4ShadShelton$177.90Salt Lake CityEstoniaRejectedNo4EveHines$113.99MontpellierNetherlandsRejectedNo7AmirOdom$203.43ManavgatAlbaniaBlockedYes5EvanCoffey$489.53Prince AlbertBruneiRejectedNo5QuynnKing$393.43São LuísChileBlockedNo9IvyAlvarado$198.75GuwahatiCape VerdeApprovedNo2SethVasquez$333.66Greater HobartMalaysiaBlockedNo3GuyCotton$168.20Saint-PierreDenmarkBlockedNo4XylaSpears$368.74JamoigneGuernseyRejectedNo2HavivaHancock$136.33ChelseaZimbabweApprovedNo5JulietBarlow$326.73SolingenIranApprovedYes7KayCole$158.75ClareNetherlandsApprovedYes2ZenaidaKirkland$315.19Yellowhead CountyMongoliaBlockedNo4RyanWare$367.76TuticorinArmeniaRejectedYes8MaiteLowe$256.17MunoPolandBlockedNo1SandraSchultz$273.51NampaColombiaApprovedYes9KarinaHorton$443.37EsslingenTaiwanRejectedYes2LysandraBlack$322.36Strombeek-BeverSwazilandBlockedYes8AldenBuckner$249.18San Marcello PistoieseHungaryBlockedNo1LeviNolan$478.53ChambordUkraineRejectedNo7BuckminsterEwing$239.77HarenArgentinaBlockedNo1AidanHenson$340.93ValpellineJerseyApprovedNo3HowardCrosby$201.61ChambaveCameroonBlockedNo2GingerCastro$473.40Isle-aux-CoudresLatviaApprovedNo4HyattMullins$450.40OldenzaalSloveniaRejectedNo4RachelHead$166.15BautzenNauruBlockedNo7ShoshanaUnderwood$336.12Parkland CountyLiechtensteinBlockedNo2ColtKent$482.74JalgaonGrenadaApprovedYes3AmethystDunn$313.64DipignanoWestern SaharaApprovedYes9PlatoDuke$229.55ExeterIndiaBlockedYes1JaredDale$391.90BéziersMauritiusApprovedYes3LukeVang$375.44VorselaarJerseyBlockedYes1PhillipReed$431.70ChittoorChristmas IslandApprovedYes6BrandonLowery$213.54CorkChadRejectedYes1RafaelElliott$281.05Little RockJamaicaApprovedYes4LyleBlack$437.51MoldPalauRejectedYes6WendyRosa$219.66FortalezaEgyptApprovedNo7PriscillaDodson$414
.
83Polpenazze del GardaChristmas IslandApprovedYes1QuamarCrawford$465.99TreglioSurinameBlockedYes2ShadFlores$442.84VezirköprüGuyanaBlockedYes6LanaWheeler$202.64St. NeotsPalauRejectedNo1VannaFarmer$351.21MillportMaldivesApprovedYes9CadmanRay$352.24CheyenneSouth SudanBlockedNo7KimberleySavage$429.55MiamiVanuatuApprovedNo9ArmandSears$477.13Mussy-la-VilleSaint Vincent and The GrenadinesApprovedNo8SawyerVance$492.63DavoliBeninRejectedNo4TanekLyons$172.85Rocky ViewAfghanistanApprovedNo9NaydaHickman$295.47Newcastle-upon-TyneKiribatiBlockedNo3AileenWaters$202.47Idar-ObersteiSlovakiaBlockedYes3ForrestLarsen$269.64GulfportKorea, NorthBlockedYes3WillaKemp$239.89Somma LombardoWallis and FutunaApprovedYes2EugeniaByrd$466.08CaruaruNorthern Mariana IslandsRejectedYes8KatoBeck$396.49KhanpurSolomon IslandsApprovedYes2

Hiding table columns
Info
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.
Table Filter
hideColumns true
column Bank Account Number,Customer Status,Suspicious Transaction Activity
id 14412827709541e93cce7f63b88534c8ba89cee553d7e
First NameLast NameContact PhonesLast Transaction DateBank Account NumberTransaction amountTax AmountTarget Transaction CityTarget Transaction CountryCustomer StatusSuspicious Transaction ActivityTotal Transaction NumberReubenBarnett0500 00988812/14/14DO07819385109432271545550865$129.42$10.28GuápilesTunisiaBlockedYes8McKenzieCleveland07624 78537309/15/14CH6046131558340157475$216.75$46.19SavannahUnited StatesBlockedYes1PortiaLang(011247) 0442009/27/14EE967962637165872502$422.53$16.29MeerutCôte D'Ivoire (Ivory Coast)RejectedNo5EaganMcgee07212 43049209/19/14MK83589588636375406$253.03$26.26OrangevilleAfghanistanApprovedNo2RahimVelazquez0325 526 844012/31/14FO0682149824230550$454.06$27.73Lac-SerentGeorgiaApprovedYes6RothHull0500 31184410/11/14LU056987267796106873$142.57$14.14LuziâniaSao Tome and PrincipeBlockedNo4JackGriffin07624 30748809/04/14BA714509342088998370$146.60$34.55GeorgiaBahamasBlockedNo4FaithNewton0800 111109/24/14LU521764205226552485$324.96$24.60OkigweSri LankaRejectedYes1BasiaRay0346 983 834008/13/14TR280491289079508593611789$260.39$45.19ValcourtEquatorial GuineaRejectedYes4LeandraDuncan0359 889 682201/11/15CR0942393063075420342$380.33$34.57MySwazilandRejectedNo6

Space shortcuts

Page tree

Versions Compared

Old Version 49

New Version Current

Key

Table Filter

Table Filter and Charts for Confluence

Table Filter

Table Spreadsheet

Chart from Table

Pivot Table

Changing the width of the filter boxes

Hiding the filters

Fitting table to the screen area

Hiding table columns

numbering	true
column	Customer Status,Suspicious Transaction Activity,Target Transaction City
id	1441282770894fc02ae92d220e111df089cb784761aa7
limitHeight	true

hideColumns	true
column	Bank Account Number,Customer Status,Suspicious Transaction Activity
id	14412827709541e93cce7f63b88534c8ba89cee553d7e