% of Total Column

[CoreyS]

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:

1. Am I doing this correctly?
2. 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 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

[CoreyS · Accepted solution]

Hi @afv2688,

Your guidance worked. Thanks for your support!

Preview of updated result:

 Respectfully,

Corey

[CoreyS]

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