Skip to content

Data Explorer

Data Explorer is the report you build yourself from your workspace’s tracked data. Pick the columns, group the rows up to four levels deep, filter, chart and export the table, then save the setup as a view to open again. It sits beside the other reports and replaces none of them. Everyone in the workspace opens it from Reports > Data Explorer, on every plan. Saving views is on the Plus and Premium plans.

Data Explorer on the Hours by project view: Group by Project then Member, the filter row, and one row per project with Customers, Members, Total time, Tracked time and Activity level

Each role sees the time it sees in the other reports. The Workspace Owner and Executive Managers see the whole workspace. Team Managers see their own time and the members they manage. Project Managers and Project Viewers see their own time and the projects they have access to. Members see their own time.

Start from a ready-made view

The page opens on the view you used last. Open the View menu to switch: your saved views are under My views, and nine setups are under Ready-made views.

The View menu open on Ready-made views: Hours by member and project, Daily hours by member, Hours by project, Tasks by project, Activity level, Pay and billing, Leave, holidays and breaks, Month by month
ViewRowsDates
Hours by member and projectMember, then ProjectLast 7 days
Daily hours by memberMember, then DayThis week
Hours by projectProject, then MemberThis month
Tasks by projectProject, then TaskThis month
Activity levelMember, then ProjectThis week
Pay and billingMember, then ProjectThis month
Leave, holidays and breaksOne row per memberLast 30 days
Month by monthOne row per monthThis year
Manual and idle timeOne row per memberLast 30 days

Pay and billing shows only to people who can see pay or bill rates. A ready-made view can’t be renamed or deleted. When you change one, Edited and Reset appear: Reset opens the view as it was, and your change can be saved as a new view of your own.

Switching to another view or clicking Reset drops the changes you haven’t saved, without a warning.

Group the rows

Grouping puts rows inside rows, up to four levels deep, from Member, Project, Task and Day, in any order.

  1. Click Group by and choose the first level. In a view that already has levels, go to the next step.
  2. Click Then by… and choose the next level.
    The Group by box with Project and Member, and the Then by menu offering Task and Day
  3. Click the arrow next to a row to open the rows inside it.
    The Development project opened to its five members; the Task column counts 26 tasks for the project and the tasks of each member; Edited, Reset and Save as new view at the top

Note that while Day is a level or a column, Date unit switches it to Day, Week or Month.

Each row counts for itself. Members and Days worked on a parent row count each member and each day once, so they can be smaller than the sum of the rows inside it. Both count any recorded time, so a day with only leave, holiday, break or idle time counts in Days worked.

Show the Member, Project, Task or Day column without grouping by it to count it. With the rows grouped by Project and the Task column shown, each project says how many tasks it holds, such as “26 tasks”.

With no level, the table has one row for each combination of the Member, Project, Task and Day columns you show.

Choose the columns

  1. Click Columns. Type in Search columns to find one.
    The Columns menu with Search columns, Email, Teams, Titles and Members under Member, Customers under Project, and Task with its grey detail columns
  2. Select a column to show it, or clear it to hide it.
  3. Drag a column header to move the column.
GroupColumns
MemberMember, Email, Teams, Titles, Members
ProjectProject, Customers
TaskTask, Parent task, Task project, Status, Due date, Time estimate
DayDay, Weekday, Days worked
TimeTotal time, Tracked time, Manual time, Idle time, Break time, Leave time, Holiday time, Inactive time, Time outside working hours
ActivityActivity level, Mouse, Keyboard, Scroll
Pay and billingPay amount, Bill amount
Custom fieldsYour member, project and task fields, except large-text fields

A column that describes a member, project, task or day needs that column. Parent task, Task project, Status, Due date and Time estimate stay grey until Task is a level or a column. Email, Teams and Titles need Member, Customers needs Project, and Weekday needs Day.

Total time adds up tracked, manual, idle, break, leave and holiday time. When a total differs from another report, see Why do totals differ between views and reports?

Click the three dots in a column’s header to sort it with Sort Ascending or Sort Descending, or to pin it left or right with Pin Column.

Reset Columns in the same menu puts the columns back as they were when you opened the view, or last changed the grouping or the Date unit. It undoes the columns you showed, hid, moved or pinned since then, the sort and the widths.

Some columns show only to some roles:

ColumnShown to
Pay amountPeople allowed to see pay rates
Bill amountPeople allowed to see bill rates
Pay amount and Bill amount, for everyoneOnly while Settings > Features > Billable / Payable Hours is on
EmailThe Workspace Owner, Executive Managers, Team Managers and Project Managers
Time estimateEvery role except Members
Customers, and the Customers filterEvery role except Project Viewers
Custom fields, and the Custom Fields filterEvery role except Members, on the Plus, Premium and Legacy plans. Project Viewers get no member fields

An amount shows with its currency. When members are paid or billed in several currencies, a row splits by currency, and the totals list one amount for each.

Filter the report

The filter row narrows the table: Members, Projects, Teams, Titles, Tracking method, Customers, Custom Fields and the dates.

  • Dates: up to 366 days. Pick the dates, or a shortcut such as This Week, Last 7 Days, Current Month or This Year.
  • Tracking method: how the time was recorded: Desktop tracker, Mobile tracker, Web tracker, Extension tracker, Manually added time, Idle time, Paid leave, Break, Paid holiday or Kiosk.
  • Time zone: the menu next to Columns sets the zone the days are counted in: yours, the workspace’s, UTC or any other. It starts on the workspace’s time zone, or on yours when the workspace has none.

Chart and export the table

Click Chart to draw up to 15 top-level rows as bars. The bars measure the number column you sort by, or the first number column shown when you sort by name. When each row is one day, week or month, oldest first, the chart is a line of up to 30 rows. The chart’s menu holds Edit Chart, Advanced Settings, Link to Grid and Download Chart.

Chart stays grey until the table shows a number column and has rows.

The Total time by Project / Member chart: one bar per project, longest first

Click Export and choose CSV or XLSX. The file holds every row of your setup down to the last level, a subtotal line under each group, and the totals at the end. An export holds up to 100,000 cells, rows times columns; for a larger table, shorten the dates or hide columns.

Data Explorer has no PDF, share link, email or schedule; the other reports have them.

Save a view

A saved view keeps your columns and their order, levels, date unit, sort, pinned columns, filters, dates and time zone. Only you see it. Saving views is on the Plus and Premium plans.

  1. Change a ready-made view.
  2. Click Save as new view.
  3. Enter a View name and click Save.
    The Save as new view dialog with a View name and the Save button

The view opens under My views in the View menu. You can keep up to 50 views in a workspace, each with its own name. A view saved on a shortcut such as This Week moves with the calendar. Dates you pick stay fixed, unless they match a shortcut’s dates on the day you pick them.

When you change a saved view, click Save to update it. To keep both, choose Save as new view in the … menu next to the view’s name. The same menu holds Rename and Delete.

You can’t restore a deleted view that you created and have to create it from scratch.

On plans where saving a view is not available, views you saved before still open, and you can delete them, but you can’t rename or update them.

Was this article helpful?