> For the complete documentation index, see [llms.txt](https://help.aphex.co/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.aphex.co/docs/insight/reports/milestone-analysis.md).

# Milestone Analysis

Milestone Analysis shows the current status of every milestone in your project and how each date has shifted across publications.

## View Milestone Status

***

Every milestone in the project appears as a row, showing its current date, target date, and whether it's ahead, on target, or behind.

<figure><img src="/files/UERsz5VYOGwbCUvvsvQd" alt=""><figcaption></figcaption></figure>

<details>

<summary>Milestone Table Breakdown</summary>

<table><thead><tr><th width="139.51171875">Column</th><th>Description</th></tr></thead><tbody><tr><td>Milestone</td><td>The milestone's name and Task ID</td></tr><tr><td>Owner</td><td>The milestone's Task Owner</td></tr><tr><td>External ID</td><td>The milestone's External ID</td></tr><tr><td>Date</td><td>The milestone's current end date</td></tr><tr><td>Target</td><td>The milestone's Target Date</td></tr><tr><td>Variance to Target</td><td>Number of days between the current date and Target Date</td></tr><tr><td>Status</td><td>Ahead, On Target, or Behind, based on variance to target</td></tr><tr><td>Date Variance Over Time</td><td>A sparkline showing how the milestone date has shifted each publication - improvements above the anchor line, delays below</td></tr></tbody></table>

</details>

**To sort the table:**

* Click any column header to sort by that column
* The **Date Variance Over Time** sparkline column isn't sortable

## Filter by Milestone Status

***

Use the status filter to focus on upcoming milestones, or get a full view of past and future ones.

<figure><img src="/files/2E32C2YWlA3SBvEvt4Bs" alt=""><figcaption></figcaption></figure>

**To filter milestones by time period:**

* Use the status filter in the top-right of the widget
* Switch between Current (next 6 weeks), Future, Past, and All
* Current is the default

**To change which publication the report is anchored to:**

* Use the Publication selector in the filter bar
* Defaults to the latest published version

See also <a href="https://app.gitbook.com/o/vQAqt0G97z0npIyshO9g/s/Lu0mYklsCTm7XQm3ZGqv/~/edit/~/changes/291/insights/project-insights-overview#changing-the-published-version" class="button secondary">Changing the Published Version</a>

## Export the Data

***

Every chart and table can be exported as a CSV, with your active filters applied. Read our <a href="https://app.gitbook.com/o/vQAqt0G97z0npIyshO9g/s/Lu0mYklsCTm7XQm3ZGqv/~/edit/~/changes/291/insights/project-insights#exporting-the-report" class="button secondary">Exporting as a CSV</a> doc for a step by step guide.&#x20;


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://help.aphex.co/docs/insight/reports/milestone-analysis.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.