If condition for assignee's manager wide distribution

[VBGYOR]

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!

[gerda.grantina]

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, 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

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…

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

Best,
Gerda // support@eazyBI.com