Document toolboxDocument toolbox

Timesheet

Timesheet Report provides a timesheet table and a view of the worklogs in a structured form, summarized by Project, Issue and User. You can drill down on each level simply clicking on the rows on the left side of the table.



How to use



Create report

  1. You can select users or groups. By default, each user is selected.
  2. You can search by project, issue type, issue Status.
  3. You can add the start and end date of the interval with the Date Range Picker.
  4. You can select a hierarchy level and group the data according to it. The selected value always means the "highest" level:
    1. Project: The worklogs will be summarized by projects as the highest level. (default)
    2. Issue: The worklogs will be summarized by issues as the highest level.
    3. User: The worklogs will be summarized by users as the highest level.
  5. The query is executed after pressing the Create Report button. 
    1. (warning) The maximum reportable interval is 3 months (up to 100 days).

Drill down

The display and hierarchy of the worklogs will depend on the selected group by option. 

  • If Project is selected, the work logs will be summarized by projects as the highest level. (default)
  • If Issue is selected, the work logs will be summarized by Issues.
  • If User is selected, each work log will be displayed under user names.
  • The bottom level is the worklog level.

Display in the columns:

  • In the Project/Issue/User column, the following will be displayed: Project Key, Issue Key, User display name
  • In the Summary/Description column, the following will be displayed: Project name, Issue Summary, Worklog description

The table will first show only the data of the top level you have set. If you click on one of the rows (project, issue, user), it will drill down to the next level and display its data and worklogs.

For example:

  1. If you click on the cell of the project key (eg.: DEMO), the issues below will appear in the timesheet with the aggregated logged times.
  2. If you click on the cell of the issue, the users logging on to that issue will be displayed with the aggregated logged times.
  3. If you click on the cell of a user, the specific worklogs of that user will be displayed below each line with the descriptions.


Export



Excel or CSV

You can export the summarized data from this sub-page to Excel or CSV file.

The Export button will display a dialog where you can select the logged time export format where you can select the time format that appears in the exported reports:

  • Seconds: logged time will be exported in seconds (eg.: 1 hour = 3600)
  • Decimal: logged hours will be exported in decimal number format (eg.: 1 hour 30 min = 1.5h)
  • Default: logged hours will be exported in the configured time format in JIRAs Time Tracking settings (eg.:  Pretty = 1 hour 30 min)