Need to build a calculated member that will hold the values of all the assignee of issues tagged under a Epic. I know we can build this to show a table of epics and when you expand it, it will show the subsequent parent and subtasks with the assignee. But we need something very simple as shown below.
Epic 1 Assignee 1, Assignee 2
Epic 2 Assignee 2, Assignee 3, Assignee 1
Epic 3 Assignee 4, Assignee 1
The assignee displayed across each Epic will be the assignee of the epic + assignee of subsequent parent and sub task issues. Is this possible? If yes, how can we achieve this?
In this case, you could create a new calculated measure (with integer format) in “Measures” dimension that would generate all assignees of issues that belog to epic.
Try this code:
[Assignee].CurrentMember.Name <> "(unassigned)"),
[Assignee].CurrentMember.Name, ', '
That would generate a string from unique assignees.
It may mislead you when you use it with “Time” dimension as it would generate assign
Martins / eazyBI
Thats really cool @martins.vanags. This is exactly what I wanted. Thanks for your help.