nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Umer Saeed_do3hdc

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?

Accepted answers

All comments

Andrey Khaneev _StiltSoft_

Hello Umer,

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

Umer Saeed_do3hdc

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.

Thomas Ducett

I do not see detailed instructions on how Pivot tables work with JIRA filters. How can I find this?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

scriptrunner

cloud

macro

calculation