This article is for Timesheets for Cloud. Visit Data Center

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Next »

In order to get the most out of your Tempo reports, you can apply a range of tools to sort the data. This includes applying filters, organizing the filtered information into groups, sorting the data by columns, and adding columns to show Jira fields and work attributes.

Tempo remembers all your view settings and preferences between sessions. 

Select Reports in the Tempo sidebar to create a report or open a saved report.

  • Viewing worklogs for your team members in Tempo Reports requires the View Worklogs and Browse Projects permissions. To see worklogs for other users in a project, you need to have the View All Worklogs permission.

  • To report on planned time, you need to have Tempo Planner installed. Viewing plans requires the View Plans permission.

  • You can view the worklog data from inactive or deleted Jira users in a report - see Inactive or Deleted Jira Users and Tempo Timesheets for more information.

  • You can group by some Jira Service Management fields. They are included in Custom Fields when grouping data but do not impact the raw data export. However, if you have added a Jira Service Management field to your custom fields in Tempo Settings, they can be part of the raw data export.

Grouping Data

Grouping data in your reports helps you to structure your information in a meaningful way. The groups are displayed in the report according to the Jira hierarchy. 

In order to avoid duplicating data in its reports, Tempo assigns time record data to the groups that they have been added to most recently. This logic applies to the following:

  • Team

  • Role

  • Component

  • Fix version

This means that if a time record is associated with an employee who is a member of multiple teams, Tempo reports will place the time record under the team that the employee joined most recently. Likewise, if a time record has multiple components, the one added most recently will be reflected in the reports.

To group data in a report:

  1. Click the Group by box to display a list of possible choices. Select all the groups you want to add. 

    Expanded Group By options with Project and User selected, a search field, and list of fields you can group by.
  2. To remove a level of grouping, click Group by, and then click x to the right of the group level.

  3. Click Apply to group the data in your reports.

To simplify the report view, reports containing multiple levels of grouping do not display "empty" hierarchy levels. The following example shows a report that has been grouped by Epic/Issue/Sub-task/Worklog. No Epic hierarchy level is shown for Issue PRO-11 since it is not linked to an epic. Also, there is no hierarchy level for Sub-tasks because the issues do not have any. This makes the report look tidier and easier to read.

165ba939f54e5a.jpg

In Planned Time reports, plans submitted for approval are labeled with a colored dot to indicate their approval status. A green dot means that they have been approved, yellow that they are in review, and red indicates a rejected plan. You can hover the mouse pointer over the dot to get approval details.

Below is an overview of the various fields that you can use to group data and organize your report results:

Group by

What it does

Available report or timesheet

Account

Groups data by Tempo accounts

Account Category

Groups data by Tempo account category

Account Contact

Groups data by Tempo account contact

  • Logged Time Report

Account Lead

Groups data by the Tempo account's account lead

Account Status

Groups data by Tempo account status

Assignee

Groups data by the assignee

Category Type

Groups data by Tempo account category type

Component

Groups data by Jira components

Custom Fields

Groups data by one of the following single-value, custom fields:

  • Text Field

  • Select (single value)

  • Radio Buttons

  • Date Picker

  • User Picker

  • Group Picker

  • Float

Customer

Groups data by Customer

Epic

Groups data by Jira epics

Fix version

Groups data by the Jira fix version

Issue

Groups data by Jira issues

Issue Type

Groups data by Jira issue type

Labels

Groups data by Jira label and the following additional fields:

  • Reporter

  • Assignee

  • Priority

  • Status

  • Sprint

Organizations

Groups by the Jira Service Management Organizations field. This field is found in the Custom Fields.

Plan

Groups data by plans

Priority

Groups data by priority

Project

Groups data by Jira projects

Program Manager

Groups data by program manager

Programs

Groups data by Tempo Program

Reporter

Groups data by who reported the issue

Request Type

Groups by the Jira Service Management Request Type field. This field is found in the Custom Fields.

Role

Groups data by Tempo team role

Sprint

Groups data by sprint

Status

Groups data by issue status

Sub-task

Groups data by Jira sub-tasks

Team

Groups data by Tempo teams

Team Lead

Groups data by Tempo team lead

User

Groups data by Jira user

Work Attributes

Groups data by any work attribute type, such as:

  • Static List

  • Input Field (free text)

  • Input Numeric (numbers only)

  • Checkbox

Worklog

Groups data by worklogs (time records)

Sorting Data

Sorting by alphabetical or numerical order allows you to organize and display your report's data differently. You can sort a report by the data in a particular column by clicking that column’s heading. This then sorts data according to that column’s ascending or descending order: the text is sorted from A to Z, numerical data is sorted from highest to lowest, and time/date data is sorted from earliest to latest.

165ba939f5d489.jpg
  • Up and down arrows next to a column name indicate that data is being sorted by that column.

  • To reverse the sort order, click the column heading a second time.

  • In a report with multiple grouping levels, data is grouped by the top-level group. For example, the report above shows the most number of planned hours at the top sorted by user.

  • No labels