After the issue's assignee form GroupA translates into GroupB, the counts of issues that have not been translated out GroupB for more than 7 days

Questions & Answers
1

Hello

I would to know , after the issue’s assignee form GroupA translates into GroupB, the counts of issues that have not been translated out GroupB for more than 7 days.

Thanks very much.

2

Hi,

In eazyBI, transitions between Jira users groups are not tracked, but you may want to count issues having been transited more than 7 days ago by any of the user group users.
Notice the users will be treated as the user group users by their current existence in the user group.

For that, you may create a measure that checks the date of the last transition from the assignee and then counts issues who has it more than 7 days ago:

NonZero(Count(
Filter(
   Descendants([Issue].CurrentMember, [Issue].[Issue]),
   DateDiffdays(
    TimestampToDate(([Transition Field].[Assignee],
        [Measures].[Transition from last timestamp])),
    now())>7
 )
))

Then put together the report: select “Assignee Group” in Pages, the measure in columns and projects in rows:

image
image1634×834 65.5 KB

Best,
Ilze, support@eazybi.com