JQL to show total hours someone is scheduled in a day

[Jason Chayer]

I am needing to run a jql that shows total hours someone is scheduled in a given day. However, I have to run it off of a created field "Assigned PE technician". I am sure it is pretty easy, but for some reason I cannot think of the logic behind it.

[Florian Bonniec · Accepted solution]

Hi @Jason Chayer 

JQL, only allow you to return JIRA Issue. So what you can do it only to query all task due (or another field) this given day and assign to the person you want to report on, you can display the estimate of all of thoses tasks.

But JQL will not return a sum.

[Jason Chayer]

Yeah that is what I was afraid of. Estimates for a day do not give me what I need, because I do not estimate a task for the day, I estimate for the task. Thanks for the feedback.

[Florian Bonniec]

You can have a look to "rd party app for that such as

Tempo Planner, Activity Timeline, Big Picture

[Jason Chayer]

I use TeamBoard, which could show me what I need. The problem is that the assignee is a Team and I would need to build a filter to show a field that I added, Assigned Technician.

[Jason Chayer]

But because Jira cannot show planned time, I am stuck.

[Florian Bonniec]

I'm afraid that it only works by assignee not a customfield.

[Jason Chayer]

Thought so. Thanks!