Getting time spent for a particular day

[Steven Yong]

I currently use this query to get time spent by each users on a particular day:

worklogDate = 2018-11-22 order by assignee

The problem I have with the query above is that it also returning total of time spent which is logged for other days because sometimes the users logged on the same day effort spent for different days.

For example when the above query returns:

Looks like 4 hours are spent but when I open that ticket, I see these:

How do I get effort spent just on the 22nd Nov?

How do

[Sreenivasaraju P · Accepted solution]

Hi @Steven Yong,

Query you are using will return the list of tickets on which time spent has been updated during the given period or date.  The time spent will show the total time (spent by single user multiple times and time spent by other yours also).But it will not segregate the user basis and date basis.

As per my knowledge, you can't the report out of box. You need to use some custom plugin like 

https://marketplace.atlassian.com/apps/294/timesheet-reports-and-gadgets?hosting=cloud&tab=overview

[Steven Yong]

Right, thanks Sreen. No big deal, I just need to manually splitting them, not ideal but we will survive with just 4 developers.