Count epic subtask in Status "Done"

Questions & Answers
, , , ,
1

Hello,
each of my epics have multiple subtasks.
The statuses of the subtasks vary between “Todo”, “InProgress”, “Done”.

Among the sub-tasks, there is one that designates quotes and its name begins with quote…

I want to count the number of epics whose “Quote…” subtasks are in “Done” status.

Thank you for your help

2

Hi,

The first thing to try is a custom measure with formula like this:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
   [Measures].[Issue type]="Epic" --filter epics
   AND --count qoutoe sub-tasks per epic with the Done status
   Count(Filter([Issue].[Issue].GetMembersByKeys(
     [Measures].[Issue sub-task keys]),
     [Issue].CurrentHierarchyMember.GetCaption MATCHES ".*quote.*"
     and 
     [Measures].[Issue status]="Done"
   ))>0
   AND
   ([Measures].[Issues created],[Time].CurrentHierarchy.DefaultMember)>0
  )
))

The solution uses the iteration through all the issues, so there might be performance problems with this calculation in a large eazyBI account.

Kindly,
Janis, eazyBI support