> ## Documentation Index
> Fetch the complete documentation index at: https://usepike.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Metric catalogue

> Every metric you can chart on a dashboard, and exactly how each is calculated.

Every widget shows one **metric**. This page lists all of them, what they measure, and precisely how Pike calculates each one.

A few things apply throughout:

* **Date range** - every metric is calculated only from data inside the dashboard's date range.
* **Currency** - money metrics are converted to your workspace currency using each record's exchange rate.
* **Submitted time** - labour cost, expense-driven delivery cost, and worked revenue count only time entries that are both **completed** (they have an end time) and **submitted**. Logged hours counts any completed entry, submitted or not.
* **Planned resources** - forecast metrics come from [task allocations](/docs/allocation/allocation-properties): hours scheduled on members or positions, not from logged time.
* **Deals** - sales metrics use [deals](/docs/customers/deals) with an expected close date in the range, not invoices or time entries.

Metrics are organised into five domains: **Time**, **Budget**, **Revenue**, **Forecast**, and **Profitability**.

## Time

| Metric | Unit | How it's calculated |
| - | - | - |
| **Available capacity** | Hours | For each member with an active contract, `hours per week × (days in range ÷ 7)`, summed across members. Only non-virtual members with a contract in effect are counted. |
| **Logged hours** | Hours | The duration (end - start) of every completed time entry in the range, summed and expressed in hours. |
| **Hours sold** | Hours | The same duration, but only on **billable** tasks that are not marked for deletion. Internal or non-billable time is left out. |
| **Billability** | Percent | The billable flag averaged across completed, submitted time entries - each billable entry counts as 100%, each non-billable entry as 0%. It weights entries equally, regardless of their length. |
| **Utilization** | Percent | `Logged hours ÷ available capacity`. How much of the time people were available to work was actually logged. |

> [!NOTE]
>
> **Hours sold vs logged hours.** Logged hours is every completed time entry.
> Hours sold is only the billable slice: time on a billable task, which is the
> time you meant to charge. Ten hours on a client task and two hours internal is
> 12 logged and 10 sold. Billing rate and cost per hour sold divide by hours
> sold, not logged hours.

## Budget

| Metric | Unit | How it's calculated |
| - | - | - |
| **Labour cost** | Currency | For each completed, submitted time entry, `minutes worked × (cost rate ÷ 60)`, using the member's contract cost rate in effect when the entry was submitted. Summed. |
| **Expense cost** | Currency | Every expense with a date in the range, as `amount × exchange rate`, summed. |
| **Cost of delivery** | Currency | **Labour cost + expense cost.** |
| **Cost per hour sold** | Currency | `Cost of delivery ÷ hours sold`. What one billed hour cost to deliver, including non-billable labour and internal or non-billable expenses. Projects with no sold hours show nothing. |

## Revenue

| Metric | Unit | How it's calculated |
| - | - | - |
| **Invoiced revenue** | Currency | The net line-item total of every **issued** invoice (sent, paid, or overdue), `× the invoice exchange rate`, counted in the range by the invoice's due date (or issue date when there's no due date). |
| **Worked revenue** | Currency | For each completed, submitted time entry, `hours × the member's bill rate on that task`. Entries on tasks with no rate contribute nothing. Summed. |
| **Average billing rate** | Currency | `Billable hours × assignment rate ÷ hours sold`. The effective sell rate on billable time, weighted by hours — not recognized or invoiced revenue. Projects with no sold hours show nothing. |

> [!NOTE]
>
> **Invoiced vs. worked vs. forecast.** *Invoiced* metrics follow money you've
> actually billed (issued invoices, by invoice date). *Worked* metrics value the
> work you delivered (time × bill rate, by the day it was logged), whether or
> not it's been invoiced yet. *Forecast* metrics look ahead: **planned
> resources** (task allocations × assignment rate or cost) and **pipeline**
> (deals by expected close date).

## Forecast

Forecast metrics look ahead. **Planned** metrics come from [task allocations](/docs/allocation/allocation-properties) on the allocation calendar. **Pipeline** metrics come from [deals](/docs/customers/deals) by expected close date.

