Issues created per week when issuetype transitioned to Defect and Resolution is in Fixed or Unresolved

Questions & Answers
1

Hi!

I have a calculation that gives me issues that have transitioned to IssueType. In my report, I’ve selected IssueType as Defect.

( [Measures].[Transitions to],
[Transition Field].[Issuetype]
)

It’s working as expected, but I want to filter only issues that have been ‘Fixed’ or still unresolved. I’ve tried a couple of things, but it’s still giving me all resolution types. Here’s what I’ve tried:

Created an aggregate calculated measure (FixedUnresolved which has resolution = fixed and (unresolved)) to use in my calculation, but it also still gives me all resolution types:

( [Measures].[Transitions to],
[Transition Field].[Issuetype],
[Resolution].[FixedUnresolved]
)

I’m guessing this gives me everything in the current time period so if the issues have not changed until months later, it won’t be reflected in this calculation? Is there a way to get the number of issues that have transitioned to my chosen issuetype and filtered on the desired final resolution states?

Appreciate any help here!

2

Is there a way to do what I need? Basically, calculate how many issues transitioned issuetype to “Defect” and was never ‘rejected’ (non rejected defects are either fixed or still pending resolution).

3

After looking up some of the existing solutions to questions, I used the following method described in this link to do what I needed to do. Resolution = Done does not work with Average days in Transitions Status

1 Like