7pace Timetracker's "Times Explorer" Page
View team worklogs, pick columns, group data, save your personal layout and then export to Excel on 7pace Timetracker's Times Explorer page.
Introduction
Even with a small team, you can quickly log hundreds or even thousands of worklogs each month. 7pace Timetracker's Times Explorer page allows you to organize all your worklogs in a way that makes the most sense for you.
When an administrator adds a user to the Team user role, they can access a special version of Times Explorer that displays the logged-in user's personal data only. In addition, to see the Person filter, the user must have at least the Product role assigned. This filter is not available for Team role users. To check on your users' permissions, you can go to the Settings page of Timetracker > User Management.
Roles higher than team will see the *worklogs for the entire team.
*A worklog is created any time you start tracking time and then stop tracking time = one worklog.
On this page, you can:
Add time (manually as a single time entry)
Assign budgets (singularly or in bulk with selected rows)
Add, edit and save as many of your own "Layouts" as you wish
|
|---|
Click on editable blue text/links on the page for additional functionality
Mark worklogs as Billable or Non-Billable
Delete selected rows (singularly or in bulk with selected rows)
Cherry-pick which columns display on the page from the Timetracker database AND your Azure DevOps project
Ability to see when every worklog was created: when added, optional "Created Date" column displays on Times Explorer, Budgets Export and API.
Export (worklog details to Excel)
Import (external time tracked outside of Timetracker from Excel)
Group worklogs (based on different fields like months, work item ID or users)
Sort and filter columns (see exactly what you want to see on the page, how you want to see it)
Resize and move columns (get a better look at the data that is important to you)
Remove filters (resets all grid filtering/sorting/grouping)
Assign activity type categories to your worklogs (when enabled by your admin)
Please note that Azure DevOps Activity and 7pace Timetracker Activity Types are separate entities.
Times Explorer Page: First Glance
When making changes to worklogs in the grid below, if you receive a message informing you that changes could not be made or that only certain rows updated, this is because you either don't have permissions to the associated work item to which the worklog belongs, it is locked, or it no longer exists.
ID | Description |
|---|---|
1 | New Layout Clicking on this button allows you to create a new customizable layout that will be available to you each time you navigate to the Times Explorer page: Once you name your layout, you can customize it to show exactly what data and columns you want to see on the Times Explorer page. You can save your column order, column width, filters, groupings, sorting, etc. You can also click on an existing layout, make changes to it, and then click New Layout, and your changes will be saved as a whole new layout. |
2 | List of Times Explorer Layouts When you first navigate to the Times Explorer page, you will see a list of pre-configured Layouts hat display for every user (the screenshot, above, shows pre-configured layouts for an administrator user). You can edit, rename, and/or delete these pre-existing Layouts as you choose. If you have already configured your Times Explorer page prior to the new Layouts feature being introduced, you will see an additional layout added to the list displayed in the above screenshot; My Layout will show the Times Explorer page as you last customized it before the Layouts feature was added. Pre-configured layouts are created and display per user and depending on the role that user has when they first visit the Times Explorer page. If a regular user accesses the page but then gets increased permissions (like an administrator, for example) later, the admin-specific pre-configured layouts are not added. To reset the default layouts on the page, simply delete all existing layouts and reload the page and the default layouts will appear. The Layout section is collapsible. By clicking the < icon above the New Layout link, the list of layouts can be collapsed to give you more real estate on the Times Explorer page. By clicking the > icon, the list of your Layout displays again. |
3 | Add Time Clicking on this opens the Add Time dialog box so you can manually add time for completed work. |
4 | The date range or timeframe of worklog details currently displaying on the Times Explorer page. The grid pre-loads the defined number of rows into the browser's memory for the quickest response time. By default, the page displays the worklog details for the timeframe that you set in Configuration > Timetracker System Settings. This timeframe is the total number of months prior to the current date. For more information, see this section of Settings > Rules. |
5 | Change Dates By clicking this link, you can temporarily change the timeframe of displayed worklog details on the Times Explorer page. To learn how an admin can permanently change this, click here. Timetracker calculates the timeframe in the following way:
The date of the last recorded time in the Timetracker database. If today's date is If you change the To or From date range on the calendar picker, you must specifically click on a date within the calendar because changing the month or year automatically de-selects any date from the calendar. Once you select a specific date within the calendar and click ok, your selected date range will display in the results. |
6 | Project dropdown list You can cherry-pick/check which projects you want to display on the Times Explorer page or use the following quick filters: All Projects filter selects only DevOps projects and displays work items with work item IDs associated with them. Select All filter will display all work items from all projects, including non-DevOps items. When you navigate away from the page, Timetracker remembers your selection when you return. |
7 | Iteration dropdown list You can cherry-pick/check which iterations you want to display on the Times Explorer page. When younavigate away from the page, Timetracker remembers your selection when you return. The Iteration column filter lists only the iterations where time was tracked on work items within those iterations. |
8 | Columns When you click this button, the Select Columns to Display box appears, allowing you to pick not only columns from the Timetracker database, but also custom columns from your Azure DevOps project. Some columns (Budgets, Billable and Billable hours) are visible only to user users with Product (and higher) role. Click Save to maintain any changes to the list of columns and the specific details of tracked time you want to display on the Times Explorer page as part of your specific Layout. The columns on Times Explorer page's worklog details table are movable by simply dragging them to display in the order that you prefer. They are also resizable by simply hovering your mouse to the right of each column header until a double-ended arrow icon displays and then dragging that to the right until the column is the width you prefer. You can also double-click the right column border to auto-resize the column to the maximum size of the content in that column. Each column allows you to simply click in the field below the column header and enter or select the value you want to filter by and display in the table details. You can also sort worklogs according to certain fields or columns by clicking the field name in the table header to sort the time details. Click the field name once to sort the time details in ascending order. Click the same field name again to sort the time details in descending order. The column header displays the appropriate icon to indicates the sorting order.
You can also sort by multiple columns. Press Shift + click to sort additional columns after the first one. Press Control + click in a table heading to remove the sorting of a column once multiple columns have been sorted. |
9 | Export You can export worklogs to an Excel file. Before exporting, you can filter the worklogs on the page to suit your needs and then export only those worklogs displaying on the page after matching the filter criteria. For more information, see Exporting Worklogs. |
10 | Import You can import worklog details that you have tracked outside of 7pace Timetracker, on the Times Explorer page. For more information, see Importing Worklogs. |
11 | Reset Filters Clicking this button causes the page to once again display all worklogs, unfiltered. |
12 | Rows Filtered At the top-right of the Times Explorer grid, the total number of worklogs listed and the total number of hours tracked for the listed worklogs display. If you have filtered the columns on the page to only display certain worklogs, this field displays the total number of filtered worklogs and the number of hours for those filtered worklogs. For example, if the total number of worklogs before you apply filters is 1500 and the total number of hours for these worklogs is 1,150 hours, then this field displays 1500 (1,150 h). If you then filter the columns to view fewer worklogs, and the new total number of filtered worklogs is 750 and the total number of hours associated with those filtered worklogs becomes 350 hours, then this field displays 750 (350 h). For more information, see Changing the Timeframe of Displayed Worklogs. |
Need support? Create a request with our support team.
Copyright © 2005 - 2026 Appfire | All rights reserved.