I have created report which is showing total Epic, Story, Defect and sub-task based components(screenshot).
I would like to add two more column in my report. Could you help me with logic.
- Stories without Epics
- Stories without Sub task
Could you help me with calculated field formula like this:
NOT isEmpty([Issue].CurrentMember.Get('Epic Link'))
Here is what you can try:
- to count stories without epics you can try to additional issue hierarchy from advanced settings:
Additional Issue hierarchies
Then press “import” to create this hierarchy in “Issue” dimension (it will be created automatically once data is imported)
Then create a new calculated measure using this formula:
ChildrenSet([Issue.Epics without project].[(none)]),
- To count stories without sub-tasks try this formula in calculated measure (for this measure manually select “integer” format):
[Measures].[Issue type] = "Story"
isEmpty([Measures].[Issue sub-task keys])
DateInPeriod([Measures].[Issue created date],
Martins / eazyBI support