Average workdays in transition status for issues resolved over a period of time

Questions & Answers
1

Hi,

I am new to EazyBI, am running productivity reports for the team.

I would like to get the Average workdays in transition status (over the ticket’s lifespan), but only with issues being resolved over a period of time (tickets resolved in June i.e. resolved >= 2022-06-01 AND resolved <= 2022-06-30)

Realized I should not be using “Time” dimension for filtering, is there any ways to achieve this?

Many thanks!

image

2

@clsi

In this case, you would need to create a new calculated measure.
Try the following formula

Avg(
Filter(
DescendantsSet([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateInPeriod(
[Measures].[Issue resolution date],
[Time].CurrenthierarchyMember
)
),

CASE WHEN
[Measures].[Issues resolved]>0
THEN
(
[Measures].[Days in transition status],
[Time].Currenthierarchy.Defaultmember
)
END
)

Then select the “Jun 2022” from the “Time” dimension page filter.

Note, the measure “Days in transition status” (used in formula) won’t include time in the current status.
It includes time only for completed statues (that have finished).

If you need to include the time in current status try searching the measure “Days in transition status until now” in our public demo account and copy the formula from there: Chart Types - Jira Demo - eazyBI

Then change the formula above and replace “Days in transition status” with “Days in transition status till now”.

Martins / eazyBI