Hi,
I am trying to develop the below report in EazyBi but I couldn’t match exactly so need help pls
Please let me know if its possible to do it in EazyBi
Thanks
Vas
@martins.vanags would you able to help me with this ?
I am looking for additional filters for
- Story and Epic updated date,
- Story and Epic status category.
Thanks
Vas
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
Hi @martins.vanags,
Thanks for your quick response.
I am able to get the columns as you suggested:
Is there a way we can add filter on the top (pages) for these columns.
Ex:
- Filter for Story updated date
- Filter for Epic updated date
- Filter for Story Status category
- Filter for Epic Status category
