Report to calculate workload based on a customized field

[Dennis Chen]

Hi all,

I am now in a translation team. And we would like to use Jira for task tracking.

We have dozens of projects and our translators may work in several projects.

Unlike workload of software development, I customized a field called "Wordcount" to record how many words they have translated in this month. And by the end of this month, I need to create a workload report for all translators.

My questions is

1. Can Jira generate reports corss project? (As I have explained our translators may work in several project at the same time)

2. Can it calculate data based on a cunstomed field?(the "Wordcount" I set. I need to know who translate how many words in which project. It can be a task list or a sumed result) If not, you have have and apps to help created this kind of report?

Thanks a lot

[Darryl Lee · Accepted solution]

Hi @Dennis Chen - unfortunately Summing up data from issues is not a feature that is built-in to Jira. There's a very full answer to this question here:

• How to see the summed up value for a custom numeric field based on a specific Jira Ticket Status. 

In short - there's a feature request for this: https://jira.atlassian.com/browse/JRACLOUD-38111

And there's several apps you could purchase that provide "gadget sum" functionality:

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=gadget%20sum

h/t to @Andy Heinzer for the previous answer.

[Dmitry Astapkovich _Colined_]

Hello @Dennis Chen , 

We are developers of Pivot Report that allows you to report on issues from multiple projects and sum up values of any numeric and/or time field:

The report above is available as a demo here. No login required.  

[Dennis Chen]

Hi Dmitry, 

Thanks for your recommendation. Do you have any email or skype account that I can contact so that we can have a further discussion about my requirement?

[Dmitry Astapkovich _Colined_]

@Dennis Chen , sure thing: da@colined.com

[Rahul_RVS]

Hi @Dennis Chen 

Welcome to the community !!

For a readymade solution, to view custom field roll up and visualize your entire issue hierarchy, you can try out our plugin

Agile Tools : Epic Tree & Time in Status 

The app also provides sum up at each level for time spent and story points.

(Disclaimer: I work on RVS, the vendor for this app)