Getting counts of people - Complex

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,

ww.xlsx

Datasets

Common Use Cases

Accepted answers

AngelosPachis

Hi @sriniprad08 ,

Can you check if this workflow works for you?

example.yxmd

All comments

AngelosPachis

Hi @sriniprad08 ,

Can you check if this workflow works for you?

example.yxmd

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703