Time reports
Updated
Who can do this: Super Admins, Creators and Integrators
The Time reports in Insights show how your team's hours are logged, where they go, and how they compare with capacity and estimates. There are seven reports: Utilization, Forward capacity, Where time went, Allotted vs worked, Playbook variance, Entries and Data quality.
This feature is available when it's turned on for your organization. If you don't see it, contact your OnRamp team.
When to use it
To see who's over-loaded and who has room, now or in the coming weeks.
To find which accounts, projects or modules use the most hours.
To check whether your playbook estimates hold up.
To get the logged entries behind a number, or to check how complete your time data is.
How it works
The Time group in Insights and its reports appear only for Super Admins, Creators and Integrators. Collaborators can use the rest of Insights but not the Time reports. Contributors don't have Insights.
When time tracking is turned on, hours also show on a project's Time tab and an account's Time tab. Internal users' profiles have a Time tab too. Collaborators and Contributors can open these tabs, but the people breakdown shows only their own row.
Filters
The reports share one set of filters and one date range, which carry over when you switch reports. Each report shows only the filters it can apply. Playbook variance shows no filter bar.
Utilization
Utilization shows logged hours against each person's weekly capacity. It lists every active internal user who's expected to log time, including people who logged nothing. People set not to track time, and Integrators, aren't listed. Below 60% of capacity reads as under-loaded.
Capacity comes from the person's own figure or your organization's default. Someone with neither shows Capacity not set instead of a percentage and is left out of the Team average. Periods before someone started tracking time show Not tracking time yet. Periods they were fully away show Away all period.
Use Period to choose Week, Month or Quarter. The report shows the change against the prior period.
Turn on Include forecast to add projected hours from assigned work to the current and future periods.
Hover a cell to see its project breakdown. Select a logged cell to open the entries behind it for that period.
Filters: people.
Forward capacity
Forward capacity shows who has room in the coming weeks. Each open assigned task with an estimate adds its remaining time. That time is spread across working days from the task's start date (or today, if later) up to its due date. Overdue work lands in the current week, and time off lowers capacity.
Use Horizon to choose how far ahead to look: eight weeks by default, up to 12. The Not forecastable column counts work the projection can't place: tasks with no estimate, tasks with no due date, and hours that land past the horizon. Hover a cell to see the tasks behind it.
Super Admins, Creators and Integrators also see this projection as Staffing outlook on a project's Time tab, in the module view.
Filters: accounts, projects, people.
Where time went
Where time went shows what kind of work uses your hours. Use Group by to group by account, project, playbook, module, task or person. Then pick a sub-group, or No sub-grouping. Grouping by module, a group of tasks inside a playbook or project, shows which part of your process costs the most hours. Rows under 2% each fold into a single row you can expand.
Filters: accounts, projects, playbooks, people, modules.
Allotted vs worked
Allotted vs worked shows which projects and tasks are running hot against their estimates. Allotted time is set on playbook tasks and copied into each project created from them. Tasks with no estimate show as Not estimated, not as an overrun.
Filters: accounts, projects, playbooks, modules.
Playbook variance
Playbook variance shows whether a playbook's estimates hold up, averaged across its completed projects. Choose a playbook with the Playbook picker. Duration (calendar days) and Effort (hours) are shown separately. A warning shows when fewer than five completed projects are averaged.
When a module runs more than 25% over its allotted hours, Aero suggests a new estimate. Select Apply to playbook to update the current playbook, or Dismiss. Projects already running keep their estimates.
Entries
Entries lists every logged entry. Use Search notes and tasks to find entries, and Load more to load the next batch. Select Export CSV or Export Excel to download the rows.
Filters: accounts, projects, playbooks, people, modules.
Data quality
Data quality shows how complete your time data is, so you know how far to trust the other reports. It shows:
Unlogged time, as a share of total capacity.
Weeks not yet submitted, and weeks past their due day.
Entries worth a second look: over 12 hours in one entry, or logged more than 30 days late.
Each person with weeks still open, with Weeks outstanding and Last submitted.
A banner appears when more than a fifth of expected weeks are unsubmitted. There's no score or ranking.
Filters: people.
Limits
Only Entries (CSV or Excel) and Forward capacity (CSV) export. The Entries export uses the filters and date range you've set. The Forward capacity export uses its filters and the Horizon you chose, counted from today, not the date range.
Forward capacity leaves out tasks with no estimate or no due date, and work past the horizon. It counts them under Not forecastable.
Playbook variance averages only completed projects.