How to simply extract worklog SUM during Only Specific date Period

[Taeseok Ou]

I have an requirement to mange vendor efforts spent every Month.

In Jira Filter list, when I extracted simply , it just give me each issue's Sum of Time spent so far for each issue, However, In case I want to extract Sum of WorkLog entered by each Person For Only specific Period(for e.g, only 2021.Feb) instead of Total time spent of each issue, How can I do it? It would be great if anyone can give a tip using a standard JIRA function like Filter List instead of programming or JSQL complex for this.

[Mariana_Pryshliak_Saasjet · Accepted solution]

Hello @Taeseok Ou 

Unfortunately, I can't help with logging but as an alternative, you can try a third-party add-on - Time in Status for Jira Cloud. It generates 7 types of reports based on statuses.

Time in Status report shows you how long each issue has been spent in each status.

Assignee time report how long each person has been assigned to issues. 

So, you just need to choose the date ranges you need and get a report of all issues and how much time has been spent to solve them. Extract a report as XLSX or CSV files for further analyzing Excel or Google Spreadsheets.

I hope, you find it helpful.

Best regards, Mariana

[Jakub Sławiński]

Hi @Taeseok Ou 

you should try one of the available apps from the marketplace: https://marketplace.atlassian.com/search?query=worklogs

[Alexander Eck [Tempo]]

Hi @Taeseok Ou ,

there is not a feasible way to do that with native Jira. So you would always need a 3rd party add-on like Tempo Timesheets or Timesheet reports and gadgets.

BR