Document toolboxDocument toolbox

This article is for Timesheets for Cloud. Visit Data Center

Adding and Removing Columns and Work Attributes

Adding and removing columns or work attributes lets you select what information is displayed in your report and add additional details as needed.

The column options are different for Logged Time vs Planned Time reports, and the columns available depend on how you group your report results. For example, to compare how many billable vs non-billable hours were spent on issues linked to a customer's accounts, you need to filter the report by Customer and group the information by Account.

Hover over unavailable columns to see a tooltip that indicates which fields are required for the column to become available.

Since work attributes are custom fields, the fields displayed in the drop-down menu will vary by organization. You can only display work attributes in the Logged Time report when you select the Overview view and group by Worklog. If you add a numeric field work attribute, the report can calculate the sum of the field’s values.

cae7b076-6197-4b77-9b8f-aa57ec25f1b1.png

Add Columns and Work Attributes

  1. Click the Overview button at the upper right. Another label may appear on this button, depending on which option you last selected.

  2. Select the columns and work attributes you want to show in your report. 

  3. To remove a column or a work attribute from the view, clear the checkbox next to its name on the Overview menu.

    Logged_Time_report_columns.png

Additional Columns

Below is a list of the various columns you can use to bring additional data into your reports.

Logged Time report

Column

What it does

Logged Time report

Column

What it does

Columns

Planned

Displays the time planned.

 

Billable

Displays the hours logged in the Billable Hours field in the Log Time form. This column does not include time logged to Tempo accounts - see Best Practices for Tracking Billable Hours.

 

Required

Displays the time required according to the workload scheme.

 

Utilization

Displays required hours vs. logged hours. The leaving date for a team member is not considered part of the Utilization calculation.

 

Logged

Displays the time logged.

Overview Columns

Created

Displays when the worklog was created.

 

Updated

Displays when the worklog was last edited.

 

Worklog Count

Displays how many worklogs were created for an item.

 

User

Displays the user associated with the worklogs.

 

Logged By

Displays who logged the worklog.

 

Account

Displays the associated Tempo account - see Organizing Data Using Tempo Accounts.

 

Estimated

Displays the hours that are in the Estimated field in the Jira issue.

 

Remaining

Displays the hours that are in the Remaining field in the Jira issue.

 

Planned Time report

Column

What it does

Planned Time report

Column

What it does

Columns

Planned

Displays the time planned.

 

Planned Capacity

Shows what percentage of users' time has been planned.

 

Required

Displays estimates of how much time is required.

Overview Columns

Created

Displays when the plan was created.

 

Updated

Displays when the plan was last updated.

 

User

Displays the user associated with the plan.

 

Planned By

Displays who created the plan.

 

Estimated

Displays the hours that are in the Original Estimate field in the Jira issue.

 

Remaining

Displays the difference between the estimated time and the time logged against the plan.

 

Status

Displays the status of the planned issue(s).

 

Status Updated

Displays if the status of the plan has been updated

 

Requester

Displays who initiated the plan approval.

 

Requested Date

Displays when the request occurred.

 

Requested Reviewer

Displays who has been requested to review the plan(s).

 

Reviewed By

Displays who reviewed the plan(s).

Â