# How to create a Team of assignees **URL:** \ **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:** 9\ **Page:** 1
**Author:** ![Nina\_Blumel](https://community.eazybi.com/user_avatar/community.eazybi.com/nina_blumel/32/2016_2.png) [@Nina\_Blumel](https://community.eazybi.com/u/Nina_Blumel)\ **Post date:** [October 18, 2019, 8:29am UTC](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/1 "2019-10-18T08:29:08Z")
Hi, I am trying to group assignees to a Team. Is that possible at all? I will give you some more insight in my problem. I have 5 Teams. Lets call them A, B, C, D and E but there is no field where they are named in JIRA. So I want to calculate them form the Assignees. I have 10 diffrent assigness. Lets name them 1, 2, 3, 4, 5, and 6. In the Team are the following assignees: Team A: Assignee 1 and 2 Team B: Assignee 3, 4 and 5 Team C: Assignee 6 Team D: All other assigness (7, 8, 9, 10 - but there shouldn’t be the names inside as there are actually around 50 people in the Team) Team E: “unassigned” At the end I would like to have a report of all open Tickets per Team and Priority. Thank you for sugestions how to solve this. ---
**Author:** ![EdP](https://community.eazybi.com/letter_avatar_proxy/v4/letter/e/ea5d25/32.png) [@EdP](https://community.eazybi.com/u/EdP)\ **Post date:** [January 28, 2020, 8:44pm UTC](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/2 "2020-01-28T20:44:36Z")
Did you ever figure this out? I have a similar need. ---
**Author:** ![Nina\_Blumel](https://community.eazybi.com/user_avatar/community.eazybi.com/nina_blumel/32/2016_2.png) [@Nina\_Blumel](https://community.eazybi.com/u/Nina_Blumel)\ **Post date:** [January 29, 2020, 6:58am UTC](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/3 "2020-01-29T06:58:26Z")
I created a new custom field named Team. Still have to update it manually but it does what we need it for. ---
**Author:** ![EdP](https://community.eazybi.com/letter_avatar_proxy/v4/letter/e/ea5d25/32.png) [@EdP](https://community.eazybi.com/u/EdP)\ **Post date:** [January 29, 2020, 12:20pm UTC](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/4 "2020-01-29T12:20:04Z")
Thanks for getting back to me. New field in Jira or did you do data customization in EsayBI? ---
**Author:** ![Nina\_Blumel](https://community.eazybi.com/user_avatar/community.eazybi.com/nina_blumel/32/2016_2.png) [@Nina\_Blumel](https://community.eazybi.com/u/Nina_Blumel)\ **Post date:** [January 29, 2020, 12:33pm UTC](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/5 "2020-01-29T12:33:57Z")
A new field in JIRA. ---
**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")
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 ---
**Author:** ![MuratOz](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/a88e57/32.png) [@MuratOz](https://community.eazybi.com/u/MuratOz)\ **Post date:** [January 22, 2022, 8:55am UTC](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/7 "2022-01-22T08:55:26Z")
Hi Zane, I tried above steps, created xls file to import. When it start importing threw an error. ![Screen Shot 2022-01-22 at 11.53.57](https://community.eazybi.com/uploads/default/original/2X/7/745c7a7763570c50a0badafe8a4f8f5245cf281d.png) ---
**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:** [January 24, 2022, 9:01am UTC](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/8 "2022-01-24T09:01:57Z")
Hi @MuratOz, you might want to select the mapping criteria **Name column** and **Skip missing** as it is shown in the example. > [@zane.baranovska](#): > > ![Assignee Team](https://community.eazybi.com/uploads/default/original/2X/6/67a44a2ac2f8acc9480487d178c5672417cefdbd.jpeg) Check out also this post on how to prepare the excel file with correct user names: > [@Import properties for Jira Assignees and build custom hierarchy](https://community.eazybi.com/t/import-properties-for-jira-assignees-and-build-custom-hierarchy/8624): > > eazyBI allows [importing additional properties](https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube) for dimensions and [creating custom hierarchies](https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-AddcustomhierarchiestospecificJira,Confluence,andInsightdimensions). In this example, I will walk you through how to define and import property Department for Assignee and build a custom hierarchy in the dimension Assignee. You can use the same steps to add more details for assignees or any other user dimension. Create a list of users for your source data. You can use eazyBI as a basis to create your data source. Create a new empty report in eazyBI. Use Transition Auth… ---
**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:** [February 2, 2023, 12:24pm UTC](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/9 "2023-02-02T12:24:03Z")
In addition there is a training video on how to import additional data (like user team) and build custom hierarchies based on those additional data. You can find video and presentation PDF on eazyBI documentation ([Training videos on specific topics](https://docs.eazybi.com/eazybi/learn-more/training-videos/training-videos-on-specific-topics#Trainingvideosonspecifictopics-Power-UpReportsWithAdditionalDataImport)) or watch on YouTube: [![](https://community.eazybi.com/uploads/default/original/2X/c/c6189d6ab0832e672f3db0502225445cde58be53.jpeg "6 Power Up Reports With External Data") ](https://www.youtube.com/watch?v=J0N97zQIMfM)