Assignee between statuses To Do and In Progress

Questions & Answers
1

Hey everyone!

I need a report to get assignees that were on the issue between statuses To Do and In Progress, transitions are global so I can’t tie it to transition, gotto be statuses. Obviously assignee could change so has to be historical value.

Any ideas? I couldn’t find anything related

this is for DC and BI version is 8.0.2

2

Hi,

The following formula generates list of assignees that were assigned during a specific status (In Progress):

Generate(
  Filter([Assignee].[User].Members,
  -- assigned user that was when transitioned to In Progress
    ([Measures].[Transitions to status],
    [Transition Status].[In Progress])
    +
  -- user that was assigned during the In Progress
    ([Measures].[Transitions to assignee],
    [Transition Status].[In Progress])
    >0
  ),
  Cast([Assignee].CurrentMember.GetCaption as String),
  CHR(10)
)

Kindly,

Janis, eazyBI support