Created vs resolved I only want to resolved to show resolution fixed issues help??

[Marie Tennant]

I am using a custom filter in my created vs resolved chart. I only want the resolved line to show resolved bugs, change requests & stories with resolution fixed and with a certain reported. But the resolved line is picking up closed items with resolution empty, duplicate etc and it’s picking up sub tasks. The filter I’ve created is project in xxx AND reporter = xxx AND type = big OR type = change request OR type = story AND resolution = unresolved OR resolution = fixed AND status = closed. Can anyone help please???

[Mario Carabelli · Accepted solution]

@Marie Tennant

Awesome that I could help. You can mark my answer as correct then. This way I get some virtual bonus points 😉

With kind regards

Mario

[Mario Carabelli]

Hi Marie,

It seems like you are missing appropriate parenthesis. Your current jql assumes following paranthesis:

(project in xxx AND reporter = xxx AND type = big) OR (type = change request) OR (type = story AND resolution = unresolved) OR (resolution = fixed AND status = closed)

It evaluates the AND statements first and that is why your results are skewed.

Following jql would be most likely what you want:

project in xxx AND reporter = xxx AND (type = big OR type = change request OR type = story) AND (resolution = unresolved OR resolution = fixed) AND status = closed

With kind regards

Mario

[Marie Tennant]

Hi Mario, thank you for the help. I have updated the filter as you suggested but it still seems to pulling resolved ones with the resolution duplicate & withdrawn etc in the resolved count? 

[Marie Tennant]

Scrap that it’s worked, my fault! Thank you so much really appreciate the help!!! 

Warm regards,

Marie.

[Mario Carabelli]

My pleasure .

I actually never used custom jql in a predefined report. It is possible that it shows in this predefined report always all resolved issues (regardless of your custom filter).

You can test this by searching with the jql in the normal issue search. If the found issues are correct there thus is the case. Then you would have to create a new custom report with this jql for one graph. And a similar jqlfor the created issues. Unfortunately I cant access jira right now so i cant try it myself.

Best of luck anyway.

Kind regards

Mario