Group by and Sum by using Database Fields

[Puneet Gupta]

Hello Experts,

I have a confluence database which is importing details from the Jira Issues. There are numeric fields in the Jira Issues, which are custom fields in Jira. Apart from this, I am importing Sprint field also from Jira.

I want to sum up the field value and group it for every Sprint.

How can I do that using the Confluence Database.

[Anne Saunders]

@Puneet Gupta If you're looking for subtotals by sprint, that's beyond me, and I think beyond the current database capabilities. 

Right now, you can count entries, values, and unique values, and you can calculate the percentage of empty or not empty, but that's it. Confluence Tables offer a little more, and some chart functionality, but I don't believe they are capable of the complex subtotal operation it sounds like you're looking for. 

I'd probably either rely on the Sprint Report in Jira Software or use the Jira add-on for Google Sheets or export a CSV to get the information into a full-featured spreadsheet product in order to do this kind of organization and math. 

[Puneet Gupta]

That is really surprising, then the name "database" is like a too much of a promise.

A database is supposed to do such minor mathematical calculations.

I hope Atlassian look into these capabilities in their "non-database" Confluence database before calling it a database :)

Is these any other way in Confluence, where I can pull jira issue information and then group and sub-total them, please suggest for an alternate without using any third party plug-in. Can Confluence basic tables do that?

[Anne Saunders]

I've never tried. I'm a spreadsheets kind of person 😅

You could insert a "/Jira work Items" (filter) macro per sprint and use JQL to get your sprint issues, then make sure your numeric columns are displayed, but those still don't do the math. 

[Thomas Pleli]

@Puneet Guptayou seem to me to be an advanced database user. Can you please explain how are you importing defined JIRA fields in certain cells in the database? Thank you.

[Puneet Gupta]

In Cloud version, there is an option to import JIRA Issue details.

[Thomas Pleli]

Great, thx