---
title: "Time-in-status — per current status, how long open issues have been sitting (avg/p50/p95 hours)"
method: GET
path: "/api/workspaces/{workspaceId}/insights/time-in-status"
tags: ["Insights"]
---

# Time-in-status — per current status, how long open issues have been sitting (avg/p50/p95 hours)

`GET /api/workspaces/{workspaceId}/insights/time-in-status`

## Request

- Base URL: `https://hiveship.app/api`
- URL: `https://hiveship.app/api/api/workspaces/{workspaceId}/insights/time-in-status`
- Auth: one of:
  - HTTP bearer
  - API key in cookie `hiveship_access`
  - HTTP bearer

## Path parameters

- `workspaceId` string, required

## Query parameters

- `from` string
- `to` string
- `projectIds` string
- `priorities` string
- `assigneeIds` string
- `labelIds` string

## Response `200`

Per-status time-in-status distribution over currently-open issues

- object
  - `success` boolean, required
  - `data` object, required
    - `rows` object[], required
      - `status` string, required
      - `count` integer, required
      - `avgHours` number, required
      - `p50Hours` number, required
      - `p95Hours` number, required
    - `emptyReason` 'no_projects' | 'no_open_issues', nullable, required

## Other responses

- `403`: Plan does not include insights, or caller lacks OWNER/ADMIN role (PLAT-105)

---

[API](https://skmtc.dev/hiveship/apis/hiveship-api.md) · [All operations](https://skmtc.dev/hiveship/apis/hiveship-api/llms.txt) · [OpenAPI document](https://skmtc.dev/hiveship/apis/hiveship-api/revisions/73d3e26544e4?raw)