Count fastest team that resolve issues

Questions & Answers
1

Hi guys,
I have a case that need to measure.

I want to display top 10 Teams (insight objects) that are assigned to the ticket through the issue lifecycle and they resolve issue.

So I assume that will be rows with the Teams names and Column with the time from for example ‘Working on’ > ‘Done’ - Excluding status: ‘Waiting for assistance’.

Any suggestions?

2

@AdamChauturewicz

Try creating new calculated measure using this formula:

Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue resolution date])
),
CASE WHEN
[Measures].[Issues resolved]>0
THEN
DateDiffDays(
	[Measures].[Issue created date],
	[Measures].[Issue resolution date]
	)
-
(
[Measures].[Days in transition status],
[Transition Status].[Waiting for assistance]
)
END
)

Then use new measure on columns and “Teams” dimension in rows.

Martins / eazyBI