I want to pull first assignment and reassignments to a particular group

Questions & Answers
1

Hi,
We have JSM v4.15.0 instance where we eazyBI v6.3.0 installed.
The requirement is that we need to find " how many tickets were assigned to a group called ‘xyz’ on creation plus how many tickets were routed back to ‘xyz’ group after they had assigned those tickets to some other group. Means the reassignment/second assignment".
How can we have this report using eazyBI on monthly basis?

Regards,
Muddassir Quazi

2

Hi,

Please advise.

Regards,
Muddassir Quazi

3

Hi @muddassir,
In eazyBI, transitions between Jira users groups are not tracked.
But you may want to count issues having been assigned to the user on the issue creation moment and then use the Assignee group to filter by ‘xyz’ group.

NonZero(
  Count(
    Filter(
       Descendants([Issue].CurrentMember, [Issue].[Issue]),
         DateDiffMinutes(
          [Measures].[Issue created date],
          TimestampToDate(([Transition Field].[Assignee],
              [Measures].[Transition to first timestamp])) 
          )=0
     )
  )
)

To count issues that have been routed back to ‘xyz’ group you can count issues that have transitioned to assignee more than once. This will count also issues that have been re-assigned to another user that is in the same ‘xyz’ group.

NonZero(
  Count(
    Filter(
       Descendants([Issue].CurrentMember, [Issue].[Issue]),
          [Measures].[Transitions to assignee]>1
     )
  )
)

best,
Gerda // support@eazyBI.com

1 Like