If condition for assignee's manager wide distribution

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!

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:

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