Sum of Totals in Confluence Table Based on Jira Filter Macro!

[Umer Saeed]

This is a very unique and weird request. I can't find anyone who has asked this before.

I have a confluence table that has rows and rows of data, which are dynamically populated by the JIRA Filter Macro. With this macro, I have selected 'Total Issue Count'.

In another column of the same table, I would like to add in a calculation of those totals, whether its a sum or a percentage of the values.

Screenshot: http://screencast.com/t/ZJi1kHoW9

Any plugins or possibilities of this being possible? Not sure if ScriptRunner has the power to do this?

[Andrey Khaneev [StiltSoft]]

Hello Umer,

You can try Pivot Table macro from Table Filter and Charts add-on.

[Umer Saeed]

Thanks for your recommendation. But this add-on seems to only do calculations based on values that were manually added into a table - not macro generated issue count based on JIRA filters.

[Andrey Khaneev [StiltSoft]]

Pivot Table macro works with JIRA Issues macro as well as with common tables.