Count resolved issues that have been in Status A but not Status B

Questions & Answers
1

I need to create a chart to show the number of issues resolved each month where we escalated to our dev team, but the issue got resolved without a code change.

If I were doing this with JQL I would use…

status = Closed AND status was in (“Escalated to Development”) AND status was not in (“Waiting for Software Release”)

How can I do this with EazyBI?

2

I ended up submitting this to as a support issue. Here’s the response I got back. It worked!

Try creating a new calculated measure using this formula:

Sum(
Filter(
DescendantsSet([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateInPeriod(
[Measures].[Issue resolution date],
[Time].CurrenthierarchyMember
)
AND
[Measures].[Issue status] = "Closed"
AND
(
[Measures].[Issue Development Team] = "Development Team A"
OR
[Measures].[Issue Development Team] = "Development Team B"
)
AND
IsEmpty(( --was never ever in status B
[Measures].[Transitions to status],
[transition status].[Status B],
[Time].Currenthierarchy.DefaultMember
))
AND
( --was at least once in status A in any of months
[Measures].[Transitions to status],
[transition status].[Status A],
[Time].Currenthierarchy.DefaultMember
)>0
),
CASE WHEN
[Measures].[issues resolved]>0
THEN
1
END
)

Then use it with the “Time” dimension to count resolved issues by months.

3

Hi @MattBaker

I was just about to give you a similar calculation but seems that my colleague was ahead of me. Answers to questions sent directly to the support team email will always be slightly faster than the community page.
Thank you for sharing the solution and I’m glad to hear it works!

Just a small comment from my side for other eazyBI users who might be searching for a similar solution. To make the calculation faster, it is recommended to add the expression part in the Case Statement. Example below:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateInPeriod(
      [Measures].[Issue resolution date],
      [Time].CurrentHierarchyMember)
  ),
  CASE WHEN
  IsEmpty(
    (
      [Measures].[Transitions to status],
      [Transition Status].[Waiting for Software Release],
      [Time].CurrentHierarchy.DefaultMember   
    )
  )
  AND
  (
    [Measures].[Transitions to status issues count],
    [Transition Status].[Escalated to Development],
    [Time].CurrentHierarchy.DefaultMember
  ) > 0
  THEN
  1
  END
)

Best wishes,

Elita from support@eazybi.com