How to count issues that had ever been reopened

Hi ,
I want to create a measure to count issues which meet following two conditions:
1、the issue had ever been reopened;
2、the issue’s current resolution is “fixed” 、 “unresolved” or “none”

I am looking forward for your reply.
Thanks in davance!

Hi @liu.jingjing,
To see which issues have been Reopened, you need to use Issue history change measures .

There are two ways how you can check if the issue was Reopened.
1.If you have a specific status for reopened issues, then by using that you can create this calculated measure in Measure dimension that checks issues that have been transitioned to it:

    (
    [Transition Status].[Reopened],
    [Measures].[Transitions to status issues count]
    )

2.Or if you count all issues that have done some specific transitions in the workflow as reopened then use this formula:
a) For several possible transitions, create an aggregate member Reopened in the Transition dimension.

    Aggregate({
    [Transition].[Done => Open],
    [Transition].[Done => In Progress],
    [Transition].[Done => Waiting for support]
    })

b) Then use this aggregate in this calculated measure in Measure dimension to count how many issues were reopened:

(
[Transition].[Reopened],
[Measures].[Transitions from status issues count] 
)

(Don’t forget to change the value in Transition and Transition status dimensions to the ones that are relevant to your workflow)

3.To check the current resolution for those issues will be a little bit more problematic as the dimension Resolution works together with historical measures, so in this case, this dimension will check resolution at the moment when the transition was done. If you have statuses that have a similar meaning to your resolutions that you can use the Status dimension as it indicates the current status of the issue.


4.But if you need current resolution and you can’t use the status dimension that the formula goes a bit trickier.
(you can choose which of the reopen measures mentioned above suits to your case and change it in formula accordingly)

NonZero(
Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
-- filters issues where resolution is Done or unresolved
[Measures].[Issue resolution] MATCHES 'Done|.*unresolved.*'
AND
-- filters issues that are created, time dimension is ignored, if this measure is used with time dimension then it will be orderd by transition date
([Measures].[Issues created], [Time].CurrentHierarchy.DefaultMember) > 0 
AND
-- filters issues that has been reopened, this measure is used for sorting issues with Time dimension
([Transition Status].[Reopened],
[Measures].[Transitions to status issues count]) > 0 
)
)
)

best,
Gerda // support@eazybi.com

1 Like