Forum Discussion
Exploring Social Network graph Usage
Dear Anonymous, Abduvali,
Ok, I'll share with step by step:
- Create 4 new colum:
Path = PATH(Employees[EmployeeName],Employees[ManagerName])
Level 1 = PATHITEM(Employees[Path],1)
Level 2 = PATHITEM(Employees[Path],2)
Level 3 = PATHITEM(Employees[Path],3)
- Create new "Emp Hierarchy" on Level 1. Then get Level 2 and 3 into this Hierarchy.
- Download the Journey Chart. Put "Emp Hierarchy" in "Category Data", Salary in "Measure Data"
- Make sure your Filter Emp with Level 3.
That's it!
If you need some help, don't be hesitate tag my name in your topic. I'll try if i can.
Regards,
ManNVSM.
Anonymous Absolutely. :heart:
Thats exactly what i need to get.
But it should be connected.
Like in this table if you see,
No Name Manager ID
1 A
2 B 1
3 C 2
4 D 3
5 E 3
6 F 4
7 G 6
8 H 6
If i choose A...He is at top level because he is not having any manager ID so for him we need to show
the lower level hierarchy that how everyone is connected to each other.
If i choose E... then we need to show his upper level hierarchy ie E connected to C, C connected to B, and B connected to 1
and also his lower hierarchy if present. For E theres no lower hierarchy.
But for F we have the lower and upper hierarchy.
this is what i am trying to implement.
Dear Anonymous,
It's seem i reach your heart (just kidding).
Ok, i have an idea and i need to make some test. I'll be right back.
Regards,
ManNVSM.