You can compare the hours that people log on timesheets with their capacity for one month. Hive reads the capacity from two tables that you make in Tables:
Capacity table: one row for each person for each month, with the number of working days and the hours in a working day.
Factor table: the part of the capacity that you plan to use, for example a billable target of 0.8.
Hive then adds two values to the widget: Capacity hours and Allocated capacity hours.
How Hive calculates the values
Capacity hours = Working days × Daily hours, for each person.
Allocated capacity hours = Capacity hours × Factor.
The Grand total row adds the values of all people in the widget.
Example: Ana has 22 working days and 8 daily hours in October. Her capacity is 176 hours. With a factor of 0.8, her allocated capacity is 140.8 hours.
On a bar chart, Hive shows the totals below the chart: Actual, Capacity, Allocated and Utilization. Utilization = Actual ÷ Allocated.
Step 1: Make the capacity table
In Tables, make a table with these four fields. You can give the fields any names. The field types must be the same as in this list:
Person (Person field): one person in each row.
Month (Date field): the first day of the month, for example 10/1/2026.
Working days (Number field): from 0 to 31.
Daily hours (Number field): from 0 to 24.
Add one row for each person for each month. Each person in the widget must have exactly one row for the month.
Step 2: Make the factor table
Make a second table with these two fields:
Name (Text field): for example Billable target.
Factor (Number field): a number from 0 to 1. For 80%, type 0.8, not 80.
You can add many rows. Each widget uses one row.
Step 3: Connect the tables to a widget
On a dashboard, add or edit a Pivot table, Numbers or Bar chart widget.
In Chart content, set Report on to Time.
For a bar chart, set X Axis to User and Y Axis to Timesheet hours, with Display by sum. Do not add Break out by.
Under Widget filters, add the User filter and select the people. You can also use the Teams filter. You can select up to 200 people.
Under Monthly reporting inputs, select the month.
Select the Capacity table. Then select the Person field, Month field, Working days field and Daily hours field.
Select the Factor table. Then select the Factor name field, the Factor value field and the Factor row.
Select Save chart.
When you set up a pivot table or Numbers widget, Hive changes these settings for you:
Date of time logged changes to the full month that you selected.
The rows change to User, with Timesheet hours (sum) as a value.
Hive adds the Capacity hours and Allocated capacity hours values.
The widget does not use the dashboard filters.
When someone changes the tables, the widget updates.
Use the values in a formula
You can use Capacity hours and Allocated capacity hours in a pivot formula. See Dashboard Pivot Value Calculations.
Example: to show utilization, select Add value → Custom formula. Select Timesheet hours, then ÷, then Allocated capacity hours. Ana logged 64.5 hours, so her result is 0.46 (64.5 ÷ 140.8).
Rules for the widget
Pivot table and Numbers: use one row group, User. Do not add column groups. Values can only be Timesheet hours (sum), Capacity hours, Allocated capacity hours and formulas.
Filters: you can use only Date of time logged, User, Teams and Projects. To add a different filter, remove the monthly reporting inputs first.
One month: each widget shows one full month. To see a different month, change the month in Monthly reporting inputs.
People with no logged time show 0 timesheet hours. Their capacity still shows.
Access: to see the values, a person must have access to both tables and to their rows.
Why does my widget show "Monthly reporting inputs are unavailable"?
If one value is wrong, Hive does not show the widget data. Check these items:
A person in the widget has no row for the month, or has two rows.
The Month date is not the first day of the month.
The Person cell is empty or has more than one person.
Working days is empty or not from 0 to 31. Daily hours is empty or not from 0 to 24.
The factor is empty or not from 0 to 1. For example, 80 instead of 0.8.
The factor row, a table or a field was deleted, or a field type changed.
You do not have access to one of the tables or rows.
The widget has more than 200 people.
Correct the table, then select Retry.
Remove the tables from a widget
Edit the widget. In Monthly reporting inputs, select Remove reporting inputs, then select Save chart. Hive also removes the Capacity hours and Allocated capacity hours values and the formulas that use them.