How to aggregate custom field values?

[Naoki]

Hi,

I have created a request type with a custom field to record the work time on an issue.

I want to aggregate the numbers entered into the custom field by organizations.

What is the best way to do this?

For example, below I would like to display “60” which is the sum of “organization-A”.

Thanks.

[Fazila Ashraf · Accepted solution]

Hi @Naoki 

Not possible in the issue navigator screen or out of the box without additional plugins.

Do you think it is worth effort to write an automation to fetch this value from all the context issues , sum up and display in the automation ?

Or you can simply export this to excel and perform the sum operation externally.

BTW, not sure why you chose a custom field but Jira has the timespent system field to capture logged work. If you have already analysed that and decided this approach for a reason, then ok :) 

[Naoki]

Hi @Fazila Ashraf 

Thank you for the response.

I understand that not possible without plug-ins.

I would like to consider introducing some kind of plugin.

Do you think it is worth effort to write an automation to fetch this value from all the context issues , sum up and display in the automation ?

YES! It is very valuable to me.

If you know how to do this, could you please let me know?

BTW, not sure why you chose a custom field but Jira has the timespent system field to capture logged work.

My client is using JSM and want to manage with JSM only.

I would like to tell my client that Jira is valid.

[Fazila Ashraf]

The automation  could be built something along the lines of this answer -> https://community.atlassian.com/t5/Jira-Work-Management-Questions/Help-Needed-Automation-Rule-to-Sum-Child-Issues-Fields-and/qaq-p/2707447

The log work feature is available in JSM as well. Check https://support.atlassian.com/jira-service-management-cloud/docs/log-time-on-an-issue/

[Naoki]

Thanks for the more detailed info.
I will check the contents and deploy customers.

[Marlene Kegel - codefortynine]

Hello @Naoki,

I am Marlene,  product manager of Quick Filters for Jira Dashboards.

Your use case is possible with our Jira cloud app. You could sum-up your custom field using the "Quick Issue Statistics" gadget. After you've installed our app, you simply 

• Add the "Quick Two Dimensional Filer Statistics" to your dashboard
• Select "Organizations" as field
• Select your custom field "production time" as "Value Shown"

You can check out Quick Filters for Jira Dashboards without installation on our demo dashboards. 

 

[Marc - Devoteam]

Hi @Naoki 

This is not possible ootb, you will require an app for this.

Apps like sum-up or custom charts can assist your.

Create a dashbaord in Jira and add the required gadget.

Also the BTW notice from @Fazila Ashraf is correct. Jira has time tracking ootb why use a separate CF?

[Naoki]

Hi @Marc - Devoteam 

Thank you for your help in suggesting specific plug-ins.