issuetype CHANGE FROM "Ticket" TO "Story"

Questions & Answers
1

We need to know the date that the issue “Ticket” (service desk) change (move) to “Story” (Jira Software, another projetc).

2

Here is an example formula checking if the first time when the issue type Story was was set it was moved from the type Ticket and shows this date:

CASE WHEN
[Measures].[Issue type] = "Story"
THEN
 CASE when 
   ([Measures].[Transition from last timestamp],
    [Transition Field].[Issuetype],
    [Issue Type].[Ticket],
    [Time].CurrentHierarchy.DefaultMember)
   =
   ([Measures].[Transition to first timestamp],
    [Transition Field].[Issuetype],
    [Issue Type].[Story],
    [Time].CurrentHierarchy.DefaultMember)
 Then 
  TimestampToDate(
   ([Measures].[Transition from last timestamp],
    [Transition Field].[Issuetype],
    [Issue Type].[Ticket],
    [Time].CurrentHierarchy.DefaultMember)
  ) 
 END 
END

Daina / support@eazybi.com

1 Like