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.
Since eazyBI version 6.1 and on eazyBI Cloud there is an option to create a custom hierarchy 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 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:
Name of Assignee as you see it in eazyBI
some other user property if you like.
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.
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) or watch on YouTube: