Trouble getting an historical time in status report

Questions & Answers
1

I am looking to determine if we are efficiently working issues. What I would like to see is over time, how much time do issues spend “In Progress Statuses”
Defined as:
Aggregate({
[Transition Status].[In Progress],
[Transition Status].[Resolved],
[Transition Status].[In Review],
[Transition Status].[Reopened]
})

For issues closed in each month/sprint/whatever how much duration a closed issue spent being worked. I am trying to determine if new processes are slowing the progression of issues.

I tried:

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

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

This was copied from anther thread here. When using this, I am not getting ant data back. I would also like to be able to see this for individual issues so we can retrospective, but I can always drill through if I need to.

image
image779×370 15.9 KB

2

I am able to get numbers if I take the transitions status out of pages. However, it does not satisfy my requirements.

3

Hi @EdP

Thanks for posting your question!

I suggest considering using the Issue Cycles for your use case. Here is a documentation page that will guide you how to import the issue cycles - Issue cycles. You should simply add the status you want to group together and once you import the Issue Cycle, eazyBI will import several measures and properties that you can use in your report, including the average time the tickets spent on those statuses. You can also check out this community post - Count issues that passed by certain status and not closed - #2 by QiZhang that has some screenshots as well.

Best wishes,

Elita from support@eazybi.com