Staff Members Workload Report

This article is for Budgets for Data Center.

Staff Members Workload Report

The Staff Members Workload report presents the staff members workload by period and by roles based on the issues due dates. To access this report, click on the Report tab (or hit '6') and then click on the 'View report' button next to the Staff Members workload report preview. This will bring up the report with the today's date as the default start (From) and end (To) date.  The report will be automatically refreshed when one of its parameters changes.

This report is available for folios and portfolios



If an issue does not have a due date, Tempo Budgets will take the end date of the folio as a fallback.

The report first presents a bar chart showing a bar of assigned hours for each role or member grouped by period: color are automatically assigned based on the number of roles or members.  Hovering the bars will open a tooltip showing the precise assigned hours.  The dates labels on x-axis can be clicked to navigate to the detailed workload information for the period ending on that date.



Staff Members Workload Chart



Lozenge

Description

Lozenge

Description

Max. Effort

Total regular hours or capacity of the members based on their availability within the report's period.

Assigned

Sum of remaining estimates of issues that are not yet earned (done) and that are assigned to the members.

Available

Total available hours of the members. It is computed by subtracting the assigned effort from the maximum effort.
A negative value indicates an overload and the lozenge will turn red.

Issues

Indicate the total number of issues (including "at risk" and overdue issues) .

At Risk

Indicate the total number of issues considered "at risk".
Issues are considered ''at risk'' if their remaining estimate is greater than the time left until their due date.
Note: If at least one issue is at risk the lozenge will turn yellow.

Overdue

Indicate the total number of issues considered "overdue".
Issues are considered ''overdue'' if their due date is before the report''s start date.
Note: If at least one issue is overdue the lozenge will turn red.


Detailed period section

Detailed information for all periods follow the chart.  Each of these sections shows the list of roles, ordered alphabetically and grouped by roles and then by staff member.





















Column

Description

Column

Description

Roles

Roles

Name

Full name of the member. Hovering the name will show the "JIRA user popup" 

Max. Effort

Total regular hours or capacity of the staff members based on the availability within report's the period.

Assigned

Sum of remaining estimates of issues that are not yet earned (done) and that are assigned to the members within the period.

Available

Total available hours of the staff members. It is computed by subtracting the assigned effort from the maximum effort. A negative value indicates an overload.

Issues

Total number of issues (including "at risk" and overdue issues) within the period.
Note: You can view the detail list of issues by clicking on the number

At Risk

Total number of issues considered "at risk" within the period.
Note: You can view the detail list of issues by clicking on the number 

Overdue

Total number of issues considered "overdue" within the period.
Note: You can view the detail list of issues by clicking on the number



From/to

Period start and end dates.

Unassigned

Total remaining hours for issues that are not yet assigned to a staff member.



Since the issue scheduling of this report is based on the due dates, the remaining estimates issues may overlap multiple periods.




Issues panel



























Link

Description

Link

Description

Report parameter

Bring you back to report configuration

View in issue Navigator

Bring you to the JIRA issue navigator screen

Issue key

Clicking on the issue key bring you the JIRA Issue screen


Configuring the report

To change the period covered by the report, simply set the dates in the From and To fields to whatever dates you want.  The actual period considered will span from the latest of today's date and the date entered in From field. You can specify which frequency the report should use to break down the overall period. For example, selecting Monthly frequency will show you the workload broken down by calendar months. Select Total frequency to get the staff members workload for the whole period, with no break down. You can finally limit the workload considered to a certain number of roles and/or members.  Simply select/deselect the member you are interested in and the report will be instantly refreshed to reflect the new selection.  Selecting or deselecting a role will cause the list of available members to be updated accordingly. See the table below for detailed information about report parameters.

Staff Members Workload report parameters

Staff Members Workload report parameters details

Grouping By

  • Role: bars in the chart represent roles

  • Member: bars in the chart represent staff members

From

Start of the time frame for that report. The start date can be any date from today's date to any date in the future.
Note that clicking on today link set the report start date to today's date.

Start date

If the report start date is before today, the report start date will use today's date as start date.



To

End of the time frame for that report.

 Notes:

  • Clicking on folio end link to set the report end date to folio end date.

  • There is no end date limitation as for start date, therefore issues within the Folio's scope and with due date within the selected report end date are included

Display results by

This allows you to break down the information by week, 2 weeks, 4 weeks, Quarter, Calendar Year, or Fiscal Year. Total means no breakdown will occur; all issues for the selected period will be included in a single section. Note that report start date "day" will be the periods starting day. This means if your report start date is a Tuesday and the frequency is Weekly the report will display weekly expenses from Tuesday to next Monday. 

Roles

Roles to be included in the report

Members

Staff members to be included in the report

Account

This allows you to display amounts of all expenses/revenues and worklogs of issues link to the selected account.

Labels

This allows you to display amounts for the selected Jira Issue Label. (not available at the portfolio level)
Note : see Using Labels for more info on.



Printing the report

Selecting Printable in the report's action menu found at the top right of the report's parameters panel provides a printer-friendly version of the report.

Printable version of the report

































Exporting to Excel

The Staff Members Workload report can be exported to Excel format to give you all the latitude you need to further digest, analyze or graph the data. Do it by selecting Export to Excel item in the report's action menu found at the top right of the report's parameters panel. The parameters that were used to generate the report can be found on the second tab of the generated spreadsheet.

Excel export of the report