Hi All,
I’m new to eazyBI and I’m trying to build a report for the below.
- Count resource allocation (Assignees) by the initiatives using Labels created for each initiative.
In this case, the Initiative label is assigned only for the EPIC. But when I get the assignee count, I need to count the assignees of the Child issues of the “In Progress” EPICs (Parent). Note: Children issues do not have the Label and won’t add any as it will not be sustainable with a lot of manual work.
I’m having one column with all relevant Labels filtered. And need to have the Assignee count calculated against each of these labels.
Currently, I created 2 Measures;
-
Count In Progress Assignee - This count only the EPIC as the label is attached to EPIC
NonZero( Count( Filter( ChildrenSet([Assignee].[ProductEngineers]), ( [Measures].[Transitions to status], [Transition Status].[In Progress] --[Assignee Group].[engineers] ) > 0 ) )
-
Count children ticket of the Parent EPICs - This creates a new column rather than filtering the no.1 measure.
[Issue].CurrentHierarchyMember.Children.Count
Please help, how can I combine these two to count the Children of the EPICs (which has the label) in “Inprogress” and “Onhold” and get the output in a single figure.
Expected output →
Initiative 1 → In Progress Assignee Count = 10
Appreciate any guidelines on this.
TIA