This article explains how to see how many work items were assigned to each person in each month, using the ANY FIELD COUNT PER TIME-PERIOD report in Timepiece - Time in Status with the Assignee field and the Sum option.
The report counts every work item each person was the assignee of during each month, including work items that were reassigned to someone else before the month ended. This gives you a clear view of how the workload is distributed across your team and how it changes over time.
Scenario
Your team works on Jira work items, and each work item is assigned to a person through the Assignee field. As work progresses, work items are often reassigned from one person to another.
You want to see how many work items each person handled every month.
Why the Current Assignee Is Not Enough
Workload reports based on the current Assignee value show only who holds the work items today. A work item that was reassigned during the month is attributed only to its last assignee, so the effort of the people who handled it earlier stays hidden. Counting these assignments manually from work item histories, person by person and month by month, is time-consuming.
How Timepiece Helps
The ANY FIELD COUNT PER TIME-PERIOD report in Timepiece can be used for this purpose.
When Assignee is selected as the History Field and the report is displayed with the Sum option, the report shows a single row with combinations of assignees and months as columns. Each cell shows how many work items the corresponding person was the assignee of during that month.
Setting Up the Report
-
Open the Timepiece reporting page.
-
Select the project containing the work items.
-
Switch to the ANY FIELD COUNT PER TIME-PERIOD report type.
-
Click the History Fields button.
-
Select Assignee as the History Field.
-
Click Apply.
-
-
Click the List button.
-
Select Sum in the Show report as dropdown.
-
Leave the Group By fields empty.
-
Select Month as the Time Period.
-
Click Apply.
-
-
Click the Columns button.
-
Select the people you want to include as columns. (You can leave this selection empty to include all assignees.)
-
The empty value (“-”) represents the periods when work items were unassigned. You can leave it out to focus only on assigned work items.
-
Click Apply.
-
-
Set the start and end dates for the period you want to analyze.
With these numbers, you can see how the workload is distributed across your team, spot people who handle more work items than others, and follow how the workload shifts from month to month.
If a work item is assigned to the same person more than once, it is counted more than once. Additionally, if a work item remains assigned to the same team for multiple months, it is counted in each month.
Switch to the Time-Period Count per Any Field report type to display the same data with months as the top-level columns. This way, all assignees for a given month appear side by side, which makes it easier to compare them.
Additionally, if you want to see the total time work items spent with each assignee each month, you can use the Any Field Duration by Time Period report with the Assignee field selected.
For more information about this report type, see Report Types.