Current time of a ticket in a state

Is it possible to get the current time of a ticket in a state?
For example:

  • Create ticket-123 on April 17, 2021 (in backlog status)
  • On April 19 I moved it from backlog => in progress
  • Currently (April 20) is still in progress

What I would like is a view, where in the rows you can see the ticket and in the columns the time it was or is in each state, that is:


Hi @Marcelo_Ignacio_Cid1

Firstly, please ensure that you have enabled the Import issue change history option in your Source data Jira import options.

There is an excellent example in our Demo account: Issue days in selected status - Issues - Jira Demo - eazyBI.
The “Days in transition status till now” measure counts the number of days in each status that the issue has been in. You can define a new calculated measure in your report and use the formula from the Demo account:

-- days in transition status when issue was in this status in previous times
  -- if report uses Status dimension instead of Transition status it should work as well:
  [Status].CurrentHierarchyMember.Level.Name = "Status" and Not [Transition Status] = "Transition status",
    ([Measures].[Days in transition status],
     [Transition Status].[Transition status].GetMemberByKey(
    [Measures].[Days in transition status])
-- days since the last transition to this status
  Descendants([Issue].CurrentMember, [Issue].[Issue]),
  -- for unresovled issues only
  IsEmpty([Issue].CurrentHierarchyMember.Get("Resolved at"))
  IIF([Transition status].CurrentHierarchyMember.Level.Name = "Transition status",
      [Transition status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
  IIF([Status].CurrentHierarchyMember.Level.Name = "Status",
    [Status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
  [Measures].[Issues history] > 0
    [Measures].[Issue status updated date],

In the Columns section, use the Transition Status dimension that holds the historic Statuses of issues, as the Status dimension holds only the current Statuses of issues.

Best regards,
Nauris / eazyBI support