Reopen ticket count for resolved issue

Questions & Answers
1

Hi,
I read a lot of questions and answers around reopen ticket measure, but I didn’t find my answer.
SO here is my point:
I would like to have a distinct (unique) count of issues for a list of transitions (I already create an aggregate), only for resolved tickets but not restricted to the Time dimension.
More details:
If I had 25 tickets resolved in January, I would like to know on these 25 how many have transitioned at least once to reopen status from their created date not only during January.
So I created on aggregate:
[ Transition].[ ToReopen] =
Aggregate({
[Transition].[Done => In Progress],
[Transition].[Done => To Do],
[Transition].[Done => Open],
[Transition].[Done => In Review]
})

I created a new calculated measure:
[Measures].[ Issues reopened ]
= ([Transition].[ToReopen],
[Measures].[Transitions to status issues count])

So I have the number of tickets that been reopen during each month.
But I would like to have, for all tickets resolved each month, how many tickets have been reopen during all their cycle life (not specifically during the selected month)

I tried also using this:
([Transition].[ToReopen],
[Measures].[Transitions to status issues count],
[Time].CurrentHierarchy.DefaultMember)
but not working as expected.

Could you help me ?

2

HI @ealbert

Welcome to the eazyBI community!

In your case, you need to apply two separate conditions - transition to reopening status and resolution - with different relations to the Time dimension for each issue. Therefore, you may want to create a Measure that iterates through all issues, resolved in the selected time period (January 2021) and count distinct issues having (one or more) reopening transition in any time period:

  Sum(
    --filter issues having been resolved during the selected time period
    Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
      DateInPeriod([Issue].CurrentMember.get("Resolved at"),
      [Time].CurrentHierarchyMember)),
    -- sum up distinct issues with reopening transitions in any time period
    ([Measures].[Transitions to status issues count],
    [Transition].[ToReopen],
    [Time].CurrentHierarchy.DefaultMember)
    )

Best,

Ilze / support@eazybi.com