Transition to first assignee

[gerda.grantina]

Hi @varvariand,
You can check similar answers here to get the first user assigned to issue:

first user assigned to issue

Hi, There are two ways how to calculate the first assignee: MDX way by creating a new calculated measure: code: CASE WHEN [Issue].CurrentHierarchyMember.Level.Name = "Issue" THEN [Assignee].[User].GetMemberbykey( Order( Filter( Descendants([Assignee].CurrentHierarchyMember,[Assignee].[User]), [Assignee].CurrentMember.Name <> "(unassigned)" AND ( [Transition field].[Assignee], [Measures].[Transitions from],…

and here if you want also to have time for first assignment:

Time to first assignment (but accounting for issues assigned during creation)

I’ve found a number of quite useful tips re: how to capture the number of days elapsed between (created date) and (First Assignee Date), as “Days to First Assignment”. But the solutions I’ve found so far are built on the assumption that an issue is NOT assigned during its creation. I currently have a [First Assignee Date] calculated member defined as: – First Assignee date TimestampToDate( ( [Measures].[Transition to first timestamp], [Transition field].[Assignee], [Time].CurrentHierarchy…

best,
Gerda // support@eazyBI.com