Hello,
I have figured out how to get a measure for the time to first assignee on an individual issue but not at a project level.
Essentially I would like to be able to see the Average of the amount of time it takes between an issue being created and it being assigned. I was able to accomplish this by the following:
First Assignee Date
TimestampToDate(
(
[Measures].[Transition to first timestamp],
[Transition field].[Assignee],
[Time].CurrentHierarchy.DefaultMember
)
)
and then …
Time to First Assignee Workdays
DateDiffWorkdays([Measures].[Issue created date],
[Measures].[First Assignee Date])
But this only allows me to see the measure when I am looking at individual Issues. I’d like to see something like what I see on this eazyBI sample: Time to resolution Cumulative issues by request type - Issues - Jira Service Management Demo - eazyBI where you can see by request type the amount of time. I am not looking for cumulate time, just averages by project and/or request type (CF).
Is this possible?
Right now it is all blank. If I add issue in as a Row then it has the time at the issue level but not at the project level. When I do an average with Time to First Assignee Workdays it still does not work. Ideas?