# If condition for assignee's manager wide distribution

**URL:** <https://community.eazybi.com/t/if-condition-for-assignees-manager-wide-distribution/6777>\
**Category:** Questions & Answers\
**Tags:** jira\
**Created:** [May 6, 2021, 6:10pm UTC](https://community.eazybi.com/t/if-condition-for-assignees-manager-wide-distribution/6777 "2021-05-06T18:10:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![VBGYOR](https://community.eazybi.com/letter_avatar_proxy/v4/letter/v/ba9def/32.png) [@VBGYOR](https://community.eazybi.com/u/VBGYOR)\
**Post date:** [May 6, 2021, 6:10pm UTC](https://community.eazybi.com/t/if-condition-for-assignees-manager-wide-distribution/6777/1 "2021-05-06T18:10:44Z")

</div>

Hi all,

Need help in organizing and creating a report in eazyBi

if defect A is assignee to assignee A then count 1 in its manager bucket ‘M’  
If defect B is also assignee to assignee A then count 2 in its manager bucket ‘M’  
If defect C is assignee to asisgnee B then count 1 in its manager bucket ‘M1’

Following should be the result of the query:

| Defect | Assignee | Manager | Status: open | Status: In progress | Status: closed |
| --- | --- | --- | --- | --- | --- |
| A | A | M | 1 | | |
| B | A | M | 2 | | |
| C | B | M1 | | 1 | |

Can someone please help with the query.

Thank you!

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [May 12, 2021, 10:51am UTC](https://community.eazybi.com/t/if-condition-for-assignees-manager-wide-distribution/6777/2 "2021-05-12T10:51:56Z")

</div>

Hi @VBGYOR  
The best would be to import additional property to your **Assignee** dimension (e.g. Manager) and use it to build [a custom hierarchy](https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-AddcustomhierarchiestospecificJira,Confluence,andInsightdimensions), so your assignees are grouped by their managers.  
Here is a similar use case where assignees are grouped by **Teams** :

> [@How to create a Team of assignees](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/6):
>
> Hi there, Since eazyBI version 6.1 and on eazyBI Cloud there is an option to [create a custom hierarchy](https://docs.eazybi.com/eazybi/analyze-and-visualize/custom-hierarchies) in the Assignee, Reporter, Logged by, project and Sprint dimensions. How this could be a solution for your use case? You can create a new hierarchy and group users by user teams in the Assignee dimension. Import team information as Assignee property. You can do this with [additional data import](https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube) from Google Sheets, XLS file, REST API or SQL SELECT to some database. The implementation of addit…

Also, check the latest presentation from my colleagues about **Power-Up Reports With Additional Data Import** where a similar use case is mentioned:  
[https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-AddcustomhierarchiestospecificJira,Confluence,andInsightdimensions](https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-AddcustomhierarchiestospecificJira,Confluence,andInsightdimensions)

Best,  
Gerda // [support@eazyBI.com](mailto:support@eazyBI.com)