Time Tracking
Time Tracking Hours
The total time tracked (in hours) recorded on action cards.
Time Tracking Cost
The total cost of the tracked time, calculated by multiplying each user’s tracked hours by their individual cost rate.
Time Tracking Billed
The total billable amount for the tracked time, calculated by multiplying each user’s tracked hours by their individual bill rate.
Estimated Time
The total amount of time (in hours) estimated on action cards.
Estimated Cost
The total cost of the estimated time, calculated by multiplying each user’s estimated hours by their individual cost rate.
Estimated Billed
The total billable amount of the estimated time, calculated by multiplying each user’s estimated hours by their individual bill rate.
Timesheets
Timesheet hours
The total hours from submitted, unsubmitted, pending, approved, changes requested and unapproved timesheets (filterable by each status).
Timesheets Cost
The total cost of timesheet hours, calculated by multiplying each user’s hours by their cost rate.
Timesheets Billed
The total billable amount of timesheet hours, calculated by multiplying each user’s hours by their bill rate.
Timesheets Billable Cost
The total cost of all billable timesheet hours, calculated by multiplying each user’s billable hours by their cost rate.
Timesheets Non Billable Cost
The total cost of all non-billable timesheet hours, calculated by multiplying each user’s non-billable hours by their cost rate.
Timesheet status
Shows each user's timesheet status for the period: Approved, Pending approval, Changes requested, Unapproved or Unsubmitted. To add it, open Values, search for Timesheet status and select it.
When a pivot table reports on Time, uses User as the first row group and includes Timesheet status as a value, it lists every user in the workspace, not only people who logged time.
Unsubmitted with an info icon (ⓘ): the user has no timesheet data for that period. Hover over the icon to see No timesheet data for this period. If columns are split by date, for example by week, each period without data shows this.
Unsubmitted without the icon: the user has a timesheet that has not been submitted. Click the status to open it — see Open a person's timesheet from the pivot.
Users with no timesheet data do not change hour totals.
By default, the list includes external users (also invited users who have not joined yet) and removed users. To show fewer users:
Set the Removed users filter to Exclude.
Filter by Users, Teams or User tags.
Add a timesheet status or timesheet approver filter. Users with no timesheet data are then not shown.
Open a person's timesheet from the pivot
Click a Timesheet hours or Timesheet status cell to open that person's timesheet for the week in a window, without leaving the dashboard.
This works when the pivot table:
Reports on Time.
Has User as its only row group.
Has one column group that splits by Day or Week.
Uses Timesheet hours (Sum, without a formula) or Timesheet status as the value you click.
In the window:
The title shows the person, and the full week is shown. If you clicked a Day cell, that day is highlighted. Submissions and approvals always apply to the whole week.
You can edit hours, submit, approve, request changes and comment — the same actions your permissions allow in Timesheets.
Tabs such as Timesheet, Approvals, Unsubmitted and Submitted appear depending on your access.
After you save, the pivot table refreshes.
Select Open in Timesheets to go to the full Timesheets page for the same person and week.
Grand total cells, and dashboards opened from a share link or export, don't open the window. In other layouts, a Timesheet status cell still opens Timesheets reporting if you have access to it.
Timesheets leave hours
The submitted timesheet hours as a leave type.
Resourcing
Resourcing Estimates
The total amount of resourced (scheduled) hours from the Resourcing app.
Resourcing Estimate Cost
The total cost of the resourced hours, calculated by multiplying each user’s resourced hours by their cost rate.
Resourcing Estimate Billed
The total billable amount of the resourced hours, calculated by multiplying each user’s resourced hours by their bill rate.
Time off
The resourced hours as time off.
Utilization (%)
Utilization is a metric that measures how much of a user’s available time is allocated to project work, compared to their total available hours.
Utilization (%) = ( (Estimated Time + Resourcing Estimates) − (Time Off + Holidays) ) / Available Hours × 100
Estimated Time: Sum of estimated hours on action cards within the selected date range.
Resourcing Estimates: Sum of resourced hours in the Resourcing app within the selected date range.
Time Off + Holidays: Total hours allocated for vacation, sick days, company holidays, etc. See Why did my holiday total go up?
Available Hours: Total working hours a user is available in the given date range (e.g., 8 hours/day × number of working days).
Recurring-action time and utilization
If future repeats seem to be missing from a utilization forecast, check the workspace setting Include recurring action time in utilization dashboards under Settings → Apps → Time tracking. Workspace admins can enable it and set the Recurring action time look-ahead (months).
The setting allows normally hidden future recurring action instances into dashboard reporting. Future repeats with due dates are limited by the look-ahead period, measured from the current date. The default is 12 months, with a range of 1–120 months. Recurring subactions without their own due date are not excluded solely for lacking a date by this look-ahead rule.
The dashboard’s date range, project selection, and other filters still apply. On dashboards covering multiple workspaces, the owning workspace’s recurring-time settings govern the workspaces included in that dashboard.
This setting changes which action instances can contribute to reporting. It does not turn estimated time into tracked hours or submitted timesheets. See workspace recurring-action time settings for setup.
Budgets
Project Budget
Total project budget assigned to the project through the Project Navigator.
Other Costs
Other costs added to the project through the Project Navigator.
Budget Remaining
Each “Budget Remaining” metric follows the same core formula:
Budget Remaining = Project Budget - (Other Costs + Total Calculated Value)
Time Tracking Cost Budget Remaining
Project Budget - (Other Costs + Total Time Tracking Cost)
Time Tracking Billed Budget Remaining
Project Budget - (Other Costs + Total Time Tracking Billed)
Timesheets Cost Budget Remaining
Project Budget - (Other Costs + Total Timesheets Cost)
Timesheets Billed Budget Remaining
Project Budget - (Other Costs + Total Timesheets Billed)
Estimated Budget Cost Remaining
Project Budget - (Other Costs + Total Estimated Cost)
Estimated Budget Billed Remaining
Project Budget - (Other Costs + Total Estimated Billed)
Resource Est. Cost Budget Remaining
Project Budget - (Other Costs + Total Resource Estimates Cost)
Resource Est. Billed Budget Remaining
Project Budget - (Other Costs + Total Resource Estimates Billed)
Margins
Margin Timesheet Cost Budget (%)
Timesheet Cost Budget Remaining / Project Budget x 100
Margin Timesheet Billed Budget (%)
Timesheet Billed Budget Remaining / Project Budget x 100
Margin Resource Est. Cost Budget (%)
Resource Est. Cost Budget Remaining / Project Budget x 100
Margin Resource Est. Billed Budget (%)
Resource Est. Billed Budget Remaining / Project Budget x 100
Margin Estimated Cost Budget (%)
Estimated Cost Budget Remaining / Project Budget x 100
Margin Estimated Billed Budget (%)
Estimated Billed Budget Remaining / Project Budget x 100
Margin Time Tracking Cost Budget (%)
Time Tracking Cost Budget Remaining / Project Budget x 100
Margin Time Tracking Billed Budget (%)
Time Tracking Billed Budget Remaining / Project Budget x 100
Forecasted Margin
Estimated Billed Amount - (Estimated Cost Amount + Other Costs)
Forecasted Margin (%)
(Forecasted Margin / Estimated Billed Amount) x 100
Approvals
Review stages
List of stages available on this action card
Review rounds
List of rounds available on this action card
Review stages (count)
The total count of stages available on this action card
Approver
The user who is set as an approver
Current approval stage
The active approval stage on the action card. Fully approved cards show Approved.
Current approval round
The current approval round on the action card. Fully approved cards show Approved.
Current approver
Approvers still waiting to respond in the active stage. Unlike Approver, this field
focuses on who currently needs to respond.
Next approver
Approvers assigned to the next stage in the current approval round.
Days in stage
The number of calendar-day boundaries since the active stage started, calculated in UTC. Weekends and holidays are included. The value is blank when the active stage has no start date.
Approval status
Approval status for the active stage when Review Stage is not a row group. Fully approved cards show Approved.
Approval due date
The active stage’s approval due date when Review Stage is not a row group.
Approval stage start
The active stage’s start date when Review Stage is not a row group.
Approval date
The historical approval date for a review stage. This field is available on Review Stage rows, rather than projected onto Action or Project rows.
Proofing file
Proofing files associated with the action. Click a proofing file value to open it. Use the Proofing file filter to include actions with or without proofing files.
Example: Use Action rows with Current approval stage, Current approver, and Days in stage to identify approvals waiting for attention.
Formula and Table lookup fields
Why does my pivot show N/A?
Hive calculates Formula and Table lookup custom field values each time it shows them. Hive does not keep these values. For this reason, a pivot cannot add, average or count them.
The Values list of these widgets does not show Formula or Table lookup fields:
Pivot table
Numbers
A saved Pivot table or Numbers widget that uses a Formula or Table lookup field as a value shows N/A for that value. N/A tells you that Hive cannot calculate the value.
Pivot table: each cell and each total for that value shows N/A. Until November 3, 2026, these cells showed 0 (Formula) or were empty (Table lookup).
Numbers: the number shows N/A.
Exports: if the pivot table has row groups, CSV and XLSX exports also show N/A in these cells.
Pivot formulas: a pivot formula that uses a Formula or Table lookup value does not show N/A. Hive uses 0 or an empty value for that field, so the result can be wrong. Remove that value from the formula.
What to do:
On the widget, click Configure widget.
In Values, remove the Formula or Table lookup field.
Add a value that Hive can calculate. For example, use a Number custom field.
Click Save.
To show Formula values on a dashboard, use a Heatmap widget. Heatmaps can use Formula fields as a value. See Use Formula Values in Dashboard Heatmaps.
Role name rows and holidays
Why did my pivot numbers change on November 4, 2026?
On November 4, 2026, Hive changed how some Pivot table and Numbers widgets count actions, time and holidays. Saved widgets can show different numbers. You do not need to change your widgets. Not every widget changes.
A widget can change when it uses:
a Role name row group;
Columns split by date: Day, Week, Month or Quarter;
the Holidays value.
Projects reports with a Role name row group do not change.
Why did my action count go down in a Role name row?
With the new count, an action counts one time for each role of its assignees. Before, it counted one time for each assignee with that role.
Example: An action has two assignees. Both have the role Designer. The Designer row now counts 1 action. Before November 4, 2026, it counted 2.
Why did my time move to a different role?
With the new count, Hive counts each time entry under the role that the entry was logged with. If the entry has no logged role, Hive uses the person's current role.
Example: Ana logged hours as Designer. Then her role changed to Art Director. Her older hours stay in the Designer row.
Why did my holiday total go up?
With the new count, a holiday counts for a member when the member works for your company on the date of the holiday. Hive uses the first and last day of work in the member's settings.
Example: Your date range is October 1–31. Sam starts on October 15. A holiday on October 20 counts for Sam. A holiday on October 10 does not count.
Before November 4, 2026, Hive did not count holidays for a member who started or left during the date range.
Widget Filters
Filters can be found on the right Chart Content menu of your widget. The Pivot Table widget allows the ability to filter by:
Archived actions: Include / Exclude
Completed status: Include / Exclude / Show Only
Completed on due date
Project
Project owner
Action Status
Overdue: Include / Exclude / Show Only
Subactions: Include / Exclude
Risks: Include / Exclude
Urgent: Include / Exclude / Show Only
Milestone: Include / Exclude / Show Only
Completed By
Created By
Labels
Roles
Teams
Sprints
Rounds
Review stages
Approved stages
Proofing file: Yes / No
Archived projects: Include / Exclude / Show Only
Phase
Priority Levels
Completed Date
Created Date
Action Due Dates
Action card title: Contains / Equals
Action Custom Fields
Project Custom Fields

