Timesheets by Tempo
Timesheets by Tempo is the #1 time tracking app for Jira, providing teams with simplified and automated time tracking, accurate financial reporting, and the ability to log billable service hours.
The integration between Structure and Timesheets allows you to:
Add Tempo Work Logged data as columns in your structure, and aggregate that data across your hierarchy
Use billable time and worklog data in formulas
Organize your structure data based on Tempo accounts and Tempo teams
Don't have Timesheets? Try it for free!
Adding a Tempo Work Logged Column
Adding a custom Tempo Work Logged column to a structure allows you to easily track work time and billable hours alongside your project data, and aggregate those values up your hierarchy.
You can customize each Tempo Work Logged column to focus on specific time frames, users, billable time, and more:
Name - Give each Tempo Work Logged column a name specific to the data its displaying.
Period - Specify the time frame you want to include work logged data from.
Jira users - Select the users you want to include (the time displayed will be the sum of all selected users).
Billable time only - When checked, only time marked Billable will be included in the column total.
Extended duration format - When checked, logged time will be broken down by contributor.
Sum over sub-items - When checked, work logged values will be aggregated up your hierarchy.
Exclude filtered items - When checked, filtered items will not be included in the aggregate total. If this is left unchecked, the values of those items will be included in the calculation, even though they are not visible in the structure.
You can make as many Tempo Work Logged columns as you need. For example, you could add one column to display all work logged, and another to display just billable hours, so you can easily compare the two.
Using Timesheets Data in Formulas
You can use Tempo Logged Time (tempoLoggedTime) and Tempo Billable Time (tempoBillableTime) within a formula to do calculations or comparisons based on your time tracking data.
In the example above, we switched the formula’s Format to Duration. Otherwise, time values will be displayed in milliseconds.
Customizing Tempo Time Tracking Values
The values for the Tempo variables are the same as you would see in the Tempo Work Logged column with the following options selected:
Period = All Time
Users = All
Billable time option is selected
To customize these options, select the variable and adjust its settings:
Using Worklog Properties in Formulas
You can also use the following Tempo worklog properties within a formula:
author
created
updated
comment
startData
started
timeSpent
billable
id
To use Tempo work log properties in a formula, use the following format: tempoWorkLogs.author
Learn more: Item Properties
Grouping by Tempo Accounts, Teams, or Contributors
You can group issues in your structure based on their Tempo account, team, or contributors.
To do so, add a Group by Field generator (permanent) or Quick Group (temporary), and search for “tempo” in the Field dropdown.
Connecting Structure and Timesheets
Before you can utilize Logged Time data in Structure, the Jira admin needs to connect Structure with Tempo. If you receive a "Configuration required" message, contact your Jira administrator.
Troubleshooting
If you experience any problems adding or viewing a Tempo Work Logged column, refer to the following common troubleshooting tips.
Configuration Required - Ask your Jira administrator to connect Structure with Timesheets.
No data in the column - If you're not seeing any data in the column, or receiving an error message, check the following:
Is work logged data available for the Period you've selected? Try adjusting the period and see if you get any results.
Is there work logged data available for the Jira users you've selected? Try changing the selected users.
Do you have permission to view their work logged data? Try selecting just yourself.
Data doesn't match what others see - When viewing a shared structure, the results you see in the Tempo Logged Time column may differ from what someone else sees, if you have different permissions from them. For example, you may only be able to view time for your team members, while a portfolio manager may be able to view time across several teams.