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?
My bug density is calculated as below:
CASE WHEN
[Measures].[Issues created]>0
THEN
[Measures].[Number of Bugs]
/
[Measures].[Issues created]
END
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