How do I report time worked within a time period using Jira Cloud for Sheets?

[dpalmer]

I am trying to pull a daily report of the time spent over the course of the month on any issues within a particular project. Basically, a custom time sheet.

Here is the query I used:

PROJECT IN (<project Name>) AND ISSUETYPE IN ("DevTask", "Sub-DevTask", "Sub-task", "Task", "Tech Spec", "Bug", "Sub-Bug") AND worklogDate > "2020/07/01" and worklogDate < "2020/07/31"

The fields I have turned on are "Key" and "Time tracking"

The report filters down to the issues that have had time logged to it during the specified range, but shows total time worked. I am hoping to report only the work logged within the specified range.

Any help that can be provided is appreciated.