> For the complete documentation index, see [llms.txt](https://docs.logilica.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.logilica.com/advanced/datastudio-data-model/models/jirastatedurations.md).

# Planning Ticket State Durations

## Description

Metrics relating to custom-states as defined in a planning tool, and the duration in which a Planning Ticket spends in each state.

## Measures

| Name                                | Title           | Description                                                |
| ----------------------------------- | --------------- | ---------------------------------------------------------- |
| `JiraStateDurations.count`          | Count           | A count of the possible issue states.                      |
| `JiraStateDurations.totalDuration`  | Total Duration  | The total duration of issues in the issue state.           |
| `JiraStateDurations.avgDuration`    | Avg Duration    | The average duration of issues in the issue state.         |
| `JiraStateDurations.medianDuration` | Median Duration | The median duration of issues in the issue state.          |
| `JiraStateDurations.p90Duration`    | P90 Duration    | The 90th percentile duration of issues in the issue state. |

## Dimensions

| Name                           | Title      | Description                                                     |
| ------------------------------ | ---------- | --------------------------------------------------------------- |
| `JiraStateDurations.id`        | Id         |                                                                 |
| `JiraStateDurations.stateName` | State Name | The name of the user-defined state.                             |
| `JiraStateDurations.duration`  | Duration   | The duration, in seconds, that an issue remained in this state. |

## Connected Cubes

All fields belonging to the following cubes are also reachable from JiraStateDurations:

* [Planning Ticket Component](/advanced/datastudio-data-model/models/jiracomponent.md)
* [Planning Ticket Custom Field](/advanced/datastudio-data-model/models/jiracustomfield.md)
* [Epic](/advanced/datastudio-data-model/models/jiraepic.md)
* [Planning Ticket Hierarchy Issues](/advanced/datastudio-data-model/models/jirahierarchyissues.md)
* [Planning Ticket Hierarchy Issue Link](/advanced/datastudio-data-model/models/jiraissuehierarchylink.md)
* [Planning Ticket](/advanced/datastudio-data-model/models/jiraissuedetail.md)
* [Planning Ticket Event](/advanced/datastudio-data-model/models/jiraissueevent.md)
* [Planning Ticket Label](/advanced/datastudio-data-model/models/jiralabel.md)
* [Planning Sprint](/advanced/datastudio-data-model/models/jirasprint.md)
* [Planning Ticket State Durations](/advanced/datastudio-data-model/models/jirastatedurations.md)
* [Contributor](/advanced/datastudio-data-model/models/contributor.md)
* [Team](/advanced/datastudio-data-model/models/team.md)
* [Repositories](/advanced/datastudio-data-model/models/project.md)