Skip to main content
Become an Atlassian Knowledge Champion

Building team timesheets

Letzte Überarbeitung:

Overview

Worklog analysis allows you to view statistics on logged time over any customizable time period, grouping the data in several ways by many fields including cusom fields in Jira.

The Worklog analysis view: logged time per person and day for the selected period, with the total hours in the top right

It is possible to export the data in CSV, PDF and XLS formats.

To open the worklog analysis view, please click on “Worklog analysis” in the top right corner.

A team's tab bar with the “Worklog analysis” tab highlighted

By default, the work log analysis view represents the data grouped by Worklog author for the same time frame as you have seen on your team overview screen before switching to this view.

How to switch between different time frames?

To switch between the next and previous timeslots you can use <>

The arrows beside the period selector, which step to the previous or next time frame

How to display the data for a custom time frame?

  1. To apply any custom time frame, please click on the current time frame in the middle.
    The period selector in the middle, showing “This Month”, which opens the calendar when clicked

  1. You will see a small calendar pop-up with some templates on the left side.
    The period popup: a two-month calendar on the left and the predefined ranges — today, yesterday, this or last week, this or last month — on the right

  2. You can use any predefined time frame (today, yesterday, this or last week, this or last month) or apply any custom time frame.
    To apply a custom time frame, please click on start day.
    The calendar popup with the start day of the custom range selected

  3. After that please click on a date, which you would like to set as the last day of your custom time frame. By hovering you will see highlighted days and what your custom period will look like.
    The same calendar after clicking the end day, with the whole range outlined

  4. After clicking on the last day, the whole period will be highlighted in blue.
    The finished custom range, highlighted in blue across both months

  5. Please click outside the pop-up to see the data according to the new time frame.

How to change the default group option?

To apply any other group option, please

  1. Click on “Group by field”.

  2. After clicking on it, you will see the current hierarchy of group options with the button “+ Add a field”. Please click on the button.
    The “Group by field” selector (1) open, with the current grouping and the “+ Add a field” button (2)

  3. Find the necessary group option in the dropdown or type the group option name in the search field to find it faster.
    The search field of the grouping selector with the list of available fields

  4. Choose an option by clicking on it.
    Two grouping levels in place — worklog author and project — above the “Add a field” button

  5. You can drag and drop an option to order the list according to your needs.
    The same two levels reordered by drag and drop, project now first

  6. Click outside the pop-up to close it and see the statistics.

Please note, it is not possible to add more than five grouping levels. The “+ Add a field”-button will disappear after adding the 5th grouping option.

How to export the data?

To export the table, please click on the export icon in the top right corner and choose the necessary export format.

The export menu with the view options: sum subtasks, and the time tracking unit as pretty print, days, hours or minutes

After that, the file will be downloaded to a local path.

How to see additional work log details?

Some group options sum time and show the total spent per day.

For example, if you apply the following group option:

  1. Choose “Worklog author”

  2. Choose “Project”
    → This view will sum work logs added to the same day to the same project. To get more insights into the work logs, you can click on the respective cell.
    The analysis grouped by worklog author and project, with the time summed per day and one cell highlighted

  1. You will see the list of work logs that have been added to this day to this project.

  2. If you need any additional details, you can open the respective ticket by clicking on the issue link in the Issue column.
    The work logs behind that cell, listed with date, user, issue, description and logged time

Advanced table settings

You can switch between multiple time tracking formats or summarise subtasks by selecting the respective checkbox in the gear icon options, available in the top right corner.

The analysis grouped by worklog author and project, with the time summed per day and one cell highlighted
Discover our Apps for Jira and Confluence