Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Work log extraction by month

Xavier DELAYRE
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 14, 2022

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.

 

 

3 answers

0 votes
Alex Koxaras -Relational-
Community Champion
October 16, 2022

Ηι @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.

0 votes
Aron Gombas _Midori_
Community Champion
October 14, 2022

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:

jira-cross-project-worklog-report-pivot-table.png

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

0 votes
Fabio Racobaldo _Herzum_
Community Champion
October 14, 2022

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 14, 2022

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

Suggest an answer

Log in or Sign up to answer