Hi Community!
I need help in creating a specific report which I detail below:
I need to add from 2 different projects, the total amount of issues which are being worked on by one person of the team.
There are a couple of difficulties as in the two projects issues are kind of different. This is what I need to add:
From Project A
Defects per Reporter
+
From Project B
Sub-task per Assignee
My end goal is to get a Table Report which shows all the names of the team members (which can be Assignees or Reporters dimension based on the Project) with their exact number of tickets (the sum stated on top)
In this case in Project A people in the team appear in the tickets as Reporters and in Project B the same people can appear as Assignees.
I am really struggling on how to approach this. Any help is appreciated!
Thanks!!
Hi @Mateo_Colombo
In this case, you could try defining a new calculated field using Javascript from advanced settings to extract the Assignee or Reporter value into one common field and import that field as separate dimension from the import options page.
[jira.customfield_asorre]
name = "Assignee or Reporter"
data_type = "string"
dimension = true
multiple_values = true
split_by = ","
javascript_code = '''
var userList = [];
if (issue.fields.assignee) {
var username = issue.fields.assignee.displayName;
userList.push(username)
}
if (issue.fields.reporter) {
var username = issue.fields.reporter.displayName;
userList.push(username)
}
if (userList){
issue.fields.customfield_asorre = _.uniq(userList).join(",");
}
'''
When the field is imported as a dimension, you could use this new dimension in your report (see attached image below).
And create new calculated measure to count the tickets from two projects as per your requirement.
Sum(
Filter(
DescendantsSet([Assignee or Reporter].CurrentMember,[Assignee or Reporter].[Assignee or Reporter]),
[Measures].[Issues created]>0
),
(
[Measures].[Issues created count],
[Project].[A],
[Assignee].[User].members.item(
[Assignee or Reporter].CurrentMember.name
),
[Issue Type].[Defect],
[Assignee or Reporter].CurrentHierarchy.DefaultMember
)
+
(
[Measures].[Issues created count],
[Project].[B],
[Reporter].[User].members.item(
[Assignee or Reporter].CurrentMember.name
),
[Issue Type].[Sub-task],
[Assignee or Reporter].CurrentHierarchy.DefaultMember
)
)
Martins / eazyBI
Thank you so much Martins!!
It works perfectly!
