Work log extraction by month

[Xavier DELAYRE]

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-]

Ηι @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_]

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.)

[Fabio Racobaldo _Catworkx_]

Hi @Xavier DELAYRE ,

welcome to the Atlassian community!

My personal suggestion is to use Tempo Timesheet plugin (https://marketplace.atlassian.com/apps/6572/tempo-timesheets-jira-time-tracking?tab=overview&hosting=datacenter). It is the best way to have useful reports about worklog in JIRA.

Hope this helps,

Fabio

[Xavier DELAYRE]

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