# Average wait to TCI

## Why this matters

The average wait to TCI is how long, on average, a client waited between joining the list and the
date they were given to come in. It is the clearest single measure of how quickly each list is
being worked through, and comparing priorities shows whether urgent clients are being seen sooner.

## Options

| Option | Choices |
|---|---|
| Formats | View, CSV, PDF |
| Dates | None to set: the report always covers the last 12 months, from this day last year to the end of today |
| Filters | **Users** (the users assigned to the entry), **Waiting Lists**, **Status**, **Priority**, **Locations** |
{.table}

See [Running Reports](/docs/reporting/running-reports/) for the steps.

## What it contains

The report includes every entry with a join date and a TCI date in the period. One row per
waiting list, with an **All Lists** total row:

| Column | Meaning |
|---|---|
| List | The waiting list |
| Scheduled | Entries with a TCI date in the period |
| Avg Days To TCI | Average days from the join date to the TCI date, to one decimal place |
| Urgent, Soon, Routine | **Total** and **Avg Days** for each priority |
{.table}

The CSV file has the columns **From**, **To**, **List**, **Scheduled**, **Avg Days To TCI**,
**Urgent Total**, **Urgent Avg Days**, **Soon Total**, **Soon Avg Days**, **Routine Total** and
**Routine Avg Days**.

## What to watch for

**Averages include time spent suspended**
The count runs from the join date to the TCI date, calendar day by calendar day. Suspensions aren't
taken off.

**Clients removed with Appointment Scheduled are missing**
Only entries with a TCI date are counted. If your service removes clients when they are given a
date, without recording the TCI date, they don't appear here.

**The period can't be changed**
Waiting list reports have no date fields, so this report always covers the last 12 months.

**Entries are missing, including every unassigned entry**
Unless you have **Can view All Appointments**, the report only includes entries with an assigned
user. See [Running Reports](/docs/reporting/running-reports/#before-you-start).

## Related

- [TCI List](/docs/reporting/tci-list/)
- [Breach Rate](/docs/reporting/breach-rate/)
- [Status and Suspensions](/docs/waiting-lists/status-and-suspensions/#waiting-and-scheduled)

---
Source: https://diarybook.com/docs/reporting/average-wait-to-tci/