Filter report based on Jira Ticket Created Date

Questions & Answers
2

Hi @Rahul_Aurora,

Yes, the Avg days in transition status is a time-related measure and gives the result of issues that transitioned out of the state in the period, no matter when they were created (Import issue change history).
A calculation I would suggest is to Sum Days in transition status Filtering issues created in the period and divide it with Sum of Transitions from status for the same set of issues:

Sum(
  Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
  DateInPeriod([Issue].CurrentHierarchyMember.get('Created at'), 
    [Time].CurrentHierarchyMember
  ) AND
  ([Measures].[Issues created], 
   [Transition Status].DefaultMember, 
   [Time].CurrentHierarchyMember) > 0
  ),
  ([Measures].[Days in transition status], [Time].CurrentHierarchy.DefaultMember)
) / 
Sum(
  Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
  DateInPeriod([Issue].CurrentHierarchyMember.get('Created at'), 
    [Time].CurrentHierarchyMember
  ) AND
  ([Measures].[Issues created], 
   [Transition Status].DefaultMember, 
   [Time].CurrentHierarchyMember) > 0
  ),
  ([Measures].[Transitions from status], [Time].CurrentHierarchy.DefaultMember)
)

Note that in the calculation, we are ignoring the Time dimension ([Time].CurrentHierarchy.DefaultMember) in the Days in transition status and Transitions from status. In this way, we filter issues created in the period but look at how much time they spent in the statuses on average over all time, not only during the selected period.

Lauma / support@eazybi.com

1 Like