Pike walks each overlapping task allocation day by day, takes that weekday's hours (Monday–Sunday minutes on the allocation), and multiplies by the rate or cost in effect that day. Allocations on a **position** that isn't staffed yet are included. Only allocations whose date range overlaps the dashboard range are included; hours outside the range are clipped.

| Metric | Unit | How it's calculated |
| - | - | - |
| **Planned revenue** | Currency | For each scheduled day, `hours that weekday × the bill rate on the task assignment`. Assignments with no rate contribute nothing. Summed. |
| **Planned cost** | Currency | The same hours, `× the member's employment cost rate` for that day (from the active contract, converted to an hourly rate). If the allocation is on a **position** with no member yet, the position's hourly cost is used. Summed. |
| **Planned profit** | Currency | **Planned revenue − planned cost.** |

Pipeline metrics use deals whose **expected close date** falls in the dashboard range. Deals without an expected close date are left out. Value is the net line-item total when the deal has line items, otherwise the deal's value, then multiplied by the deal's exchange rate.

| Metric | Unit | How it's calculated |
| - | - | - |
| **Sales pipeline** | Currency | Deal value by expected close date, summed. |
| **Weighted pipeline** | Currency | **Sales pipeline × stage win probability** (the [deal status](/docs/settings/deal-statuses) probability ÷ 100). |

> **[Allocation properties](/docs/allocation/allocation-properties)**
>
> How planned resource hours are scheduled on tasks.

> **[Deals](/docs/customers/deals)**
>
> Pipeline board, deal value, and expected close dates.

## Profitability

| Metric | Unit | How it's calculated |
| - | - | - |
| **Invoiced profit** | Currency | **Invoiced revenue - cost of delivery.** |
| **Worked profit** | Currency | **Worked revenue - cost of delivery.** |
| **Gross margin** | Percent | `Worked profit ÷ worked revenue`. Profit as a share of the revenue you earned. |

> [!NOTE]
>
> Finance Overview cards use **recognized − cost**, not worked or invoiced
> profit. See [Finance overview](/docs/finance/overview) and
> [Profitability](/docs/finance/profitability).

## How you can break down each metric

A metric can only be grouped or filtered by the dimensions it supports. Combined metrics (cost of delivery, profit, margin) support only what **both** of their inputs share, so their options are narrower.

| Metric | Break down by | Filter by |
| - | - | - |
| Available capacity | Member | Team, member |
| Logged hours | Period, member, team, project, customer, billable | Customer, project, team, member |
| Hours sold | Period, member, team, project, project status, customer | Customer, project, team, member |
| Billability | Period, member, team, project, customer | Customer, project, team, member |
| Utilization | Member | Team, member |
| Labour cost | Period, member, team, project, project status, customer | Customer, project, team |
| Expense cost | Period, team, project, project status, customer, billable | Customer, project, team |
| Cost of delivery | Period, team, project, project status, customer | Customer, project, team |
| Cost per hour sold | Period, team, project, project status, customer | Customer, project, team |
| Invoiced revenue | Period, customer, project, project status | Customer, project |
| Worked revenue | Period, member, team, project, project status, customer | Customer, project, team, member |
| Average billing rate | Period, member, team, project, project status, customer | Customer, project, team, member |
| Planned revenue | Period, member, team, project, project status, customer | Customer, project, team, member |
| Planned cost | Period, member, team, project, project status, customer | Customer, project, team, member |
| Planned profit | Period, member, team, project, project status, customer | Customer, project, team, member |
| Sales pipeline | Period, deal status, customer | Customer |
| Weighted pipeline | Period, deal status, customer | Customer |
| Invoiced profit | Period, customer, project, project status | Project |
| Worked profit | Period, team, project, project status, customer | Project, team |
| Gross margin | Period, team, project, project status, customer | Project, team |

> **[Build a widget](/docs/dashboards/widgets)**
>
> Turn any of these metrics into a chart on your dashboard.

> **[Finance overview](/docs/finance/overview)**
>
> Workspace recognized, invoiced, WIP, cost, and profit — not dashboard
> widgets.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.