Hello! I’m trying to use a CASE statement to match against an epic’s status:
DateCompare([Time].CurrentHierarchyMember.StartDate, now()) < 0
CASE WHEN [Status].[Status].GetMemberNameByKey([Issue].CurrentHierarchyMember.get(‘Status’)) = “To Do”
–[Issue].CurrentHierarchyMember.get(‘Status ID’) = “To Do”
–[Status].CurrentMember.name = ‘TO DO’
I’ve had no luck with executing those statements- could you help with this?
This expression would work only when individual issues are on report rows because it checks the status of each visible issue.
To make this work, you might want to import “Epic Status” as a separate dimension so that eazyBI could check on related epic status instead of issue status.
Please see how to import epics status as dimension here: Issue link field dimensions.
Update the calculation using the new link field dimension “Epic Status”. Now you can sum up the open issues with respective coefficients according to each epic status
--for epics in To Do status, use coefficient 14.8
[Epic Status].[To Do]) * 14.8
--for the rest of the epics use coefficient 7.4
--all epic issue statuses except for To Do
[Epic Status].[To Do]
[Measures].[Open issues] * 7.4