Issues showing the count under each manager

[manya]

I’m working on a report in which I want to make something that lists the number of tickets under each director (a list of all his managers’ teams) and manager (a list of all employees under his/her organization) with an unresolved status.
For instance, I would like to know how many tickets are assigned to each manager’s team. I would also like to check how many tickets are open under each director or lead.
I would appreciate any assistance.

[gerda.grantina]

Hello @manya
You can import the assignee manager as a property in the Assignee dimension and then create a new custom hierarchy Manager name in the Assignee dimension.
See instruction on how to do it here:

How to create a Team of assignees

Hi there, 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 addit…

After that, you can create a calculated member in the Assignee dimension Manager name hierarchy for each director like this:

Aggregate({
  [Assignee.Manager name].[Anna Linda],
  [Assignee.Manager name].[Imported manager name]
})

In the report, then select those calculated members and expand them to see all users:

best,
Gerda // support@eazybi.com