How to make count of Merged Cell as One in Confluence Table

In the confluence table, as we can see, the pivot is based on the total number of rows.

But if I want to bring the stats based on Task POV into the pivot, how can that be done?

i.e.

Complete : 2
In Progress: 1
Pending: 1
Total: 4

2023-11-17 15_03_59-Q3023G Templates - Interact - Tenerity Confluence.png

1 answer

3 votes

For this case you need to count the number of unique tasks, so take the Table Transformer macro instead of the Pivot Table macro:

Fri 9-1.png

SELECT 'Status',
COUNT(DISTINCT 'Task') AS 'Number of Unique Tasks'
FROM T*
GROUP BY 'Status'

Fri 9-2.png

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.