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

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