How to count whether a check box is selected when table is in table filter macro

[Barbara M Waxer]

Have a table with a col containing a Pass check box (task list from Edit toolbar) and Fail check box.

Table is in the Table Filter macro.

How do I do a simple count of the Fail check boxes?

[Tomislav Tobijas · Accepted solution]

Hi @Barbara M Waxer ,

Maybe the recommendation here would be to reach out to the app vendor through their support portal about this.

Native Confluence does not provide a built-in way to directly count the number of checked checkboxes (task list items) within a table. Potentially, you could use Confluence databases >  these do provide things like column 'calculations' and counts of empty or filled-in cells. 👀

Cheers,
Tobi

[Barbara M Waxer]

Hi Tomislav,

Thanks for the quick reply. Databases won't work, but at least it's good to know it wasn't the fault of my VERY basic SQL skills!

Barbara

[Anna Mitina _Stiltsoft_]

Hi @Barbara M Waxer ,

Thank you for the question.

I'm Anna from the Table Filter, Charts & Spreadsheets for Confluence app, which the Table Filter macro belongs to. 

Do you have separate columns for each checkbox, like in the example below? 

[Barbara M Waxer]

Thanks for getting back to me. 

To your question, no, I inserted two task list check boxes in the same col.

If creating a separate col would allow me to count the Fails, I'll do that in a heart beat.

[Anna Mitina _Stiltsoft_]

No worries, there's no need to separate those into two columns 😊

If you simply need to count how many "Fail" checkboxes you have, you can use our Pivot Table macro.

Namely, just wrap the existing Table Filter macro with the table inside the Pivot Table macro. And set the same settings as in the screenshot below. It should show you the exact number of "Fail" checkboxes.

Let me know if that helps 🙏🏼

[Barbara M Waxer]

Crushed it! Thanks so much. AND...of course my customer just changed the scope of UAT testing.

Different question, a bit more complicated.

I have several testers each testing the same use case on their individual Confluence page.

Is there a way for me to count the Fails as a roll up on that group of pages?

[Anna Mitina _Stiltsoft_]

You can merge their tables using our Table Excerpt and Table Excerpt Include macros. 

Simply ask the testers to wrap their tables inside the Table Excerpt macro and name them identically, e.g., UAT testing.

Then, either on a parent page or any other page, add the Table Excerpt Include macro, and under the "Excerpt name", type UAT testing. 

After that, you will have an aggregated table from which, with the help of the Pivot Table macro, you would be able to count the number of "Fail" checkboxes.

Let me know if you have any questions :)