Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i am facing an issue while aggregating data based on hierarchy.
Requirement is like there are level 1 to level 4 managers and there are some issues assigned to them,i have to build a chart where it shows the issues count under each employee.
The challenge i am facing is whenever the user selects level for ex.if user selects level 4 total issues assigned to each employees should show but when user selects level3 ,the counts of level4 employees should show under level 3 managers same way for level2 and level1.
attaching the screen shot of data after hierarchy implementation .
thanks
shruthi
Not entirely sure I understand your scenario... Do you have a sample you can share with expected output?
hi expected output should be without filter
empnames,count
deepak,2
ashok,2
vikash,2
shubham,2
gupta,2
shruthi,2
if the user selects level3 expected output:
empnames,count
deepak,2
ashok,2
vikash,4
shubham,4
if the user selects level2
empnames,count
deepak,2
ashok,10
Sounds good about the expected output.... but are you able to share a sample. Images are not very helpful to work with
i don't see any excel attachment option here:(
below is the sample data,which looks exactly as the actual data i am working
issueid | empnames | levels | level1 | level2 | level3 | level4 |
12 | Deepak | 1 | Deepak | |||
13 | Ashok | 2 | Deepak | Ashok | ||
14 | vikash | 3 | Deepak | Ashok | vikash | |
15 | shruthi | 4 | Deepak | Ashok | vikash | shruthi |
16 | gupta | 4 | Deepak | Ashok | shubham | gupta |
6 | shubham | 3 | Deepak | Ashok | shubham | |
43 | Deepak | 1 | Deepak | |||
78 | Ashok | 2 | Deepak | Ashok | ||
7 | vikash | 3 | Deepak | Ashok | vikash | |
5 | shruthi | 4 | Deepak | Ashok | vikash | shruthi |
1 | gupta | 4 | Deepak | Ashok | shubham | gupta |
42 | shubham | 3 | Deepak | Ashok | shubham |
attached the sample data