Count Stories with Blank Acceptance Criteria

I am new to eazyBI, and am trying to create a calculated field that will count the number of user stories assigned to a given release that have empty Acceptance Criteria fields. This is wrong, but is as close as I have gotten so far:

Count
(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Story]),
IsEmpty([Measures].[Issue Acceptance Criteria])
)
)

Can anyone help?

Hi Bill,

You are almost there.
Try this code:

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]), --goes through all issues
[Measures].[Issue type] = "Story" --to filter by issue type
AND
IsEmpty([Measures].[Issue Acceptance Criteria])--empty accptance criteria
AND
[Measures].[Issues created]>0 --adds other context
)
)
)

Martins / eazyBI support

I’ve similar requirement. Want to count issues (bug, defect, sub defect) where acceptance criteria field value is empty?

A measure can be created like below?

Count(IsEmpty([Measures].[Issue Acceptance Criteria]))

Hi @Sarath
The quickest calculation would be if you have imported your custom field “Acceptance Criteria” as a separate dimension (viaimport options)

Then you could use a tuple when creating a new calculated measure

Try this code:

(
[Measures].[Issues created],
[Acceptance Criteria].[(none)]
)

But there is another way (without having the field as a dimension)

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]), --goes through all issues
IsEmpty([Measures].[Issue Acceptance Criteria])--empty accptance criteria
AND
[Measures].[Issues created]>0 --adds other context
)
)
)

Martins / eazyBI team

1 Like