# Longest waiting by status

## Why this matters

The longest wait is the figure most often asked for after the total. This report names the
longest-waiting client in each status, so you can answer the question and check that client's
entry straight away.

## Options

| Option | Choices |
|---|---|
| Formats | View, CSV, PDF |
| Dates | None: the report shows the lists as they are now |
| 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

One row per status, from **Awaiting Triage** to **Removed**.

| Column | Meaning |
|---|---|
| Status | The status |
| Patients | The number of entries in that status |
| Longest Waiting | The client who has waited longest. If two have waited equally long, the one who joined first |
| List | That client's waiting list |
| Weeks Waiting | Weeks on the list. For review patients, counted from the last attended date |
| Breach Date | The breach date, adjusted for any suspension |
| Priority | Urgent, Soon or Routine |
{.table}

A status with no entries shows a dash. Rows where the client has breached are highlighted in red.

The CSV file has the columns **Status**, **Patients**, **Longest Waiting**, **List**, **Weeks
Waiting**, **Breach Date** and **Priority**.

## What to watch for

**The longest wait is across all lists**
Each row picks one client from every list you include. To find the longest wait on one list,
select it in **Waiting Lists**.

**Counts are lower than the list itself shows**
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

- [Waiting Time Statistics](/docs/reporting/waiting-time-statistics/)
- [Breach Alert](/docs/reporting/breach-alert/)
- [Status and Suspensions](/docs/waiting-lists/status-and-suspensions/)

---
Source: https://diarybook.com/docs/reporting/longest-waiting-by-status/