Easy way to create org chart with only employee ID and supervisor employee ID (and names)?

[alya1]

Hi everyone, 

Many custom visualizations require levels but I have a list of 3000 people as below:

Employee Name	Employee ID	Supervisor Employee Name	Supervisor Employee ID
Abby	123	Jane	111
Jane	111	James	321
Bobby	567	James	321

etc.

Does anyone know of a way to create organization chart just from these details? Or how to add levels to table above?

Thank you!

[lbendlin]

You use the PATH functions for that.  Beware:  Your Supervisor Employee IDs MUST also appear in the Employee ID column.

[alya1]

Hey lbendlin! Yeah I tried to follow https://medium.com/@gulcekincrk/have-you-ever-wondered-how-to-create-an-organizational-hierarchy-in-...
But my results for Path column is just the employee ID and Level1 is also just employee ID 😞 

[lbendlin]

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[alya1]

Ah, it's a bit difficult to create an encompassing sample data due to amount/uniqueness of actual data, my apologies. But I deleted a bunch of rows in the actualy data and the PATH function works now! Since I have 9 levels in total but since all IDs are 3-6 numbers long and there is no "1," do you know of a custom visual org chart that can display my data?

[lbendlin]

please parse the Visuals store for hierachy slicers or org chart visuals.