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-
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 :)