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_qysy8m

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