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.
Perhaps multiple LOOKUPVALUE's along with a CONCATENATE or CONCATENATEX?
Not entirely sure how you want to return these, but something along the lines of:
MyLookup = CONCATENATE(
CONCATENATE(
LOOKUPVALUE([Supervisor],[Employee Name],"Meeta Jangde"),
"--->"
), LOOKUPVALUE([Project Manager],[Employee Name],"Meeta Jangde")
)Sorry for the wrong exaplanation Greg_Deckler
You completely got wrong.
I jus need to get the hierarchy, not with those lines.
I have jus shown you how the hierarchy should return whenever i choose a Employee Name
So how do you want that returned? In a table, a list of values?