EazyBi report combining Story and Subtasks

[Brian LaBadie]

I am trying to create a report  that will display the following on a single line

Assignee of Subtask | Story Summary | Subtask Summary | Status id of subtask | (custom field)

I have Assignee under rows , not sure how I can focus only on Sub-task Assignee's, not Story assignee's.

I tried a few things under columns, but I don't think that is right from what I am trying to accomplish

[Janis Plume _eazyBI_]

Hi,

to extend a bit the wonderful answer from @Kat Jansen , if you are using the sub-task level in the report, the parent issue summary can be accessed by the following:

[Issue].[Issue].GetMemberByKey(
  [Issue].CurrentHierarchyMember.Parent.key).Name

Kindly,

Janis, eazyBI support

[Kat Jansen]

Hey, 

For this, you're not going to use the Assignee dimension in the report configuration. Also, you won't be able to pull the summary field into it's own column for Story or sub-task. 

You've got the Issues dimension in Rows, right? With the All hierarchy level members Sub-task Parent option selected?

In Columns you need Measures. To get the sub-task assignee(s) and statuses, you'll need to create a new calculated member. I've included the code below. If your story has more than 1 subtask, then the assignees and statuses will be comma separated.

Any custom field values can be added as long as you've imported them as Properties. They'll be under the Issue properties group in the Measures dimension.

I hope this helps! Let me know if you have any questions.

Issue subtask assignee

CASE WHEN NOT
-- Sub-task keys property stores max 255 charters
IsEmpty([Issue].CurrentHierarchyMember.get('Sub-task keys'))
THEN
-- generate all sub-task keys list from Sub-task hierarchy
Generate([Issue.Sub-task].[Parent].getMemberByKey(
[Issue].CurrentHierarchyMember.Key).Children,
[Assignee].[User].getMemberNameByKey(
[Issue].CurrentHierarchyMember.get('Assignee name')
), ',')
END

Issue subtask status

CASE WHEN NOT
-- Sub-task keys property stores max 255 charters
IsEmpty([Issue].CurrentHierarchyMember.get('Sub-task keys'))
THEN
-- generate all sub-task keys list from Sub-task hierarchy
Generate([Issue.Sub-task].[Parent].getMemberByKey(
[Issue].CurrentHierarchyMember.Key).Children,
[Status].[Status].getMemberNameByKey(
[Issue].CurrentHierarchyMember.get('Status ID')
), ',')
END