# 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](https://docs.logilica.com/advanced/datastudio-data-model/models/jiracomponent)
* [Planning Ticket Custom Field](https://docs.logilica.com/advanced/datastudio-data-model/models/jiracustomfield)
* [Epic](https://docs.logilica.com/advanced/datastudio-data-model/models/jiraepic)
* [Planning Ticket Hierarchy Issues](https://docs.logilica.com/advanced/datastudio-data-model/models/jirahierarchyissues)
* [Planning Ticket Hierarchy Issue Link](https://docs.logilica.com/advanced/datastudio-data-model/models/jiraissuehierarchylink)
* [Planning Ticket](https://docs.logilica.com/advanced/datastudio-data-model/models/jiraissuedetail)
* [Planning Ticket Event](https://docs.logilica.com/advanced/datastudio-data-model/models/jiraissueevent)
* [Planning Ticket Label](https://docs.logilica.com/advanced/datastudio-data-model/models/jiralabel)
* [Planning Sprint](https://docs.logilica.com/advanced/datastudio-data-model/models/jirasprint)
* [Planning Ticket State Durations](https://docs.logilica.com/advanced/datastudio-data-model/models/jirastatedurations)
* [Contributor](https://docs.logilica.com/advanced/datastudio-data-model/models/contributor)
* [Team](https://docs.logilica.com/advanced/datastudio-data-model/models/team)
* [Repositories](https://docs.logilica.com/advanced/datastudio-data-model/models/project)