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 custom fields value in confluence page from JIRA ticket

Mani Sundaram_8tn6fr

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:

|Login| 15|3|2|

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

Accepted answers

Katerina Kovriga {Stiltsoft}

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.

All comments

Katerina Kovriga {Stiltsoft}

Hi @Mani Sundaram

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

Mani Sundaram_8tn6fr

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_8tn6fr

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.

Mani 1.png You'll got smth like this:

Mani 2.png 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).

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

Mani 4.png

Welcome!

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

Quick Links

Find more posts tagged with

confluence

cloud