Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Getting counts of people - Complex

sriniprad08
11 - Bolide

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,

sriniprad08_0-1611913768154.pngsriniprad08_1-1611913786819.png

 

4 REPLIES 4
AngelosPachis
16 - Nebula

Hi @sriniprad08 ,

 

Can you check if this workflow works for you?

 

AngelosPachis_0-1611915823699.png

 

sriniprad08
11 - Bolide

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
16 - Nebula

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
11 - Bolide

Hi @AngelosPachis ,

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

Labels
Top Solution Authors