Report needed: Hours worked per epic & defined time

[Hans-Hermann Hunfeld]

Dear all,

i need a report where the worked hours of one single user (or user group) per week (or another defined period) are summed up per epic (or component).

Unfortunately the timesheet report lists only on issue level und does not sum up according to any issue attributes. The only way i actually know is to export this report into Excel and add some formulas, but this is not very smart...

Any ideas what to do?

THX & regards,

Hans-Hermann

[TylerA · Accepted solution]

Since Reports are static (in the sense that they only let you change certain items, if that much) and adding a custom report is a restricted function in OnDemand (as it would be a custom plugin), your best bet would be to use the JIRA REST API to grab the worklog data for each epic/user/etc and then parse the output accordingly.

If you're inclined to whip-up a script, we have a python client already available to speed that process.