how many employee have 3 reporting level between themselves?

[Kaustubh17]

Hi Alteryx team,

I am new in alteryx i am facing problem in solving this question. I want to find employee who have 3 reporting level between them but i am confused how i can proceed with that. I am attaching the excel file so that you guys can solve and explain the it how we can solve this type of query.

[Luke_C · Accepted solution]

Hi @Kaustubh17 

Here's a weekly challenge that tackles creating the hierarchy. Perhaps you can adapt the solution to filter down to the criteria you want?

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740

[Kaustubh17]

Hi @Luke_C 

You suggested link help me a lot to resolve my problem.

Thanks,

Kaustubh