Total number of stories with a cycle time greater than 10

Questions & Answers
1

Hi,
I am trying to create a report and I am stuck on how the data is presenting itself. I want to get the total count of issues that are greater than 10 days. Every time it pulls it will pull all the issues, a #1, or nothing at all. Any ideas?

Engineering Cycle time =
(
[Transition Status].[DEV Status],
[Measures].[Average workdays in transition status]
)

THEN…

ECT > 10 Days (# of issues with an engineering cycle time > 10 days)=
CASE WHEN
[Measures].[Engineering Cycle Time* ] > 10.00
THEN
[Measures].[Engineering Cycle Time* ]
END

***Note: Looking for the total number of stories.

2

Hi,

The solution requires the iteration over all issues and filtering them by the condition on your cycle time. The formula would be like this:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Cycle time]>10
  )
))

Kindly,
Janis, eazyBI support