Solution to get the ticket account with specific transition status in limited duration

[YuX]

Hello

Hello Community, I am trying to set up a report in easyBI to demonstrate the few KPIs below based on Sample Report “Created vs resolved issues over time”
Our JIRA projects have the status defined on each tickets: New → Under Analysis → Analysis Done → Integration → Closed

KPI1 - Calculate the number of tickets whose transition duration from NEW to Analysis Done is under 10 days.

For example, there are total 100 tickets in project, 80 tickets are already under Analysis Done/ Integration, or Closed. 20 tickets under New or Analysis.
I would like to get the ticket number among those 80 tickets which are moved to Analysis Done less than 10 days.

Here is easyBI templated MEASURES below, it can only list the ticket number for tickets which are from new to under Closed status less then 10 days.

[Measures].[Issues resolved < 10d] =
CASE WHEN [Measures].[Issues resolved] > 0 THEN
NonZero(Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod([Issue].CurrentHierarchyMember.get(‘Resolved at’),
[Time].CurrentHierarchyMember) AND
([Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember) > 0 AND
DateDiffDays(
[Issue].CurrentHierarchyMember.get(‘Created at’),
[Issue].CurrentHierarchyMember.get(‘Resolved at’)) < 10
)
))
END

KP2 - Get the average age of top#10 longest open tickets which has not yet been under Analysis Done yet.

Can you help to share the solution?

Thanks

[gerda.grantina]

Hi @YuX ,
For you first KPI, I suggest checking out Issue cycles that is a new feature starting from eazyBI version 6.5. eazyBI imports a set of measures and properties for each cycle counting issue and total time spent in the cycle. See more in the documentation on Issue cycles.

About the second KPI, the simplest solution would be to add issues in rows, select measure “Average age days”, select top 10 values and add standard calculation → average:

best,
Gerda // support@eazyBI.com