How do I count checkboxes in confluence table without hiding source table?

[정영환]

I read this previous question

https://community.atlassian.com/t5/Confluence-questions/Counting-checkboxes-in-Confluence-Table/qaq-p/1015198

but this doesn't help in my case since the pivot table automatically hides the source.

How can I count checkboxes without disturbing original table?

[Katerina Kovriga {Stiltsoft} · Accepted solution]

Hi @정영환 ,

You've found the right answer with the Table Filter and Charts for Confluence app.

What concerns your worries about the source table, the Pivot macro allows you to hide it (as was shown into the previous question).

If you need to show the source table along with your pivot, just tick the corresponding field in the Pivot macro settings:

If you need to visualize you result and have to wrap your table both in the Pivot and Chart from Table macros, then use the Table Toolbox macro.

Cloud editor has its limitations, so you'll be able to wrap you source table into one macro (for example, Source Table <- Pivot), but you'll need the Table Toolbox to use more than one macro wrapped into each other (Source Table <- Pivot <- Chart from Table).

Here is an example of checkboxes' counting and visualization with the help of the Table Toolbox macro: https://community.atlassian.com/t5/Confluence-questions/Percent-complete-for-Confluence-task-list/qaq-p/1595470