Hello my fellow Alteryx Community supporters,
I need your help!
I'm in the process of creating a workflow/macro that can be used to derive 'personas' from relevant datasets. However, when I try to create a '% of Total' column with the persona results, it's not giving me the correct calculation (i.e. % of Total).
Where I can use some support:
Preview of my workflow:
Preview of my formula:
Preview of my results output:
Thanks for your help in advance!
Respectfully,
Corey
Solved! Go to Solution.
Hello @CoreyS ,
If you do a count what it will do is count you the amount of lines it has in total.
Maybe what you are looking for is instead of using a count tool, to use a summarize, grouping by "personas" , add a count on the summarize tool too and then join the data to the rest.
Regards
Hi @afv2688,
Your guidance worked. Thanks for your support!
Preview of updated result:
Respectfully,
Corey
Hi @afv2688,
My apologies, I accidentally accepted my own reply as the solution instead of yours. You are the solution maker here.
Thanks again!
Respectfully,
Corey
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |