How do I track time spent by a staff on a monthly basis who is working on a partciular ticket?

Nidhi Prasad

For certain metrics, we need to show the time spent by a particular staff member who is working on a particular ticket on a monthly basis. 

What is the best/correct way to track this time spent? 

I have tried to use "worklogDate >= 2020-7-01 AND worklogDate <= 2020-8-01" as a part of the JQL , but this retrieves the time spent on that ticket since it was opened, It does not provide me the time spent only for the particular month. 

Example: Ticket A has been open since May. Person X has been working on it since May and has spent 10 min every month since May until July. 
I only want to extract the time spent by Person X on Ticket A for the month of July, i.e. I want a report/gadget that shows the 10 minutes thats spent. 
The JQL shows the time spent since it was opened even when I use the "worklogdate" and gives me the answer as 30 min (10 (may) + 10 (june) + 10 (july)

Sebastian Brudziński

Hello @Nidhi Prasad

Jira on its own is not really that good when it comes to more advanced time tracking or reporting hours for particular users. Your best call would be to consider a Marketplace app that extends Jira's time reporting capabilities, like our Worklogs - Time Tracking and Reports. The app allows you to easily select a user you are interested in, the date range, and get table-view report of the time spent. Here's how a sample report could look like, but you can highly customize it to your needs.

Best,
Sebastian