Work log extraction by month

Question

Hello,

I would like to get an extract of the work logged by month by issue.

I mean not the total, ie the time spent, but really the work logged during the current month or a specific month.

I have tried many query but the only criteria I found is "timespent" and it returns the total amount of work logged on the issue.

Thanks for your help.

Alex Koxaras -Relational- · Answer

Ηι @Xavier DELAYRE and welcome to the community,

In order to get what you want, you have unfortunately to use an app. Otherwise it's either what Jira provides to you via JQL, or you could use REST API to get the JSON values, and then pass them on excel and then do manual work.

Aron Gombas _Midori_ · Answer

There are multiple report type apps for Jira, because its built in reporting capabilities are limited.

You could export the worklogs to Excel and use pivot tables to group those by issue and by the year/month using a simple pivot table like this:

It was created by the Better Excel Exporter app, see more samples files.

(Disl. it's a paid and supported app, developed by our team.)

Xavier DELAYRE · Answer

Hi Fabio,

Thanks for your quick answer but unfortunately I cannot install any plugin in my organisation.

I was more looking for a build in query if any.

Xavier