Number of Resolved Issues Per Month which have at somepoint been assigned to a specific user

Hi I’m an Eazy BI and MDX Newbie,

I’m looking to produces a report which has:

-for each of the previous 12 completed months ( This bit’s working fine as I’ve added in a calculated dimension
Aggregate( [Time].[Month].DateMembersBetween(‘13 months ago’, ‘1 month ago’))

-The number of issues resolved,
-where User X has been the assignee at any point in the tickets history.

I’m thinking it’s probably User defined measure, utilising Transition to Assignee, but I’m a little stuck.

Thanks

Hi Joy,
Welcome to the eazyBI community!

Your idea about “Transition to Assignee” was correct! The formula for showing number of resolved issues that have ever been assigned to a specific (hardcoded) user could be:

Sum(
  Filter(
    DescendantsSet([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod(
      [Measures].[Issue resolution date],
      [Time].CurrentHierarchyMember
    )
    -- if you want to group issues by current assignee:
    AND ([Measures].[Issues resolved] > 0)
  ),
  CASE WHEN
    (
      [Assignee].[USER X], -- change to real user name 
      [Measures].[Transitions to assignee],
      [Time].CurrentHierarchy.DefaultMember
    ) > 0
  THEN
    ([Measures].[Issues resolved], [Assignee].CurrentHierarchy.DefaultMember) * 1
  END
)

This formula shows issues that have been resolved in the report Time period
AND have been assigned to one specific user at least once in the lifetime.

Depending on your report layout and specific requirements it might need some updates (for example, if you want to choose the user X dynamically from page filter).

Let me know if that works for you or if you have more questions.

Kindly,
Ilze