Count number of subtasks that has original estimates

Questions & Answers
1

Hi,

I am trying to count the number of subtasks per “target start” date.
Criteria are:

  • number of subtasks with original estimate group by month
  • exclude subtasks that has “A” label

Tried this but its giving me no result.

CASE WHEN
[Measures].[Original estimated hours]>0
THEN
Val(([Measures].[Issues with Target start],[Label].DefaultMember)

([Measures].[Issues with Target start],[Label].[A]))
END

any advise! thanks a lot.

2

Hi,

the following formula is for counting the issues by the Target Start date, having original estimates and not having the label “A”

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateInPeriod([Measures].[Issue Target Start],
                [Time].CurrentHierarchyMember)
                AND
    not CoalesceEmpty([Measures].[Issue labels],"") MATCHES ".*(^|,)A($|,).*"
    AND
    ([Measures].[Issues with Original estimated hours],
     [Issue Type].[Sub-task],
     [Time].CurrentHierarchy.DefaultMember)>0
  )
))

Kindly,
Janis, eazyBI support