Count number of unresolved issues via JIRA structure

[rupert_schreder]

Hey together,

for quality monitoring purpose I'd like to count the number of unresolved issues and show the sum in a structure column.

Unfortunately the following formula counting the unresolved issues does not work properly:

SUM{If(resolution = "Unresolved";1)}

For example the following JIRA filter shows the correct number of issues:
project = SKI and issuetype in (Defect, Bug) AND resolution = "Unresolved"

Would need help in setting up a working formula...

[David Niro · Accepted solution]

Hello @rupert_schreder ,

What you are running into here is that even though you see "Unresolved" in the Resolution field, it is actually not defined.

Please try this adjustment to your formula:

SUM{If(resolution = undefined;1)}

Let me know if it helps!

Best,
David

[rupert_schreder]

Thanks a lot, works perfect.