Calculate the number of issues whose status duration is greater or less than the threshold. This threshold is set differently according to the priority.
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).
DateInPeriod([Measures].[Issue created date],
[Transition Status].[L1 Doing]
[Measures].[Days in transition status]*24 --to convert into hours
WHEN [Measures].[Issue priority] = "highest"
WHEN [Measures].[Issue priority] = "high"
WHEN [Measures].[Issue priority] = "medium"
WHEN [Measures].[Issue priority] = "low"