BlueConfetti

Guides / Flint Table Filter

FLINT TABLE FILTER · HOW-TO

Group table rows and calculate totals for a team review

Before planning, a team lead wants to know how much unfinished work each team carries. Group the table, total the estimates, rank the teams and drill into one, without copying anything into a spreadsheet.

What you will end with: 48 unfinished stories in 5 groups, ranked by total estimate with Platform first at 87 points across 16 stories. Totals cover all 48 matches, even though the table shows 25 rows per page.

Before you start

The Estimate column contains two TBD cells and one blank cell, so it is detected as Text. Summaries still read every cell that holds a number and report the rest, so you do not need to change the column type. One story has no team; it forms its own (blank cell) group.

Sample estimates: sprint-estimates.csv · 64 rows, 6 columns, fictional data.

First 5 rows
Story IDStoryTeamSprintStatusEstimate
ST-300Audit log filters 1PlatformSprint 42To do3
ST-301Sign-in throttling 1WebSprint 43In progress13
ST-302Offline drafts 1MobileSprint 44To do3
ST-303Usage export 1DataSprint 42Done5
ST-304Billing webhooks 1WebSprint 43To do2
Show all 64 rows
Story IDStoryTeamSprintStatusEstimate
ST-300Audit log filters 1PlatformSprint 42To do3
ST-301Sign-in throttling 1WebSprint 43In progress13
ST-302Offline drafts 1MobileSprint 44To do3
ST-303Usage export 1DataSprint 42Done5
ST-304Billing webhooks 1WebSprint 43To do2
ST-305Search suggestions 1MobileSprint 44In progress3
ST-306Push settings 1DataSprint 42Done1
ST-307Data retention job 1PlatformSprint 43To do1
ST-308Session timeout 1MobileSprint 44To do5
ST-309Saved filters 1DataSprint 42In progress8
ST-310Dark mode polish 1PlatformSprint 43To do8
ST-311Import validation 1WebSprint 44Done2
ST-312Rate limit headers 1DataSprint 42To do3
ST-313Profile photos 1PlatformSprint 43In progress5
ST-314Release banner 1WebSprint 44Done2
ST-315Warehouse sync 1MobileSprint 42To do3
ST-316Audit log filters 2PlatformSprint 43To do13
ST-317Sign-in throttling 2WebSprint 44In progressTBD
ST-318Offline drafts 2MobileSprint 42To do5
ST-319Usage export 2DataSprint 43Done2
ST-320Billing webhooks 2WebSprint 44To do3
ST-321Search suggestions 2MobileSprint 42In progress1
ST-322Push settings 2DataSprint 43Done1
ST-323Data retention job 2PlatformSprint 44To do5
ST-324Session timeout 2MobileSprint 42To do8
ST-325Saved filters 2DataSprint 43In progress8
ST-326Dark mode polish 2PlatformSprint 44To do2
ST-327Import validation 2WebSprint 42Done3
ST-328Rate limit headers 2DataSprint 43To do5
ST-329Profile photos 2PlatformSprint 44In progress2
ST-330Release banner 2WebSprint 42Done3
ST-331Warehouse sync 2MobileSprint 43To do13
ST-332Audit log filters 3PlatformSprint 44To do3
ST-333Sign-in throttling 3WebSprint 42In progress5
ST-334Offline drafts 3MobileSprint 43To do2
ST-335Usage export 3DataSprint 44Done3
ST-336Billing webhooks 3WebSprint 42To do1
ST-337Search suggestions 3(blank)Sprint 43In progress1
ST-338Push settings 3DataSprint 44Done5
ST-339Data retention job 3PlatformSprint 42To do8
ST-340Session timeout 3MobileSprint 43To do(blank)
ST-341Saved filters 3DataSprint 44In progress2
ST-342Dark mode polish 3PlatformSprint 42To do3
ST-343Import validation 3WebSprint 43Done5
ST-344Rate limit headers 3DataSprint 44To do2
ST-345Profile photos 3PlatformSprint 42In progress3
ST-346Release banner 3WebSprint 43Done13
ST-347Warehouse sync 3MobileSprint 44To do3
ST-348Audit log filters 4PlatformSprint 42To do5
ST-349Sign-in throttling 4WebSprint 43In progress2
ST-350Offline drafts 4MobileSprint 44To do3
ST-351Usage export 4DataSprint 42Done1
ST-352Billing webhooks 4WebSprint 43To doTBD
ST-353Search suggestions 4MobileSprint 44In progress5
ST-354Push settings 4DataSprint 42Done8
ST-355Data retention job 4PlatformSprint 43To do8
ST-356Session timeout 4MobileSprint 44To do2
ST-357Saved filters 4DataSprint 42In progress3
ST-358Dark mode polish 4PlatformSprint 43To do5
ST-359Import validation 4WebSprint 44Done2
ST-360Rate limit headers 4DataSprint 42To do3
ST-361Profile photos 4PlatformSprint 43In progress13
ST-362Release banner 4WebSprint 44Done3
ST-363Warehouse sync 4MobileSprint 42To do5
  1. Edit a Confluence page and insert the Flint Table Filter macro.
  2. Inside the macro, add a native Confluence table whose first row is a header row with the column names from sprint-estimates.csv, then enter or paste the data rows. If you paste from a spreadsheet, check that the result is an editable Confluence table rather than an image or an embedded file.
  3. Publish the page. Search, Filters, Sort, Columns, Summary, Export, Expand table and Reset view appear above the published table.

