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

• Planning Ticket Custom Field

• Epic

• Planning Ticket Hierarchy Issues

• Planning Ticket Hierarchy Issue Link

• Planning Ticket

• Planning Ticket Event

• Planning Ticket Label

• Planning Sprint

• Planning Ticket State Durations

• Contributor

• Team

• Repositories