Sum custom fields value in confluence page from JIRA ticket

[Mani Sundaram]

my JIRA project ticket have below custom attributes 

Passed: 

Failed: 

Blocked: 

we want to sum up the custom field with JIRA ticket's fix version/label and show the status in a confluence page 

Ex: 

WOW-1001 - Label=Login

Passed: 10

Failed: 0

Blocked: 0

WOW-1002 - Label=Login

Passed:5

Failed: 3

Blocked: 2

In the confluence page, we want to show like the below table: 

|Module |Passed |Failed| Blocked |

|Login| 15|3|2|

Note: is there a way to do this without paid add on? 

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Mani Sundaram

It is not possible to perform calculations and create pivots in Confluence out-of-the-box.

We can recommend you to check our app - Table Filter and Charts for Confluence. It works with the Jira Issues macro perfectly well, and you'll be able to filter your issues, make pivots and even visualized dashboards.

[Mani Sundaram]

thank you @Katerina Kovriga _Stiltsoft_ , will give a try on this addon in confluence and let you know if I need any details 

[Mani Sundaram]

Hi @Katerina Kovriga _Stiltsoft_

I am seeing an issue with Jira Macro

Jira Issue Macro Example: project = XXX AND Labels in (LABEL1, LABEL2) and adding up the needed columns to display from Display Options.

Is it possible to wrap this Jira Issue Macro in the table filter? If yes, can you share how to perform it/steps?
Note: I'm unable to copy the output of Jira Issue Macro

[Katerina Kovriga _Stiltsoft_]

For the Cloud Confluence instances use the Table Toolbox macro to nest several macros. You won't be able to do it manually because of the Cloud editor limitations.

Insert the Table Toolbox macro on your page and then insert the Jira Issues macro right into its body.

You'll got smth like this:

Now go to the Table Toolbox settings - there you'll see your Jira Issues macro. Drag and drop the icons on the left and wrap your Jira Issues macro into one or several macros of our app (it depends on your use case).

Then go to the macro settings (for example, the Table Filter macro as is shown in the picture below) and implement your case.