How to list all assignees of an issue in particular status

Questions & Answers
, ,
1

I want to see how many times the tickets are reassigned in a particular status
or all the assignee assigned the issue in a particular status

Regards
Aakanksha

1 Like
2

Hi Aakanksha,

There is the standard measure of “Transitions to Assignee” that can be used for this case.
The number of changes during the In Progress status is the following formula of the custom measure:

([Measures].[Transitions to assignee],
[Transition Status].[In Progress])

The list of assignees can be derived further with one more custom measure:

Generate(
  Filter([Assignee].[user].Members,
    ([Measures].[Transitions to assignee],
    [Transition Status].[In Progress])>0 OR
    ([Measures].[Transitions from assignee],
    [Transition Status].[In Progress])>0
  ),
  [Assignee].CurrentMember.Name,
  "," 
)

An example report looks like this:

image
image1538×354 34.1 KB

Kindly,
Janis, eazyBI support

3

Thank you for sharing. Can I use the calculated field to capture assignee history for a specific Jira Status for all Issues resolved and done??