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

[Nidhi Prasad]

@Sebastian Brudziński : thank you for the answer. 
I have read about using Timesheet gadget. 
Would this be helpful in my case? 
Would I be able to single out assignee and tickets to know the time spent on tickets by a particular staff using time gadgets? 

[Sebastian Brudziński]

@Nidhi Prasadlikely yes, but it depends on which timesheet gadget you exactly mean. I'd also suggest looking at the price. All marketplace apps can be checked and trialed for 30+ days free of any costs, so you can pick any apps you deem worthy and select the one that works best for you after the trial.

Best,
Sebastian

[Nidhi Prasad]

@Sebastian Brudziński 

I was thinking of using this: https://jira.3-gis.com/rest/gadgets/1.0/g/jira-timesheet-plugin:timesheet-gadget/timesheet-gadget.xml 

And setting Show entries created by User and the Show Summary for Filter and trying to retrieve the time spent by a staff member on a particular ticket/bunch of tickets. 

And yes, we will have a look at the Marketplace as well. 

Thanks for the suggestion