% of Total Column

Question

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:

* Am I doing this correctly?
* Are there better ways to do this?

Preview of my workflow:

Preview of my formula:

Preview of my results output:

Thanks for your help in advance!

Respectfully,

Corey

afv2688 · Accepted Answer

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

CoreyS · Accepted Answer

Hi @afv2688,

Your guidance worked. Thanks for your support!

Preview of updated result:

Respectfully,

Corey