Jira cycle time and time in status in Power BI
Updated September 28, 2026.
Cycle time needs each issue's status history. Jira's issue fields only show the current status, so you need the changelog. OneFeed's Status changes dataset gives you one row per transition, ready for Power BI.
1. Load the data
- In Jira, open Apps > OneFeed, create a feed with your JQL and tick both Issues and Status changes.
- In Power BI: Get data > OData feed, paste the feed URL, choose Basic authentication with any username and the feed key as the password.
- Load both tables. They relate on
IssueKey.
Status changes columns: IssueKey, FromStatus, ToStatus, ChangedAt, Author, HoursInFromStatus.
2. Average time in each status
Build a bar chart with FromStatus on the axis and this measure as the value:
Avg hours in status = AVERAGE(StatusChanges[HoursInFromStatus])
The longest bars are your bottlenecks.
3. Cycle time per issue
Cycle time here runs from the first move into "In Progress" to the last move into "Done":
Cycle days =
VAR k = SELECTEDVALUE(Issues[Key])
VAR startAt = CALCULATE(MIN(StatusChanges[ChangedAt]), StatusChanges[IssueKey] = k, StatusChanges[ToStatus] = "In Progress")
VAR doneAt = CALCULATE(MAX(StatusChanges[ChangedAt]), StatusChanges[IssueKey] = k, StatusChanges[ToStatus] = "Done")
RETURN IF(NOT ISBLANK(startAt) && NOT ISBLANK(doneAt), DATEDIFF(startAt, doneAt, HOUR) / 24)
Rename the statuses to match your workflow.
Want it inside Jira instead?
StageTime shows time in status, cycle time and lead time for any JQL query directly in Jira, plus a panel on every issue.