Count leaves and leaves without story points in structure

[jjh]

Hey,

I want to add a column with the the count of leaves and the count of leaves without story points in brackets or greyed:

EPIC 15 (6)

This means, that the EPIC has 15 leaves, but 6 without an estimination (story points). I tried "count('story point' = undefined", but this doesn't count right.

Any idea how to solve the problem?

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @jjh 

The Expr language (that is used in the Formula column) is different from JQL and it has its own syntax. You can find out more about it in our extensive documentation.

As for showing both the number of leaves and the number of leaves without Story Points, you can try a formula like this:

concat(count#strict{issuetype}, " (", count#strict{issuetype} - count#strict{storypoints}, ")")

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)

[jjh]

Thank you very much. This works :-)

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

Try "story points is empty" or "Story points = 0"

[jjh]

Hey, when I'm using a Query like "story points = empty" it shows me all issues without story points. But it doesn't work in the column formular in structure. When I use "story points = undefined" the syntax is correct, but I only get a 0 in every row.