Group and export time as reports
Ask AI
Pull logged hours grouped by person, project, work item or time category, filtered and exported to CSV
Reports → Logged time turns logged hours into a matrix instead of a week-by-week grid. Reports is a manager and admin page; everyone else reads their own totals on My time and My month. A project's leads see that project's hours on its Time tab under Time tracking → Projects (see Projects, activities and project leads).
Choosing a period
The window is fixed and sized by the Bucket select, which defaults to Week: Day spans 7 days, Week spans 84 days (12 weeks), Month spans 12 calendar months. Previous/Next and Today move the window; switching the bucket re-snaps to a window of the new size around where you were.
Group by, and filters
A Group by select with four options - Project (the default), Person, Work item, Category. Category is the tenant-defined time category axis; capex/opex is a one-click preset. Three filters sit alongside it: a project picker, a team picker (defaulting to "All my people," same manager/admin scoping as Team timesheets), and a category picker (one of your categories, or unclassified). Person and work item are grouping axes rather than filters - group by Person or Work item to see that breakdown.
What the table shows
One row per group (a person, a project, a work item, or one of your categories / unclassified), one column per bucket in the window, hours only - the table carries no rates and no approval status. A project row's sub-label is its code; a work item row's is its tracker issue key when it has one. Rows sort by total, highest first, and the tab requests the top 10 - the tail folds into one Other row and a Total footer covers every group in scope, so the columns still reconcile. On narrower screens the matrix becomes a stack of per-group cards instead of a wide table.
CSV export
Export CSV, beside Today in the period nav, downloads exactly what is on screen - same
group-by, same filters, same window; the link appears once the window has rows. Columns are
the group's label, its sub-label (code or issue key, blank otherwise), the row total, then one
column per bucket in the window. The tail ships as a final Other (outside top rows) row, so
the file and the table carry the same total.
For agents
get_time_report returns the same matrix as a tool call: a groupBy of employee, project,
task or classification, a day, week or month bucket, and the same project, team and
category filters, plus an employeeId the tab does not offer. The range is capped at 366 days,
a manager sees only the people they manage, a project's lead sees everyone's time on that project
when the call names it, and anyone may run the report scoped to themselves.
Worked example
Marta opens Reports → Logged time, sets the bucket to Month, groups by Category, and filters the team picker to Platform. The twelve monthly columns split the Platform team's hours into capex and opex rows; she downloads Export CSV and hands the file to finance.