Jira Workload pie question

[Iro Karavasili]

Hello all,

We need to identify the time a team spends on specific Epics in a specific time frame.
We use the following filter:

worklogAuthor in (username1, username2) AND issueFunction in workLogged ("after 2019-01-01 before 2019-12-31")

which we use for a Workload pie
with Statistic Type : Epic Link
time field to report on: Time Spent

However this filter brings the total time spent for the Epic (including hours logged outside of the team and outside the defined time frame)

Is there another gadget we could use or one that could eliminate the above "noise" in the query?

Thank you,
Iro

[Catherine Chang]

Hi there! I'm the PM on Jira Cloud for Google Sheets, and we're working to make this easy. Check out this post to see how you can import all of your worklog data into a spreadsheet with just a few clicks! Hope this helps!