Reporting Structure Hierarchy
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello guys!
I was wondering if anyone could give a heads up or maybe show me a partial solution to this question.
Below you will find a task and an attachment of the dataset.
Task:
The provided dataset (in attachment) lists employee information including their employee ID as well as the ID of their manager. Every employee has a manager except the CEO whose manager ID value is null. HR wants to understand the reporting structure hierarchy within the company. How many employees have 3 reporting levels between themselves and the CEO not including their own level and that of the CEO?
Kind regards,
Alexander
- Labels:
- Macros
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Check this macro out https://community.alteryx.com/t5/Public-Community-Gallery/Hierarchy-Generation-Macro/ta-p/880709
Check this weekly challenge you might find workflow which might work for you https://community.alteryx.com/t5/Weekly-Challenge/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AlexanderHolzer , I was looking into this data set , though right now it is difficult for me to deal with it in Alteryx.
But here find my solution in Excel itself might it will help you.
Hint:-
- You need to take the manager Id and match it with Employee ID to find the respective manager name for Each Employee ID
- Repeat the same process for 3 Reporting levels.(u can use the find replace or Join tool to find it out😜)
- for the CEO not included u needs to go 4 levels and exclude level 1st hierarchy where CEO is not included.
feel free to connect anytime.
@atcodedog05 has provided the best links to look into it and learn from it. keep it handy for future reference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
111
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AlexanderHolzer ,
Assuming that the reporting levels will not be a large number, I think you can achieve what you need by using JOIN, no need for macro.
Attached workflow for your reference.
Hope it helps.
Best Regards,
Lelia
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ncrlelia Could you explain step by step? I got lost in your reasoning.
