# How to create a Team of assignees

**URL:** <https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012>\
**Category:** Questions & Answers\
**Tags:** data-mapping\
**Created:** [October 18, 2019, 8:29am UTC](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012 "2019-10-18T08:29:08Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [September 10, 2020, 3:40pm UTC](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/6 "2020-09-10T15:40:47Z")

</div>

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.

1. 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 additional data remains the same regardless of the data source (REST API, SQL, or CSV).  
The source data should contain at least two columns:

2. The data mapping screen might look like in the picture below. Make sure to fill in **Dimension** and **Level** information so eazyBI could find users in the Assignee dimension and create a new property.  

3. After successful data import, you will have a new property for each Assignee user. From my example, it is “Assignee Squad”. Now you can use this property to group users by its value.

4. Go to Assignee dimension, section All hierarchy level members, and chose option **“Add custom hierarchy”**. eazyBI will offer you available user properties by which you can build the new hierarchy.  

Please see the documentation for more details on how to create a custom hierarchy: [Custom hierarchies](https://docs.eazybi.com/eazybi/analyze-and-visualize/custom-hierarchies)

Hope this new functionality will give you more freedom on organizing users and projects.

P.S. If you would like to get rockets and unicorns in your report as well, check out the Community post on how to use **Markdown** in measure formatting 😉

> [@Measure formatting (markdown and custom)](https://community.eazybi.com/t/measure-formatting-markdown-and-custom/5157):
>
> In this article, I will show a few tips and tricks on how it is possible to format the measures. In eazyBI, there are two interesting ways on how to [format measures](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Formatting) to get a different appearance. First is our newest formatting option, Text-\>Markdown (available on Cloud and starting from the eazyBI version 6.1), and second is a Custom format with which you can change the formatting of the measure. [eazyBI\_Markdown] Markdown You can use [Markdown](http://en.wikipedia.org/wiki/Markdown) formatting to show a rich text (bold, italic) or …

Best,  
Zane /support@eazyBI.com

---

_[View the full topic](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012)._
