Hello all,
My client is currently able to view hours logged by individual users using the Logged By dimension. What they now need is to be able to view those users in a hierarchical view based on their groups, ideally being able to expand from the top parent-groups, child-groups, users in groups. I’ve worked with the Logged By Group dimension, but it only shows the flattened group membership. Ideally, we will be able to expand the top parent-group, then its sub-groups, then its sub-groups, and so on until we get to the users. Only a specific set of groups will be in-scope, e.g. we do not need the jira-users group. Below is a representation of what we need:
Logged by |Hours
|
group-top |120
|
group-middle1 |80
| |
| group-bottom1 |30
| | |
| | user01 |10
| | user02 |10
| | user03 |10
| |
| group-bottom2 |20
| | |
| | user04 |10
| | user05 |10
| |
| group-bottom3 |30
| |
| user06 |10
| user07 |10
| user08 |10
|
group-middle2 |40
|
group-bottom4 |20
| |
| user09 |5
| user10 |5
| user11 |5
| user12 |5
|
group-bottom5 |20
|
group-bottom-bottom1 |10
| |
| user13 |5
| user14 |5
|
group-bottom-bottom2 |10
|
user13 |5
user14 |5
I have been able to the pull the users and groups that I want to with SQL, but I can’t seem to map the values to the ‘Logged by’ or ‘Logged by Group’ dimensions, and those dimensions don’t support hierarchies anyways. I appreciate any and all help.