I want to to show the number of unestimated tickets in an epic in structure

[Lisa]

I would like to be able to show the number of unestimated ("story points" is empty) tickets in an epic in Structure.

I tried this and many others wit no luck.  Please help.

Sum {if (Type != Epic AND Story_Points <1;1)}

Count {if (Type != Epic AND Story_Points <1;1)}

More Context:  I extend my epics to display their stories, but when I collapse down to the story level, I want to be able yo see the total unestimated tickets.  Thanks!

[David Niro · Accepted solution]

Hello @Lisa ,

David from ALM Works here.

To make sure I understand the goal:  You have a Structure hierarchy with Epic > Stories(other issue types).  The goal is to identify how many issues under an Epic do not have Story Point estimates.  Is this correct?

If it is, you could start with this formula:

IF(issuetype = "Epic";
SUM#children{If(story_points = undefined;
1)})

With the first IF conditional statement we are defining where the calculation should be made.  = "Epic"

Then we are defining what the calculation should be. SUM#children.  

FInally, we are identifying what value we want to SUM up, the second IF conditional statement. story_points = undefined; 1

Let me know if this helps!

Best,
David

[Lisa]

Thank you!!

[David Niro]

You're very welcome!!!