How to sum JSM spent time based on condition?

[Wong Zhao Cai]

I have a JSM project, where service desk can log in spent time for each request.

I am trying to find out some way to automatically sum the logged time for all request by month whenever a time is logged in...

So the questions are:

1. how to sum all request under same project?

2. How to sum based on condition, say, between 2 dates etc

[Jack Brickey · Accepted solution]

Hi @Wong Zhao Cai , natively there isn't a place to record data across issues, e.g. in a project field.  information. With that said, here is an idea for your consideration. You could create a top level task, used to record this sum of all logged time for the month. Then you could use automation to find all the issues where time has been logged, and some that up and place the value into a field (comment, description, custom field, etc) of your "summation" task. Not knowing how you wish to use the data it is hard for me to provide an exact solution. However, let's say that you just want to be able to record that information and review it or maybe even notify folks at the end of each month. In that event, I would create the automation rule to run at the end of each month or the beginning of the next month, and sum the values into a variable, which would be added into a comment, such as "The sum of all logged time for the month of September was {{sumvar}}."

The other option to consider would be to look at an add-on application. You can check the marketplace for this.

[Wong Zhao Cai]

Hi Jack, yes you are right, I am trying to get the time spent for each month as a record.In this case I still need to create a top level task in JSM? Sorry I am quite new to Jira, does top level task means a separated request in the queue? and thanks for your reply!

[Jack Brickey]

Yes. Or you could export to Excel/Sheets and sum using those apps.