nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to create a summarize table based on columns of a table in confluence?

unknown

I have a table like this

and I want a small summarized pivot table like shown below based on the above table :

How we can achieve this via confluence ? Is there any macro for this ?

Accepted answers

Katerina Kovriga _Stiltsoft_

Hi @[deleted],

There are no such macros out-of-the-box, you'll need some additional apps to complete your case.

In this thread I suggested using our app - Table Filter and Charts for Confluence (it seems that it was also your question judging by the username).

And here is another bunch of screenshots for you: wrap your table into the Table Transformer macro.

Mon 2-1.png

Mon 2-2.png

SELECT "Summary" AS '',
SUM(IF(T1.'Column A' = "Yes", 1, 0)) AS 'Column A Yes',
SUM(IF(T1.'Column A' = "No", 1, 0)) AS 'Column A No',
SUM(IF(T1.'Column B' = "Yes", 1, 0)) AS 'Column B Yes',
SUM(IF(T1.'Column B' = "No", 1, 0)) AS 'Column B No',
SUM(IF(T1.'Column C' = "Yes", 1, 0)) AS 'Column C Yes',
SUM(IF(T1.'Column C' = "No", 1, 0)) AS 'Column C No'
FROM T1

Mon 2-3.png

Mon 2-4.png

Hope this helps.

All comments

Katerina Kovriga _Stiltsoft_

Hi @[deleted],

There are no such macros out-of-the-box, you'll need some additional apps to complete your case.

In this thread I suggested using our app - Table Filter and Charts for Confluence (it seems that it was also your question judging by the username).

And here is another bunch of screenshots for you: wrap your table into the Table Transformer macro.

Mon 2-1.png

Mon 2-2.png

Mon 2-3.png

Mon 2-4.png

Hope this helps.

unknown

Excellent answer @Katerina Kovriga _Stiltsoft_ . Thank you very much.

Katerina Kovriga _Stiltsoft_

@[deleted] And here is another more precise SQL query for your case:

SELECT "Yes" AS 'Count',
SUM(IF(T1.'Column A' = "Yes", 1, 0)) AS 'Column A',
SUM(IF(T1.'Column B' = "Yes", 1, 0)) AS 'Column B',
SUM(IF(T1.'Column C' = "Yes", 1, 0)) AS 'Column C'
FROM T1
UNION ALL CORRESPONDING
SELECT "No" AS 'Count',
SUM(IF(T1.'Column A' = "No", 1, 0)) AS 'Column A',
SUM(IF(T1.'Column B' = "No", 1, 0)) AS 'Column B',
SUM(IF(T1.'Column C' = "No", 1, 0)) AS 'Column C'
FROM T1

Mon 2-5.png

Now you don't need to transpose tables and your result table is neat and easy to read.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud