# How to list all assignees of an issue in particular status

**URL:** <https://community.eazybi.com/t/how-to-list-all-assignees-of-an-issue-in-particular-status/4104>\
**Category:** Questions & Answers\
**Tags:** jira-reports, jira-service-desk, jira\
**Created:** [April 7, 2020, 11:47am UTC](https://community.eazybi.com/t/how-to-list-all-assignees-of-an-issue-in-particular-status/4104 "2020-04-07T11:47:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![agupta](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/e8c25b/32.png) [@agupta](https://community.eazybi.com/u/agupta)\
**Post date:** [April 7, 2020, 11:47am UTC](https://community.eazybi.com/t/how-to-list-all-assignees-of-an-issue-in-particular-status/4104/1 "2020-04-07T11:47:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![janis.plume](https://community.eazybi.com/user_avatar/community.eazybi.com/janis.plume/32/8826_2.png) [@janis.plume](https://community.eazybi.com/u/janis.plume)\
**Post date:** [April 20, 2020, 4:38pm UTC](https://community.eazybi.com/t/how-to-list-all-assignees-of-an-issue-in-particular-status/4104/2 "2020-04-20T16:38:14Z")

</div>

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](https://community.eazybi.com/uploads/default/original/2X/5/5e18dc2a31964084de7463d2ecd8c2d408f04278.png)

Kindly,  
Janis, eazyBI support

---

<div class="post-metadata">

**Author:** ![morjo02](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/b19c9b/32.png) [@morjo02](https://community.eazybi.com/u/morjo02)\
**Post date:** [October 9, 2022, 5:08pm UTC](https://community.eazybi.com/t/how-to-list-all-assignees-of-an-issue-in-particular-status/4104/3 "2022-10-09T17:08:44Z")

</div>

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??