Use Timesheets and Reports



 

View a Timesheet

To view a timesheet go to Apps > Clockwork from the main Jira menu and click Timesheets in the left nav bar.

A tool bar at the top of the page will allow you to set filtering options and preferred formatting. You can also perform additional functions such as adding worklogs and/or refreshing the page to capture additional work logged; or downloading a time sheet as an Excel sheet.

Filter Options

  • Time frame

  • Projects

  • Users

  • Issue Types

  • Issue Keys

  • Custom Fields

Formatting Options

  • Time zone

  • Time period (days or weeks)

  • Time format (HH:MM, hours, minutes)

  • Breakdown by:

    • Users

    • Projects

    • Components

    • Affects Versions

    • Fix Versions

    • Issue Types

    • Epics

    • Issues

    • Worklogs

    • Billable

    • Tags

    • Custom fields

Additional Functions

  • Refresh the page

  • Download timesheet

  • View in issue navigator

  • Compare against working hours

  • Add worklog



Using custom fields in timesheets:

Clockwork gives you multiple options for filtering and breaking down your timesheets, including custom fields. However, there are some limitations. Currently, you can include the following custom field types in your time sheets:

  • Checkboxes

  • Labels

  • Number field

  • Radio buttons

  • Select list (cascading)

  • Select list (multiple)

  • Select list (single)

  • Short text (plain text only)

  • URL field

Jira Service Management custom fields:

  • Organizations

 

The example below shows a timesheet filtered for the current week and a single user, broken down by issue type:

If you are filtering for issues, the issue summary may be truncated. Hover over the summary to see the entire summary text.

View My Work / View Calendar

A user can view their current timesheet by selecting Apps > Clockwork from the main Jira menu and clicking My Work in the left nav bar. In Clockwork Pro, users have the option of viewing their worklogs as either a timesheet or a calendar.

Note that if work is logged on an incorrect date/time, it can be dragged to another time slot. Clicking a time slot will open a window allowing the user to create a new worklog.

 

 

To view another user’s calendar report, navigate to Apps > Clockwork from the main Jira menu and click My Work. Click on the user icon in the upper, left corner. Begin typing the name of the user whose calendar you wish to view. A user picker will open. Select the appropriate user.

Filter for Inactive Users

To view a timesheet for a users who is no longer active (deactivated in Jira), select a timeframe in which the users logged work.

Compare Worklogs and Working Hours

Clockwork allows Working Hours to be set at a global, project, or user level. When working hours have been set, Clockwork can compare those hours to the total hours reported in worklogs to highlight if users are working more, or fewer hours than expected. If the sum of hours worked differs from the expected amount by more than an hour, the hours will be indicated in orange text on the timesheet.

To enable this, click on the Compare time reported button. You must also ensure that the Users is the first breakdown option selected for the timesheet/report.

Total hours that are more than one hour beyond or below Working Hours are indicated by orange text.

 

Save a Timesheet as a Report

Reports allow you to repeatedly view timesheets with the same parameter without having to configure the filters and breakdowns each time.

To create a report, select Apps > Clockwork from the main Jira menu. Click on Reports in the left nav bar. Click Create report. After setting the appropriate filters and breakdowns, click Save as. Name and save the report.

Note that reports are global and will be visible to any user with permission to access Clockwork Timesheets.

View a Report

To view a saved report, go to Apps > Clockwork from the main Jira menu and click Reports in the left nav bar. A list of all reports will be shown. Click on the name of the report you want to view.

Delete a Report

To delete a report, select Apps > Clockwork from the main Jira menu. Click on Reports in the left nav bar. A list of all reports will be shown. Click on the Trash icon to the right of the report name.

Use a Relative Date Range

Clicking on the date filter allows you to select a timeframe relative to the current date.

 

Select the desired date range, and click Apply. Saving a timesheet with a relative date range as a report will mean that the report always renders for the selected range relative to the day the report is being run.

 

Alternatively, if the needed relative date range is not one of the options, you can set a bookmark that will allow you to select a relative date range on a timesheet.

Here's a sample timesheet address:

https://gebsun-support.atlassian.net/plugins/servlet/ac/clockwork-cloud/clockwork-timesheet#!startingAt=2019-09-23&endingAt=2019-10-24&activeReportDetailKeys%5B%5D=projects&activeReportDetailKeys%5B%5D=users

 

You can create a relative date range by editing the startingAt and endingAt clauses of the address. For instance to select 5 days before and 5 days ahead of today change startingAt and endingAt to set a date range that begins 5 days before today, and ends 5 days from now, set startingAt to =-5 and the endingAt to =5:

https://gebsun-support.atlassian.net/plugins/servlet/ac/clockwork-cloud/clockwork-timesheet#!startingAt=-5&endingAt=5&activeReportDetailKeys%5B%5D=projects&activeReportDetailKeys%5B%5D=users

 

To select current day, use 0. For example endingAt=0.

Current limitations
Params from the address are only read when loading the page, if you change them after the timesheet loaded they will not be reflected. You need to close the tab and open a new one to try out a new address.