# Set up a Time in stage report

URL: https://attio.com/help/reference/managing-your-data/dashboard-and-reports/set-up-a-time-in-stage-report
Breadcrumbs: [Help](https://attio.com/help) > [Reference](https://attio.com/help/reference) > [Managing your data](https://attio.com/help/reference/managing-your-data) > [Dashboards and reports](https://attio.com/help/reference/managing-your-data/dashboard-and-reports)

Analyze how long records spend in each stage.

> Available on pro, enterprise plans.
>
> Available for **all** workspace members.

This article explains how to set up a Time in stage report, which shows how long records spend in each stage of a pipeline over time. Use it to identify bottlenecks, delays, and stages where records stay too long.

> For an overview of all report types and when to use each one, see [Create reports](https://attio.com/help/reference/managing-your-data/dashboard-and-reports/reports).

## **Create a Time in stage report**

> See Attio Academy for a video walkthrough of Funnel, Time in stage, and Stage changed reports.

Follow these steps to set up a Time in stage report:

1. Click **Reports** in the sidebar, then [create or open a dashboard](https://attio.com/help/reference/managing-your-data/dashboard-and-reports/dashboards).
2. Click **+ Add report** and choose **Time in stage**.
3. **Data source:** Select an object or list.
4. **Status attribute:**

   - Choose a status attribute whose stages define your pipeline.
   - **Included stages:** Select which stages to include in the report.
   - **Aggregation:** Choose whether to display the **Max**, **Average**, or **Min** time that records spent in each included stage.
5. **Grouped by:** Optionally select an attribute to break down the data (e.g. Owner, Date, Category).

   - When grouped, bars in the chart will be color-coded and a key will appear above the chart.
   - **Stack bars:** Display bars stacked vertically or side by side on bar charts.
6. **[Filters](https://attio.com/help/reference/managing-your-data/dashboard-and-reports/reports#filter-the-data-in-your-reports)****:** Optionally add filters to narrow the records included.
7. **Visualization options:**

   - Time in stage reports are always bar charts.
   - **Show axis labels:** Toggle attribute names on or off.
   - **Target**: Add a goal line across the chart.
   - **Sorted by:** Change the sort order of the x-axis. By default values are sorted numerically; you can instead sort by amount or time duration.

![Bar chart showing average time in days to close deals by stage: Prospecting, Qualification, Meeting, Proposal, Negotiation, Paused.](https://a.storyblok.com/f/234930/2442x1350/a33dd529f0/time-in-stage.png)

## Next steps

Changes you make to a report are not visible to other team members until the report is saved. For details on saving, viewing, and filtering reports, see [Create reports](https://attio.com/help/reference/managing-your-data/dashboard-and-reports/reports).