How to create a time aggregation report by Labels in jira datacenter

[Namrata Bhomkar]

Hi Team,

We are using jira Data Center  and we need to build a dashboard report that shows only aggregated time values, not a list of issues.

Our requirement is:
We want to display:

• Total Original Estimate

• Total Time Spent

• Total Remaining Estimate

And additionally, we want these totals grouped by Labels, for example:

Label	Total Estimate	Total Time Spent	Total Remaining
security	95h	44h	51h
infra	40h	30h	10h

We already have a working filter like: project = "Playground Project" AND labels = security

However:

• We do not want an issue list

• We only want the aggregate values
  
  

Questions:

1. Is it possible in native jira datacenter to:

   • Perform SUM aggregation of time fields (Original Estimate, Time Spent, Remaining)

   • And group these aggregates by Labels in a single gadget or report?

2. If not natively possible, what is the recommended approach or supported plugin to achieve this cleanly?

3. Is there any gadget that can show only total values (without listing issues)?

At the moment, the Filter Results gadget only provides overall totals and not label-wise grouping, and Two-Dimensional Statistics only shows counts, not time-based sums.

Any guidance on the best-practice solution for this requirement would be highly appreciated.

Thanks in advance

[David Nickell]

I have done something like this for a client previously using the REST API and Power BI (I've done this kind of thing "on-premise" and "cloud" before -- but admittedly not Data Center)

Once you have the worklog data, if you are willing to use Power Bi (or some other BI Tool), you should be able to slice/dice/aggregate all you want.

This client in particular had reports by Buisiness Unit, Sprint, Initiatives etc... as well as detail at the ticket or individual as needed

If you'd like to discuss something like this, let me know.  (note -- this may look like ticket level -- but its actually at the hierachy of EPIC and Initiative.  Bottom left of the 1st screen shot shows the numbers by Business Unit)

[Danut M _StonikByte_]

Hi @Namrata Bhomkar,

Unfortunately, this isn’t possible using Jira’s native gadgets. The best solution would be to look for an app (plugin) on the Atlassian Marketplace that provides this functionality.

If you’re open to trying an app, I can recommend some of the gadgets offered by our Great Gadgets app.

Advanced Issue Filter Formula gadget - can apply a math formula (like SUM, COUNT, AVERAGE, etc) against the fields from up to 9 filters. It will work for you, if you don't have many labels - one gadget will cover 3 labels. 

To get this, the gadget must be configured like this:

Pivot Table & Pivot Chart gadget - Can calculate the sum of Original Estimate, Time Spent or Remaining Estimate and split it by labels (unlimited), but it can only calculate by one field; so you will need 3 gadgets side by side. 

To get this, the gadget should be configured like this:

 

Hope this helps.

Danut

[Rilwan Ahmed]

Hi @Namrata Bhomkar ,

Answers to your queries:

1. Is it possible in native jira datacenter ?

• No

2. what is the recommended approach or supported plugin to achieve this cleanly?

• EazyBI for Jira
• ScriptRunner  -- Create scripted fields and add them to required gadgets in the dashboard

3. Is there any gadget that can show only total values (without listing issues)?

• Try "Custom Charts for Jira"

[Ilze Leite-Apine - eazyBI]

Hi @Namrata Bhomkar 
Thank you, @Rilwan Ahmed, for suggesting eazyBI!

Indeed, the eazyBI Reports and Charts for Jira app allows you to get totals, subtotals, and detailed issue information by most Jira fields, including labels.

The report might look the follows:




Here is a real-time video on how to achieve such a report and also how to drill into issue level from total values: How to create hours report by labels 


Ilze

support@eazybi.com