Measure.Transitions from assignee

Questions & Answers
1

Hello

I have a report and I want to count the number of Jira tickets that were transferred outside of our Jira group. That is: From an assignee in our group to another assignee (outside of our group).

I have created this custom metric

Filter(
[Assignee].[User].Members,
CoalesceEmpty([Assignee].CurrentMember.Get(‘Groups’), ‘’)
MATCHES ‘.(^|,)(Tribe_Group)($|,).’
),
[Measures].[Transitions from assignee]

But the problem is that eazybi sometimes counts double or triple times if a jira ticket has been transferred between the team member of the same group. (For example for this movement
A–>B–>A–>C it will count 3 times)

Can someone provide an alternative more accurate query?

Thank you for your time

2

Hello @akatsikad

When checking the issue history log for assignee changes, there are no details about the groups, which would require a calculated field.

That makes it impossible to know which groups a user belonged to when assigned to a ticket.
Therefore, you can’t calculate the transitions to/from group users, unfortunately.

no group
no group1270×1024 89 KB

The only way I can imagine is a Jira scripted field that returns integer 1 for each date when ticket was assigned to user in a different group, but I can’t find any examples to share for such scripted field.

Martins / eazyBI