Find "reopened" issues

Hi,

to get all issues having transitioned to “reopen” statuses, you may use “Transition” dimension together with a measure “Transitions to status issues count” (Measures > Default members > Distinct issues count).

In “Transition” dimension, create a calculated member, aggregating all transitions that clear issue resolution.

Then either select this “Transition” member in rows and the measure “Transitions to status issues count” in columns, or create a measure with a tuple (and add Time Default member there to look for transitions to reopened status regardless of selected Time):

    ([Transition].[All transitions to "reopen"],
     [Measures].[Transitions to status issues count],
     [Time].CurrentHierarchy.DefaultMember)

Ilze / support@eazyBI.com