How to get count of characters from the Acceptance criteria field?

Questions & Answers
, , , ,
1

I am trying to figure out to create a report for a sprint, that produce a column against a IT Team that shows the number of stories that match the Acceptance Criteria character count > 32. How to create a measure that checks the character count of Acceptance criteria ?

2

HI @subintraj

To return a count of characters in the string use Len, you can read more about it here: Len

I’m using Descendants to iterate through a set of issues: Descendants

Count(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
Len(CoalesceEmpty([Measures].[Issue Acceptance Criteria],""))>32 AND
[Measures].[Issue type] = "Story" AND
[Measures].[Issues created] >0
)
)

Double-check if [Measures].[Issue Acceptance Criteria] is correct.

Kind regards,
Ilze

3

How to add a condition only for stories that has status =Ready to the above formula?

4

Can you help me with these conditions added?

  1. Acceptance Criteria > 32 characters
    AND
  2. Issue Type=STORY
    AND
  3. Story points > 0
    AND
  4. Issue Status = READY

When I added like below, I am getting
Formula is not valid:
No function matches signature ‘ MATCHES ’

Count(Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
Len(CoalesceEmpty([Measures].[Issue Acceptance Criteria],“”))>32 AND
[Measures].[Issue type] = “Story” AND
[Measures].[Issues with story points created] >0) AND
[Measures].[Issue status].Value MATCHES “Ready”
)

5

Hi, @subintraj

I was out of the office.

Now, for the status, don’t use measure. Please use the dimension “Status”:

[Status].[Ready]

Kindly,
Ilze

1 Like