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’.
Try creating new calculated measure using this formula:
Not IsEmpty([Measures].[Issue resolution date])
[Measures].[Issue created date],
[Measures].[Issue resolution date]
[Measures].[Days in transition status],
[Transition Status].[Waiting for assistance]
Then use new measure on columns and “Teams” dimension in rows.
Martins / eazyBI