I created a table in my confluence page to display new and closed issues. Now I want to sum the counts and put the total number in separated row, how can I achieve that in a table. Attached is a screenshot of what I like to setup in my confluence page. Please advise.
Hi @Lawrence ,
You may try the Table Filter and Charts for Confluence app.
Insert the Jira Issues macro and paste the required JQL (for example, issues that were created and issues that were closed during the last 30 days - it seems, that you need to do something similar).
To count the issues of both types, wrap the Jira Issues macro into the Pivot Table macro:
As a result, you'll get a dynamically changing summary table.
You'll be also able to visualize the table with the help of the Chart from Table macro if required. This macro also works with dynamically changing Jira Issues macro perfectly well.
Here are several examples of the Jira dashboards in Confluence created with the help od the Table Filter and Charts for Confluence app.
Hi @Lawrence ,
You should insert the Pivot Table macro first on the page, then put you mouse cursor inside the macro body and insert the Jira Issues macro.
So, the Jira Issues macro will be wrapped into the Pivot Table macro.
And, of course, you'll be able to enter their settings separately.
Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond. A long time favorite, Team Cale...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events