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.
Hello, Thanks for taking time to answer.
I added page properties report macro, but did not understand how to get the total count i need. I do not want table rows to be displayed, as it is doing in page properties report. I just want the total count across lets say 20 different pages located under different parent page.
Let me elaborate my question. :
I have added a column for priorities in the table, and added 'status' macros in each row. and have added a 'countstatus' macro at the end of the table. Which gives me total count for the table. (thats all I want)
There are multiple pages across which I have implemented same thing. What I need now is a macro which will add up the total count across these pages all at once. Currently I have to go to each page and add the count manually.
Is there a way to use the page properties report macro for this purpose? if yes, then please guide me with steps.
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:
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.
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.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs