Pull Transitions by Current Assignee, not Assignee at Time of Transition

I have created a report that track the number of times a ticket is moved from Peer Review to In Progress. I want this report to pull by the current assignee, however, it appears it’s pulling by the assignee at the time of the transition. For example, Denis should not have transitions assigned to him as those were moves he made but the ticket currently is assigned to someone else.

This is my formula for the Transition to Status During Sprint calculated measure.
([Measures].[Transitions to status],
[Sprint Status].[Active])

I’m at a loss on how to get it to count for the current assignee in lieu of the assignee at the time of the transition. Any help would be much appreciated.

Hi @Tina_McCoy

Yes, if you filter by Assignee dimension, then the assignee who was the issue assignee at the transaction moment, is taken into account.

To count issues by the current assignee, you may want to import the current assignee dimension (that won’t check historical assignees at all). To do that, create a JavaScript calculated custom field to retrieve the current assignee, import it as a separate dimension “Current Assignee” and then use it for filtering in the report instead of the original Assignee dimension.

There is a similar example with a step-by-step instruction where the current issue type is retrieved: Calculated Measure shows issues that have moved issue types - #2 by martins.vanags

Modify the JavaScript code to retrieve assignee value instead of issue type, the advanced settings for the current assignee would be:

[jira.customfield_currentassignee]
name = "Current Assignee"
data_type = "string"
dimension = true
javascript_code = '''
if (issue.fields.assignee) {
issue.fields.customfield_currentassignee = issue.fields.assignee.displayName;
}
'''

Best,

Ilze / support@eazybi.com

Thank you so much - this worked perfectly!

1 Like