Getting counts of people - Complex

[sriniprad08]

Hi Team,

I have a challenge . I would like to get the count of people occurring under each one of them.

For e.g in the attached pic . Email is the lowest hierarchy and H6 is the highest. people appearing under email reports to H1 and H1 reports to H2 and etc.. 

1) So i would like to have a count of people appearing under each one of them. For e.g under ne@gax.com there will be 29 people.

2) Once getting the count if possible in Alteryx if we click on the email id then it should show the complete hierarchy with counts.

Please let me know is there a way to get this. thanks,

[AngelosPachis · Accepted solution]

Hi @sriniprad08 ,

Can you check if this workflow works for you?

[sriniprad08]

Hi @AngelosPachis 

Thank you so much. Great help. Is it possible for the second step like

if i click on the output any of the email i should get the how the counts are spread . For e.g

ne@gax.com - 29 . so if i click on ne@gax.com i should get who all under him (means the distribution of 29).

Cheers,

Sri

[AngelosPachis]

Hi @sriniprad08 ,

I don't think that interactivity is available within Alteryx, or if it is I'm probably not aware of it. As an alternative, I can suggest you create a static table showing all the different names and the person they report to.

Cheers,

Angelos

[sriniprad08]

Hi @AngelosPachis ,

Yes i understand. Thank you so much for the help.