Count of issue which assignee translate from one group to another group

[xuelibing]

Hi

From issue history, I would need to get the count of issue that assignee translate from one group to another group."
I used 「Transitions to assignee」「Transitions from」「Assignee Group」.
It works,but also counted when assignee translate within the group,it not necessary。

Thank you!

[daina.tupule]

eazyBI counts transitions for assignees. Those measures include any assignee change. Therefore, they do not represent scope changes for a group.

You would like to use more complex calculations to track changes within a group. Here are some examples of this.
Scope changes. The difference in a count of issues for the assignee group. It would represent a difference between incoming and outgoing issues. You can use measure Issues history and check the difference in this period compared to the previous period:

[Measures].[Issues history]
-
([Measures].[Issues history],
[Time].CurrentHierarchyMember.PrevMember)

Incoming issues, it should show issues that were not in the previous period but were added at some point in this period:

NonZero(SUM
(Filter(
 Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
     IIF([Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember,
     1,
 DateBeforePeriodEnd(
   [Issue].CurrentHierarchyMember.Get('Created at'),
   [Time].CurrentHierarchyMember)
 AND
   DateAfterPeriodEnd(
   [Issue].CurrentHierarchyMember.Get('Updated at'),
   [Time].CurrentHierarchyMember.PrevMember))
 ),
   CASE WHEN
   CoalesceEmpty(([Measures].[Issues history],
   [Time].CurrentHierarchyMember.PrevMember), 0) = 0
   AND 
   [Measures].[Transitions to] > 0
   THEN 1 END
))

Removed issues. They could be coming in/out in this period or just went out this period.

NonZero(SUM
(Filter(
 Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
     IIF([Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember,
     1,
 DateBeforePeriodEnd(
   [Issue].CurrentHierarchyMember.Get('Created at'),
   [Time].CurrentHierarchyMember)
 AND
   DateAfterPeriodEnd(
   [Issue].CurrentHierarchyMember.Get('Updated at'),
   [Time].CurrentHierarchyMember.PrevMember))
 ),
   CASE WHEN 
   CoalesceEmpty(
   ([Measures].[Issues history],
   [Time].CurrentHierarchyMember.PrevMember), 0)
   =
   (([Measures].[Transitions from], [Transition Field].[Assignee])
   -
    ([Measures].[Transitions to], [Transition Field].[Assignee]))
   THEN 1 END
))

Daina / support@eazybi.com