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 Claspill · Accepted solution]

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.

[BenWade]

"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" - Yes, exactly. I was thinking it will show how many hours users logged  in the current month. I thought it will sum up the logged hours from here:

@Trudy Claspill  I want a JQL filter that will show only tickets with logged hours under the worklog section for the current month so that I can use this filter for a Workload pie chart, which sums up these hours for each user. Is this feasable?

I am fine with this layout. I just want it to show the correct total hours for each user. I want the filter to llok into work log section and sum up hours only entered in the current month.

[Trudy Claspill]

That is not possible with native functionality.

The filter returns issues, not work logs. It is giving you the issues that have time logged during the month. 

When you use that filter with the Work Load Pie Chart, the gadget is totaling all the time for the specified issues.

That gadget cannot be configured to total a subset of the work logs for the issues.