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:

image

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
IIF(
  -- if report uses Status dimension instead of Transition status it should work as well:
  [Status].CurrentHierarchyMember.Level.Name = "Status" and Not [Transition Status].CurrentHierarchyMember.Level.name = "Transition status",
    ([Measures].[Days in transition status],
     [Transition Status].[Transition status].GetMemberByKey(
        [Status].CurrentHierarchyMember.Key
    )), 
    [Measures].[Days in transition status])
+
-- days since the last transition to this status
NonZero(SUM(Filter(
  Descendants([Issue].CurrentMember, [Issue].[Issue]),
  -- for unresovled issues only
  IsEmpty([Issue].CurrentHierarchyMember.Get("Resolved at"))
  AND
  IIF([Transition status].CurrentHierarchyMember.Level.Name = "Transition status",
      [Transition status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
  AND
  IIF([Status].CurrentHierarchyMember.Level.Name = "Status",
    [Status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
  ),
  CASE WHEN
  [Measures].[Issues history] > 0
  THEN
  DateDiffDays(
    [Measures].[Issue status updated date],
    Now()
  )
  END
))

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