How to add 'countstatus' macro to get total count from multiple pages?

Question

I have more than 10 pages where I have added 'countstatus' macro. It would be great help if i could get a total count all at once, which would save a lot of time I spend by going to each page and add all status counts.

A solution would be a great help.

PS: I am completely new to confluence. And I am still learning, a detailed solution with steps would be most helpful.

Andrey Khaneev _StiltSoft_ · Answer

Hi!

Pivot Table is from an add-on Table Filter and Charts. If you have any questions, feel free to ask.

Nikhil Subhash More · Answer

Hi. Thanks again for the reply.

That video was really helpful. I tried to use the page include macro. It almost worked. But I came across an issue / bug. Though I think I can workout a solution with the help of information you have provided.

I will try out few different things. I didn't know there is so much we can do with macros. I don't know if we have full access to these macros. I couldn't find pivot table macro. Will check what add-ons we have.

Andrey Khaneev _StiltSoft_ · Answer

Hello Nikhil,

First of all you need to aggregate all your statuses from different pages in one place to be able to count them. So you can use:

* Page Include macros to include different pages to the main page.
* Excertp and Excerpt Include to include pages partially.
* Page Properties Report if it shows all rows with statuses.

Then you can try to use countstatus macro to calculte count (I'm not aware of this macro). If this mocro doesn't work in this case, you can use Pivot Table (Table Filter and Charts add-on) macro to count statuses: wrap Include macros or PPR macro with Pivot Table like in this video.