I tried to create a user defined measure to count how many issues are more than 10 working days in submitted.
I created:
10:
– days in current status from last transition for open issues
IIf(
( [Status].[Submitted] > 0
and
– calculated days in status
DateDiffDays([Measures].[Issue created date], Now()) >10),1,0
)
and late submitted:
sum([Measures].[>10])
The result, when looking for just issue type is:
But, when I look per issue:
it shows late issues, but the summary i 0. Why is this?
How to solve this problem?
