Getting counts of people - Complex
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AngelosPachis ,
Yes i understand. Thank you so much for the help.
