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