It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

Umer Saeed Nov 18, 2016

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?

1 answer

0 votes
Andrey Khaneev Nov 18, 2016

Hello Umer,

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

Umer Saeed Nov 20, 2016

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 Nov 20, 2016

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

Thomas Ducett Apr 17, 2019

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

Andrey Khaneev Apr 17, 2019

Please, watch this video for details.

Thomas Ducett Apr 17, 2019

This is helping, if I can slow thi guys down, Lol. Only issue I have now is this message "Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro."

Thomas Ducett Apr 17, 2019

Thanks You have helped alot.

Andrey Khaneev Apr 17, 2019

Does it work correctly in your environment now? Or do you still see the "Oops, it seems that you need to place a table..." message?

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

913 views 0 19
Read article

Community Events

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

Events near you