Statistics on the team's handling of issues with different priorities

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

The expected data is shown below

1 Like

Hi @vivi

Welcome to eazyBI community.
In this case, you could try creating new user-defined calculated measure using this formula (and integer formatting).

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
)

Martins / eazyBI

1 Like