TimeSpent daily displayed in C3 java chart is different then actual logged work and TimeSpent
Requirement:-
I am trying to produce a graph for timespent daily using C3 java chart using below query and graph against Time Series Field (None - Sum of Existing Issue)
JQL Query: project = <projectname> AND SPRINT in openSprints() AND ISSUETYPE in (Sub-task, Story, Task, Epic, Bug) AND worklogAuthor in (<Tester>) AND status was IN ('TO DO','IN PROGRESS','ON-HOLD','ReJECT','DONE')
Please Note:– ProjectName and Tester are different in actual query
Problem:- I do not have any entry for 12-Jul-2020 as visible in ExportResult below generated using same JQL query from filter tab but the graph shows entry of '2hrs' by user-Tester. See GraphResult Image.
I understand Time Series field uses 'During' operator, is it something to do with that?
Why there is a discrepancy on dates however the total timespent so far is correct. Also I am getting a cumulative figure of timespent, can I get timespent on daily basis.