How to sum the counts on different rows and display it in a seperate row?

Lawrence_j3cpev

Hi,

     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.

Thank you,

Lawrence

Katerina Kovriga {Stiltsoft}

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.