Calculate the number of issues whose status duration is greater or less than the threshold. This threshold is set differently according to the priority.
Example:
There are 10 issues and the workflow is TODO , L1 doing , done , upgraded , L2 doing
The priorities are hightest, high, medium, low.
For L1 teams
Need to count the number of status (TODO + L1doing) duration greater than 1h and less than 1h in the hightest document
The number of high document status (TODO + L1 doing) duration greater than 2h and less than 2h
Medium In the document, the status (TODO + L1doing) duration is greater than 4h and the number of less than 4h
The number of status (TODO + L1 doing) duration in the low document is greater than 10h and less than 10h
Welcome to eazyBI community.
In this case, you could try creating new user-defined calculated measure using this formula (and integerformatting).
Sum(
Filter(
DescendantsSet([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateInPeriod([Measures].[Issue created date],
[Time].CurrentHierarchyMember
)
),
CASE WHEN
[Measures].[Issues created]>0
AND
Aggregate({
[Transition Status].[TODO],
[Transition Status].[L1 Doing]
},
[Measures].[Days in transition status]*24 --to convert into hours
)
>
CASE
WHEN [Measures].[Issue priority] = "highest"
THEN 1
WHEN [Measures].[Issue priority] = "high"
THEN 2
WHEN [Measures].[Issue priority] = "medium"
THEN 4
WHEN [Measures].[Issue priority] = "low"
THEN 10
END
THEN
1
END
)