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.

HR data.xlsx

Luke_C

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