How do I get Total of Epic in new Measure?

Questions & Answers
, ,
1

Hi everyone, I have a question. How do I make a calculation to get all epic inside of the release? I have a Release 1 that has 25 Epics inside and I must calculate Bug Density (Number of bugs per Total number of epics), so, in 2 epics, I have 1 bug in each one. I would like to calculate the Bug Density but I couldn´t get the number of Total Epic(25) of release 1 on the formula only return number of epics with bug. Could Someone help me?

2

My bug density is calculated as below:

CASE WHEN
[Measures].[Issues created]>0
THEN
[Measures].[Number of Bugs]
/
[Measures].[Issues created]
END
3

Hi,

You can use tuples in the custom formulas. For counting issues by specific issue type.

The following formula gives the number of Epics created:

([Measures].[Issues created],
 ([Issue type].[Epic])

The following code snippet calculates the number of bugs per epic:

([Measures].[Issues created],
 ([Issue type].[Bug])
/
([Measures].[Issues created],
 ([Issue type].[Epic])

Kindly,
Janis, eazyBI support