Days assigned to current assignee

Questions & Answers
,
1

Hello,

I am trying to create a report where I can see how long an Issue is assigned to the current assignee.
I already defined a custom field for import “current assignee” as described in the documentation:

[jira.customfield_currentassignee]
name = “Current Assignee”
data_type = “string”
dimension = true
javascript_code = ‘’’
if (issue.fields.assignee) {
return issue.fields.assignee.displayName;
}
‘’’

I am now struggling with finishing the report.
What do I need to do to list the days assigned to my current assignees?

Thank you!

2

Hi,

The days assigned to current assignee cannot be calculated using the Javascript-calculated field.
The solution requires a custom formula in eazyBI where we can detect the time when assignee was changed for the last time. We can use the DateDiffDays for counting days since the last assignee change which is the number of days for the current assignee:

DateDiffDays(
  TimestampToDate(
      ([Measures].[Transition to last timestamp],
       [Transition Field].[Assignee])    
  ),
 Now()
)

Kindly,
Janis, eazyBI support

3

Hi,

thank you for your help!
I just checked - does this also take in account past assignee changes?
E.g.:
If user 1 was the assignee for 2 days - then it got changed to user 2 for 3 days - and after that changed again to user 1 for another 2 days.
Will the output be 4 days? With my test report it doesnt seem to have this effect yet.

Thanks again for your help and best regards