Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Resource's estimated and available time


I want to create a report with following data-

Monthly available time: (Daily work hours * Monthly workdays)- Monthly leave hours for each particular resource

Total estimated hours: SUM(Original Estimation) of all issues assigned to the resource to complete within the month

Total Logged hours: SUM(Logged hours in Tempo) within this month against assigned issues to that resource

Remaining hours: Total estimated hours - Total logged hours

Remaining total available hours: Monthly available time - Total estimated hours

The sample looks of the report will something like as follows-

Jira report.png


I want to create this report so that at a glance I can see -

  • How much workload a particular resource has within a particular month
  • How much time already spend by a particular resource within that month 
  • Resource availability status within a month

This report will help me to make decision quickly regarding resource allocation.

I am trying to create a JQL query, but I am not getting all fields especially Daily Work hours, Monthly workdays from Tempo worksheet, Tempo Issue Logged in tempo etc.


Is there any way to retrieve all those data using JQL or any other way?

Please help- I need this very urgent.


Thanks in advance :)

0 answers

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events