Count Stories with Blank Acceptance Criteria

Questions & Answers
1

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?

2

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

3

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]))

4

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
5

Hi Martins,

How we need to import the ‘‘Acceptance Criteria’’ in case it is not imported as a separated dimension?

for us it is not recognized by the autocomplete.

Thank you,
Seif

6

@Seif_Eddine

You can try using advanced settings and add the “dimension = true” line to the field configuration.
https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/advanced-settings-for-custom-fields

Then eazyBI should let you import the field as a separate dimension from the import options page.

Martins /eazyBI