Resolved tickets shown only when "unresolved" is set

Questions & Answers
1

Hi,
I built a report showing the overall number of resolved tickets per month and the number of said tickets which went into a specific status during their life cycle. I used the information given here as start and several community posts to achieve this. In order to get the number of resolved tickets which have been in a special status before I use:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Issues resolved]>0
  AND
  ([Measures].[Transitions to status],
  [Transition Status].[Special Status],
  [Time].CurrentHierarchy.DefaultMember)>0
  )
))

I also get the number total resolved tickets with standard measure, the difference between those two should be the number of resolved tickets which never went to Special Status.

Since I do not want to count resolutions like Duplicate or Cancelled I added a page and chose multiple fitting resolutions. I noticed that I have to include (unresolved) to get correct numbers as the majority of “special status tickets” is not counted otherwise. These tickets clearly do have a resolution date and are resolved. Why is that? What am I missing here?

2

Hi Maiko,

The measure “Transitions to status” is a historical measure and issues were most likely unresolved when they were in Special Statuses (when issue change history is enabled, the value change history is enabled automatically for the following dimensions: Sprint, Assignee, Issue type, Resolution, Priority, Flagged)

To fix this for your report, you need to tell the part of formula to ignore selected Resolution page values by adding [Resolution].CurrentHierarchy.DefaultMember in the tuple:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Issues resolved]>0
  AND
  ([Measures].[Transitions to status],
  [Transition Status].[Special Status],
  [Time].CurrentHierarchy.DefaultMember,
  [Resolution].CurrentHierarchy.DefaultMember)>0
  )
))

I hope this helps.

Best,
Ilze

3

Hello @ilze.krauze ,

Thank you for your replay. First of all, yes, it works, I appreciate that. But I noticed that I do have to look deeper into tuples and pages.