How to create a sub-sum according to each business team in one table

Kristina
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 21, 2024

Hi!

 

I have created a report with multiple business teams, issues created by epic and annualised and quarterly bookings - this is all in one table report. There's a possibility to put a TOTAL sum of all business teams at the end of the table (for the rows and columns, I need only for the rows) but is it possible to create a sub-sum as well for each business team? Like business team 1 ....20 issues ...xy bookings and sub-sum of this one business team and then another one, repeat the same.

I was trying to find it but really struggle with it.

Thanks!

2 answers

1 vote
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 21, 2024

Hi @Kristina ,

welcome to the community!

I wonder what view you're currently operating in - is this one of Jira's standard reports?

 

Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 21, 2024

On another note: Just reading through your requirements, I was thinking that the Marketplace app that my team and I are working on - JXL for Jira - might be a great fit for you.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view like this in just a couple of clicks:

team-report.gif

That this is just one of a virtually endless number of views - you can also group by any other issue field(s), configure different sum-up styles, use issue hierarchies, etc. etc.

Any questions just let me know!

0 votes
Danut M _StonikByte_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 21, 2024

Hi @Kristina ,

An easy way would be to use the Advanced Issue Formula gadget offered by our Great Gadgets plugin to display the numbers on a Jira dashboard or Confluence page. 

image.png

This gadget can apply from simple (SUM, COUNT, AVERAGE, etc) to complex math formulas against the issues from up to 6 filters. 

Hope this helps.

Danut.

 

 

 

Kristina
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 26, 2024

Hi! Thanks for your answer, actually, what I need is to have in one table sub-sums of those teams as one table contains: rows are the teams and columns are number of issues creates and bookings and we need for each team to create a sub-sum of those issues and bookings in one table.

Currently, it shows only the total sum of all teams at the bottom of our table.

So can this gadget apply sub-sums of each team in one table as well? As I need it to be in one table as a summary.

I am a newbie in this so I am still learning.

Thank you!

Suggest an answer

Log in or Sign up to answer