Monthly Time tracking

BenWade

Hi everyone,

I cannot figure out how to see the total logged hours per user at the end of the month.

I need a report/table that looks something like this:

How can I achieve it without third-party apps?

 

Logged hours - January

Assignee                Story/Task                              Hours logged

Max                        Create new KPi                                50

PS

Cloud - Jira Premium


Could someone also tell em what is wrong with this JQL? Why does it show the wrong total hours logged?
issuetype in (Sub-task, Feature, Task, Initiative, Theme, Story, Epiс) AND timespent > 0 and worklogDate >= startOfMonth() and worklogDate <= endOfMonth()

I am trying to apply this filter in Workload Pie Chart Report- ->Time spent

Trudy P Claspill

Hello @BenWade 

You cannot create the time report you want with native Jira functionality in the UI. You might be able to use the REST API to extract the data and make a report from it outside of Jira. But if you want something available in the UI, you'll have to use a third party app.

Regarding your JQL can you provide more details about how the total is wrong? If you are trying to get the total of time logged in the month, that query doesn't do that. That query gives you a list of issues where time was logged during the month. It doesn't give you a list of the specific time log entries for that month. The Workload Pie Chart will report on the total time on those issues. It doesn't report on only the time logged within the month.