Story and Epic report and filters for updated date

martins.vanags · October 3, 2018, 7:23am

Hi,

To see Story’s updated date, you could try selecting the default eazyBI measure “Issue updated date” from “Measures” dimension (from “Issue properties” bucket)

To calculate story’s epic udpated date, you could create a new calculated member in “Measures” dimension using the following code

CASE WHEN
[Issue].CurrenthierarchyMember.Hierarchy.Name = "Issue.Epic"
THEN
[Issue].CurrentHierarchymember.Parent.get('Updated at')
ELSE
[Issue.Epic].[Parent].GetMemberbyKey(
    [Issue].CurrenthierarchyMember.Key
).Parent.get('Updated at')
END

To calculate Story’s status category try creating a new calculated member in “Measures” dimension using this code

[Status.Category].[Status].GetMemberbyKey(
    [Issue].CurrentHierarchyMember.get('Status ID')
).Parent.Name

Finally, to calculate Story’s epic status category use this code:

CASE WHEN
[Issue].CurrenthierarchyMember.Hierarchy.Name = "Issue.Epic"
THEN
[Status.Category].[Status].GetMemberbyKey(
    [Issue].CurrentHierarchyMember.Parent.get('Status ID')
).Parent.Name
ELSE
[Status.Category].[Status].GetMemberbyKey(
    [Issue.Epic].[Parent].GetMemberbyKey(
      [Issue].CurrenthierarchyMember.Key
    ).Parent.get('Status ID')
).Parent.Name
END

Martins / eazyBI support