Step 1: Narrow to unfinished work

  1. Set Rows per page to 25. Pagination does not affect any of the totals below; the small page size makes that visible.
  2. Choose Filters, then Status. Set Condition to Is not one of and exclude Done. The count line reads 48 of 64 rows over 2 pages.

Step 2: Total and group

  1. Choose Summary and set Summarize column to Estimate.
  2. Set Group rows by to Team and Group order to Highest sum first. The numeric orders appear once a summary column is chosen.

The summary box reads All 48 matching rows, before pagination: sum 209, minimum 1, maximum 13, average about 4.64, from 45 numeric · 1 blank · 2 unreadable cells. The grouped summary reports 5 groups across 48 matching rows, before data pagination:

Team groups ranked by Highest sum first
GroupRowsSumNumeric cells
Platform168716 numeric
Mobile156114 numeric · 1 blank
Data8348 numeric
Web8266 numeric · 2 unreadable
(blank cell)111 numeric

Rows counts every story in the group; Sum adds only cells that hold numbers. Web has 8 stories but only 6 estimates, because two are TBD. Ranking uses unrounded values, groups whose sum is unavailable go last, and ties are ordered by group name.

Other orders answer other questions. Most rows first ranks by story count: Platform 16, Mobile 15, then Data and Web with 8 each. Group A to Z lists Data, Mobile, Platform, Web and finally (blank cell).

Step 3: Focus on one team

  1. In the grouped summary, choose Show rows: “Platform”.
  2. A banner reads Table and CSV focused on Team: “Platform” and the count line reads 16 focused rows · 48 matching before group focus · 64 total rows.
  3. Sort Estimate descending to put the largest stories first.
Expected result: 16 focused rows, Estimate descending
Story IDStorySprintStatusEstimate
ST-316Audit log filters 2Sprint 43To do13
ST-361Profile photos 4Sprint 43In progress13
ST-310Dark mode polish 1Sprint 43To do8
ST-339Data retention job 3Sprint 42To do8
ST-355Data retention job 4Sprint 43To do8
ST-313Profile photos 1Sprint 43In progress5
ST-323Data retention job 2Sprint 44To do5
ST-348Audit log filters 4Sprint 42To do5
ST-358Dark mode polish 4Sprint 43To do5
ST-300Audit log filters 1Sprint 42To do3
ST-332Audit log filters 3Sprint 44To do3
ST-342Dark mode polish 3Sprint 42To do3
ST-345Profile photos 3Sprint 42In progress3
ST-326Dark mode polish 2Sprint 44To do2
ST-329Profile photos 2Sprint 44In progress2
ST-307Data retention job 1Sprint 43To do1

The summary and group totals still cover all 48 matching rows, and a note says so. Focus uses exact, case-sensitive cell text, so “Platform” and “platform” would be separate groups. Choose Clear group focus to return to all teams. A focused view exports only the focused rows, which is useful for sending one team its list.

Step 4: Show subtotals in the table

Open Saved views and presentation and select Group rich rows with subtotals. Table rows follow the group order, each group under a heading such as:

Team: Mobile — 15 matching rows; Estimate subtotal: 61 (14 numeric). Totals cover the complete group across pages.
Team: Web — 8 matching rows; Estimate subtotal: 26 (6 numeric, 2 unreadable). Totals cover the complete group across pages.

When a group continues onto the next page, its heading repeats there with the same full-group totals. Headings and subtotals are display only; CSV and XLSX downloads contain data rows only.

Compare by sprint instead

Change Group rows by to Sprint and Group order to Group A to Z:

Unfinished work by sprint
GroupRowsSumNumeric cells
Sprint 42166716 numeric
Sprint 43179915 numeric · 1 blank · 1 unreadable
Sprint 44154314 numeric · 1 unreadable

Publish the review

An author can open the page on this grouped summary. Starting view preview reports 48 of 64 rows match and previews the first five groups.

Macro settings, shortened to the start of each label. One value per line where shown on separate lines.

Default filter column
Status
Default filter condition
Text: does not equal (ignores case)
Default filter value or lower bound
Done
Default rows per page
25
Default summary column
Estimate
Default group column
Team
Default group order
Highest sum first (requires a summary column)

Counting assumptions