Count of Components with work done / open bugs

Questions & Answers
1

Hi,

I would like to have a possibility to count the number of Components in a Project where “work” has been done( issue created or Issue closed or open bugs) for the purpose of tracking what is our readiness for release, by fixVersion.

All I can get at the moment is the number of bugs/issues per component.

Eventually this is the calculated member for the Project im trying to get to:

% Components “ready”:
Count of Components (with zero open bugs/issues or null)/
Count of Components (in entire project)

Any help would be appreciated

Thanks

2

Hi,

We can first Filter(…) all Project dimension Component level members based on if they have unresolved issues and then Count(…) how many components there are. Please try the following formula (make sure to set formatting to %)

CASE WHEN 
Count(Filter(
  Descendants([Project].CurrentMember, [Project].[Component]),
  NOT [Project].CurrentMember.Name MATCHES "\(no component\)" AND 
  [Measures].[Issues created] > 0)
) > 0 -- if there are any components with issues in the selected report context
THEN
Count(Filter(
  Descendants([Project].CurrentMember, [Project].[Component]),
  NOT [Project].CurrentMember.Name MATCHES "\(no component\)" AND -- filter out no component member
  [Measures].[Issues created] > 0 AND -- make sure there are issues created for the component in selected context
  isEmpty([Measures].[Issues due])) -- but all issues for the component are already resolved 
) / 
Count(Filter(
  Descendants([Project].CurrentMember, [Project].[Component]),
  NOT [Project].CurrentMember.Name MATCHES "\(no component\)" AND 
  [Measures].[Issues created] > 0) -- divide with count of components that have issues created
)
END

Please let me know if you have further questions regarding this!
Lauma / support@eazybi.com

3

Worked great, thanks a lot!

This might be asking too much… but is there any way to show a time dimension for this percentage?
e.g. show how the calculated percentage goes up or down over time.
At the moment when I introduce the time dimension it simply registers as 100% for every day…

Thank you!

4

Hi!

That would not be too much to ask :slight_smile: In case Time dimension is used, I imagine the best would be to use the Open issues instead of created and due measures. Then we can count Components where Open issues are 0 and divide that with components that have had Open issues. Please try the following formula

CASE WHEN 
Count(Filter(
  Descendants([Project].CurrentMember, [Project].[Component]),
  NOT [Project].CurrentMember.Name MATCHES "\(no component\)" AND 
  NOT isEmpty([Measures].[Open issues])
)) > 0
THEN
Count(Filter(
  Descendants([Project].CurrentMember, [Project].[Component]),
  NOT [Project].CurrentMember.Name MATCHES "\(no component\)" AND 
  ([Measures].[Issues created], [Time].CurrentHierarchy.DefaultMember) > 0 AND
  [Measures].[Open issues] = 0)
) / 
Count(Filter(
  Descendants([Project].CurrentMember, [Project].[Component]),
  NOT [Project].CurrentMember.Name MATCHES "\(no component\)" AND 
  NOT isEmpty([Measures].[Open issues])
))
END

Kind regards,
Lauma / support@eazybi.com