Get average time between bug is created and bugs arrive in a list of status

Questions & Answers
1

Hello

We’re ttrying to use easyBI recently, in we don’tt have the best workflow for “resolved status”
So in order to redefine the resolved status i added a calculated formula to get all bugs “resolved”

([Measures].[Bugs Created],
[Status].[Resolved])

Where bugs created is =

( [Measures].[Issues created],
[Issue Type].[Bug],
[Label].[qa]
)

Where [Status].[Resolved] is :

Aggregate ({
[Status].[Résolu],
[Status].[Checked],
[Status].[Archived]
})

My question is : I want to get the average date between : Issue created date and issue resolved (issues in status résolu, checked, archived)

My second question : Is there an option to redefine what is resolved so that I don’t have to do this for all the resolved calculated formula

Thanks

2

Hi @Hamza,

For different use cases, the list of final status when issues are considered resolved might differ.
In your case, you might want to define and use issue closed measures.

  1. In eazyBI import options, define closing statuses Résolu, Checked, Archived. And import data.
  2. in the report, use measure Average closing days to see time between issue creation date and time when first entered some of the closing statuses.

More details on issues closed measures are described there:
https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/issues-closed-measure

Best,
Zane / support@eazyBI.com