# Counting issues transitioned from specific assignees to another one

**URL:** <https://community.eazybi.com/t/counting-issues-transitioned-from-specific-assignees-to-another-one/20333>\
**Category:** Questions & Answers\
**Tags:** eazybi, mdx\
**Created:** [August 12, 2025, 7:03pm UTC](https://community.eazybi.com/t/counting-issues-transitioned-from-specific-assignees-to-another-one/20333 "2025-08-12T19:03:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marilou](https://community.eazybi.com/user_avatar/community.eazybi.com/marilou/32/10252_2.png) [@Marilou](https://community.eazybi.com/u/Marilou)\
**Post date:** [August 12, 2025, 7:03pm UTC](https://community.eazybi.com/t/counting-issues-transitioned-from-specific-assignees-to-another-one/20333/1 "2025-08-12T19:03:45Z")

</div>

Hi,  
I would like to calculate how many issues per month were transitioned from Assignees XYZ to Assignee A.

Since both _transition to assignee_ and _transition from assignee_ are measures, I can’t make a tuple out of it.  
I would need an equivalent dimension to Transition, but for assignee rather than status.

I built this query

> (  
> Case when  
> ([Measures].[Transitions from issues count]  
> ,[Transition Field].[Assignee],  
> [Assignee].[Vetter])\>0  
> then  
> ([Measures].[Transitions to issues count]  
> ,[Transition Field].[Assignee]  
> ,[Assignee].[Holding])  
> end)

The 1st part of the case when limits issues considered to those that were at some point assigned to the vetters (calculated member aggregating 6 assignee)

The second part (then) counts issues that were transitioned to the Holding assignee amongst those that have been assigned to a vetters.

The problem is that I need to count only issues that were transitioned from vetters to holding, so I think I need a time filter as well… something that would say  
”issues was assigned to vetter AT THE TIME it was transitioned to Holding”

Any ideas on how I can do this?

Thanks you!

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [August 15, 2025, 2:25pm UTC](https://community.eazybi.com/t/counting-issues-transitioned-from-specific-assignees-to-another-one/20333/2 "2025-08-15T14:25:45Z")

</div>

Hi @Marilou

You are right. With standard tuple calculations, it is not possible to calculate issues by specific assignee transitions due to the way assignee changes are stored in the eazyBI db.

Here, the workaround can be two new global calculated fields: one of them would be a dimension which will get values from the issue changelog, and the other - a new measure that you can use with new dimension to count issues with assignee change.

Determining new global calcualted fields from eazyBI [advanced settings](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/advanced-settings-for-custom-fields) requires Jira system admin rights.

You can use this code in advanced settings:

```auto

[jira.customfield_as_trans]
name = "Assignee transition"
data_type="string"
dimension=true
separate_table=true

[jira.customfield_as_chcnt]
name="Assignee change count"
data_type="integer"
measure=true
multiple_dimensions=["Assignee transition","Time"]
javascript_code='''
var result=[];
for (hist of issue.changelog.histories) {
  for (item of hist.items){
    if (item.field=="assignee") {
        result.push((item.fromString?item.fromString:"") + " => " 
                     + (item.toString?item.toString:"") + ","
                     + hist.created.substr(0,10) + ",1"
                     );
    }
  }
}
return result.join("\n");
'''

```

After that make sure you import Assignee transition with **dimension** checkbox and “Assignee change count” with **measure** checkbox from the eazyBI import options page

 ![image](https://community.eazybi.com/uploads/default/original/2X/b/bb92fce6a21953af55f72ebaac9b968a0af0cff0.png)

Next you can use the new measure with new dimension to count changes by specific assignee change.

 ![image](https://community.eazybi.com/uploads/default/original/2X/e/ef86cacc02adcc621da0f318d43d93214e79bb54.png)

eazyBI support / Martins

---

<div class="post-metadata">

**Author:** ![Marilou](https://community.eazybi.com/user_avatar/community.eazybi.com/marilou/32/10252_2.png) [@Marilou](https://community.eazybi.com/u/Marilou)\
**Post date:** [August 18, 2025, 4:04pm UTC](https://community.eazybi.com/t/counting-issues-transitioned-from-specific-assignees-to-another-one/20333/3 "2025-08-18T16:04:28Z")

</div>

Hi Martins,

thank you for your script, I’ve sent a request to my Jira admin to add it!

Meanwhile, I made this query (With the help of eazybi AI) that seems accurate, but it’s so complex I can’t add all I need before it stops loading.🫠

> Count(  
> Filter(  
> DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),  
> – Check if issue has transitions to triagebucket  
> ([Assignee].[triagebucket], [Measures].[Transitions to assignee]) \> 0  
> AND  
> – Check if issue has transitions from one of the specific assignees  
> Sum(  
> {  
> [Assignee].[Person1],  
> [Assignee].[Person2],  
> [Assignee].[Person3],  
> [Assignee].[Person4],  
> [Assignee].[Person5],  
> [Assignee].[Person6]  
> },  
> [Measures].[Transitions from assignee]  
> ) \> 0  
> )  
> )

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [August 20, 2025, 6:53am UTC](https://community.eazybi.com/t/counting-issues-transitioned-from-specific-assignees-to-another-one/20333/4 "2025-08-20T06:53:22Z")

</div>

@Marilou

Please export and share the definition of the report where you try adding this calculated measure.

I believe it can be optimized to make it calculate results faster.

Martins / eazyBI