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

[Anish Shah]

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 

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Anish Shah,

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

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