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.
| Story ID | Story | Team | Sprint | Status | Estimate |
|---|---|---|---|---|---|
| ST-300 | Audit log filters 1 | Platform | Sprint 42 | To do | 3 |
| ST-301 | Sign-in throttling 1 | Web | Sprint 43 | In progress | 13 |
| ST-302 | Offline drafts 1 | Mobile | Sprint 44 | To do | 3 |
| ST-303 | Usage export 1 | Data | Sprint 42 | Done | 5 |
| ST-304 | Billing webhooks 1 | Web | Sprint 43 | To do | 2 |
Show all 64 rows
| Story ID | Story | Team | Sprint | Status | Estimate |
|---|---|---|---|---|---|
| ST-300 | Audit log filters 1 | Platform | Sprint 42 | To do | 3 |
| ST-301 | Sign-in throttling 1 | Web | Sprint 43 | In progress | 13 |
| ST-302 | Offline drafts 1 | Mobile | Sprint 44 | To do | 3 |
| ST-303 | Usage export 1 | Data | Sprint 42 | Done | 5 |
| ST-304 | Billing webhooks 1 | Web | Sprint 43 | To do | 2 |
| ST-305 | Search suggestions 1 | Mobile | Sprint 44 | In progress | 3 |
| ST-306 | Push settings 1 | Data | Sprint 42 | Done | 1 |
| ST-307 | Data retention job 1 | Platform | Sprint 43 | To do | 1 |
| ST-308 | Session timeout 1 | Mobile | Sprint 44 | To do | 5 |
| ST-309 | Saved filters 1 | Data | Sprint 42 | In progress | 8 |
| ST-310 | Dark mode polish 1 | Platform | Sprint 43 | To do | 8 |
| ST-311 | Import validation 1 | Web | Sprint 44 | Done | 2 |
| ST-312 | Rate limit headers 1 | Data | Sprint 42 | To do | 3 |
| ST-313 | Profile photos 1 | Platform | Sprint 43 | In progress | 5 |
| ST-314 | Release banner 1 | Web | Sprint 44 | Done | 2 |
| ST-315 | Warehouse sync 1 | Mobile | Sprint 42 | To do | 3 |
| ST-316 | Audit log filters 2 | Platform | Sprint 43 | To do | 13 |
| ST-317 | Sign-in throttling 2 | Web | Sprint 44 | In progress | TBD |
| ST-318 | Offline drafts 2 | Mobile | Sprint 42 | To do | 5 |
| ST-319 | Usage export 2 | Data | Sprint 43 | Done | 2 |
| ST-320 | Billing webhooks 2 | Web | Sprint 44 | To do | 3 |
| ST-321 | Search suggestions 2 | Mobile | Sprint 42 | In progress | 1 |
| ST-322 | Push settings 2 | Data | Sprint 43 | Done | 1 |
| ST-323 | Data retention job 2 | Platform | Sprint 44 | To do | 5 |
| ST-324 | Session timeout 2 | Mobile | Sprint 42 | To do | 8 |
| ST-325 | Saved filters 2 | Data | Sprint 43 | In progress | 8 |
| ST-326 | Dark mode polish 2 | Platform | Sprint 44 | To do | 2 |
| ST-327 | Import validation 2 | Web | Sprint 42 | Done | 3 |
| ST-328 | Rate limit headers 2 | Data | Sprint 43 | To do | 5 |
| ST-329 | Profile photos 2 | Platform | Sprint 44 | In progress | 2 |
| ST-330 | Release banner 2 | Web | Sprint 42 | Done | 3 |
| ST-331 | Warehouse sync 2 | Mobile | Sprint 43 | To do | 13 |
| ST-332 | Audit log filters 3 | Platform | Sprint 44 | To do | 3 |
| ST-333 | Sign-in throttling 3 | Web | Sprint 42 | In progress | 5 |
| ST-334 | Offline drafts 3 | Mobile | Sprint 43 | To do | 2 |
| ST-335 | Usage export 3 | Data | Sprint 44 | Done | 3 |
| ST-336 | Billing webhooks 3 | Web | Sprint 42 | To do | 1 |
| ST-337 | Search suggestions 3 | (blank) | Sprint 43 | In progress | 1 |
| ST-338 | Push settings 3 | Data | Sprint 44 | Done | 5 |
| ST-339 | Data retention job 3 | Platform | Sprint 42 | To do | 8 |
| ST-340 | Session timeout 3 | Mobile | Sprint 43 | To do | (blank) |
| ST-341 | Saved filters 3 | Data | Sprint 44 | In progress | 2 |
| ST-342 | Dark mode polish 3 | Platform | Sprint 42 | To do | 3 |
| ST-343 | Import validation 3 | Web | Sprint 43 | Done | 5 |
| ST-344 | Rate limit headers 3 | Data | Sprint 44 | To do | 2 |
| ST-345 | Profile photos 3 | Platform | Sprint 42 | In progress | 3 |
| ST-346 | Release banner 3 | Web | Sprint 43 | Done | 13 |
| ST-347 | Warehouse sync 3 | Mobile | Sprint 44 | To do | 3 |
| ST-348 | Audit log filters 4 | Platform | Sprint 42 | To do | 5 |
| ST-349 | Sign-in throttling 4 | Web | Sprint 43 | In progress | 2 |
| ST-350 | Offline drafts 4 | Mobile | Sprint 44 | To do | 3 |
| ST-351 | Usage export 4 | Data | Sprint 42 | Done | 1 |
| ST-352 | Billing webhooks 4 | Web | Sprint 43 | To do | TBD |
| ST-353 | Search suggestions 4 | Mobile | Sprint 44 | In progress | 5 |
| ST-354 | Push settings 4 | Data | Sprint 42 | Done | 8 |
| ST-355 | Data retention job 4 | Platform | Sprint 43 | To do | 8 |
| ST-356 | Session timeout 4 | Mobile | Sprint 44 | To do | 2 |
| ST-357 | Saved filters 4 | Data | Sprint 42 | In progress | 3 |
| ST-358 | Dark mode polish 4 | Platform | Sprint 43 | To do | 5 |
| ST-359 | Import validation 4 | Web | Sprint 44 | Done | 2 |
| ST-360 | Rate limit headers 4 | Data | Sprint 42 | To do | 3 |
| ST-361 | Profile photos 4 | Platform | Sprint 43 | In progress | 13 |
| ST-362 | Release banner 4 | Web | Sprint 44 | Done | 3 |
| ST-363 | Warehouse sync 4 | Mobile | Sprint 42 | To do | 5 |
- Edit a Confluence page and insert the Flint Table Filter macro.
- 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.
- 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
- Set Rows per page to 25. Pagination does not affect any of the totals below; the small page size makes that visible.
- 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
- Choose Summary and set Summarize column to Estimate.
- 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:
| Group | Rows | Sum | Numeric cells |
|---|---|---|---|
| Platform | 16 | 87 | 16 numeric |
| Mobile | 15 | 61 | 14 numeric · 1 blank |
| Data | 8 | 34 | 8 numeric |
| Web | 8 | 26 | 6 numeric · 2 unreadable |
| (blank cell) | 1 | 1 | 1 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
- In the grouped summary, choose Show rows: “Platform”.
- 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.
- Sort Estimate descending to put the largest stories first.
| Story ID | Story | Sprint | Status | Estimate |
|---|---|---|---|---|
| ST-316 | Audit log filters 2 | Sprint 43 | To do | 13 |
| ST-361 | Profile photos 4 | Sprint 43 | In progress | 13 |
| ST-310 | Dark mode polish 1 | Sprint 43 | To do | 8 |
| ST-339 | Data retention job 3 | Sprint 42 | To do | 8 |
| ST-355 | Data retention job 4 | Sprint 43 | To do | 8 |
| ST-313 | Profile photos 1 | Sprint 43 | In progress | 5 |
| ST-323 | Data retention job 2 | Sprint 44 | To do | 5 |
| ST-348 | Audit log filters 4 | Sprint 42 | To do | 5 |
| ST-358 | Dark mode polish 4 | Sprint 43 | To do | 5 |
| ST-300 | Audit log filters 1 | Sprint 42 | To do | 3 |
| ST-332 | Audit log filters 3 | Sprint 44 | To do | 3 |
| ST-342 | Dark mode polish 3 | Sprint 42 | To do | 3 |
| ST-345 | Profile photos 3 | Sprint 42 | In progress | 3 |
| ST-326 | Dark mode polish 2 | Sprint 44 | To do | 2 |
| ST-329 | Profile photos 2 | Sprint 44 | In progress | 2 |
| ST-307 | Data retention job 1 | Sprint 43 | To do | 1 |
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:
| Group | Rows | Sum | Numeric cells |
|---|---|---|---|
| Sprint 42 | 16 | 67 | 16 numeric |
| Sprint 43 | 17 | 99 | 15 numeric · 1 blank · 1 unreadable |
| Sprint 44 | 15 | 43 | 14 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
- Blank and unreadable cells are excluded from sums and averages, and the summary says how many.
- Currency symbols are ignored and percentages count as percentage points. If a column mixes plain numbers, currencies or percentages, the summary warns Mixed numeric units and adds them without conversion.
- Displayed values are rounded in your browser’s number format; ranking uses the unrounded values.
- Merged cells repeat their value in each covered row, so a merged estimate is counted once per row. See merged cells.
- The grouped summary shows 10 groups at a time; use Next groups for more.