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) {
return issue.fields.assignee.displayName;
}
'''
Best,
Ilze / support@eazybi.com
Thank you so much - this worked perfectly!
1 Like
@ilze.leite I am having as similar issue. I created a scope change report. I drilled into the issues added by user. The report is showing some stories are unassigned but when I drill through the unassigned and go into each story, they are assigned to someone. I tried using the code you provided below in the advance settings but it said Missing “return”. Is there something I am doing wrong?
You can create a calcualted field “Current Assignee” also from the Jira import options tab Custom fields. more details on calcauted fields described in the documentation: New calculated fields
Most of the settings (like name, data type, and dimension) could be marked in the user interface, and in the field “Custom JavaScrip code” goes in only the code part with slight adjustment.
if (issue.fields.assignee) {
return issue.fields.assignee.displayName;
}
The settings for the Current Assignee should look like in the picture below.
Best,
Zane / support@eayBI.com
